========================2019-07-11 11:19:33======================== noteurl_start parm_app_code = 051 parm_pc_name = HEA002174 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC8385F36B2DBC805A62 sCDKey = 937740825227 sName = HEA002174 ========================2019-07-11 11:19:33======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '937740825227' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-11 11:19:43======================== noteurl_start parm_app_code = 051 parm_pc_name = HEA002174 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC8385F36B2DBC805A62 sCDKey = 937740825227 sName = HEA002174 ========================2019-07-11 11:19:43======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '937740825227' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-11 13:47:25======================== noteurl_start parm_app_code = 039 parm_pc_name = ST11191-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E09128E438883AEBA4 sCDKey = 622658319188 sName = ST11191-PC ========================2019-07-11 13:47:25======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '622658319188' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-11 13:47:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sj6953811' ========================2019-07-11 13:47:25======================== SELECT idx FROM macs WHERE mac_addr = '00E09128E438883AEBA4' AND app_code = '039' ========================2019-07-11 13:47:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290591' ========================2019-07-11 13:47:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290591' ========================2019-07-11 13:47:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290591', '00E09128E438883AEBA4', '039', 'ST11191-PC', '90', '1920', '1080', 'sj6953811', '(주)세종건축건업[이태규]', '622658319188' ) ========================2019-07-11 15:00:15======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-CB2QC0F parm_os_type = 109 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = ECA86BF589629A2C41E0 sCDKey = 453035850767 sName = DESKTOP-CB2QC0F ========================2019-07-11 15:00:15======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '453035850767' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-11 15:00:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'happyehwa' ========================2019-07-11 15:00:15======================== SELECT idx FROM macs WHERE mac_addr = 'ECA86BF589629A2C41E0' AND app_code = '050' ========================2019-07-11 15:00:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290603' ========================2019-07-11 15:00:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290603' ========================2019-07-11 15:00:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290603', 'ECA86BF589629A2C41E0', '050', 'DESKTOP-CB2QC0F', '109', '1600', '900', 'happyehwa', '이화영아원[김혜선]', '453035850767' ) ========================2019-07-11 16:59:51======================== noteurl_start parm_app_code = 046 parm_pc_name = GREEN2-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080\\0 parm_user_mac = B42E99580BDE2CD73914 sCDKey = 113225036173 sName = GREEN2-PC ========================2019-07-11 16:59:51======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '113225036173' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-11 17:00:32======================== noteurl_start parm_app_code = 046 parm_pc_name = GREEN2-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080\\0 parm_user_mac = B42E99580BDE2CD73914 sCDKey = 113225036173 sName = GREEN2-PC ========================2019-07-11 17:00:32======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '113225036173' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-11 17:00:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'green8280' ========================2019-07-11 17:00:32======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99580BDE2CD73914' AND app_code = '046' ========================2019-07-11 17:00:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290610' ========================2019-07-11 17:00:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290610' ========================2019-07-11 17:00:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290610', 'B42E99580BDE2CD73914', '046', 'GREEN2-PC', '110', '1920', '1080\\0', 'green8280', '그린종합상사[하순옥]', '113225036173' )