========================2018-06-27 05:04:03======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-1134QOR parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50465D6F6F884790935 sCDKey = 810135661075 sName = super1417 ========================2018-06-27 05:04:03======================== 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 = '810135661075' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-27 09:41:37======================== noteurl_start parm_app_code = 047 parm_pc_name = AHN-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 38D547280D736033E3EA sCDKey = 796194338244 sName = AHN-PC ========================2018-06-27 09:41:37======================== 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 = '796194338244' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-27 09:41:46======================== noteurl_start parm_app_code = 047 parm_pc_name = AHN-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 38D547280D736033E3EA sCDKey = 796194338244 sName = AHN-PC ========================2018-06-27 09:41:46======================== 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 = '796194338244' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-27 09:41:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-06-27 09:41:46======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D736033E3EA' AND app_code = '047' ========================2018-06-27 09:41:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '222103' ========================2018-06-27 09:41:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '222103' ========================2018-06-27 09:41:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '222103', '38D547280D736033E3EA', '047', 'AHN-PC', '�쐢�룄�슦 10', '0', '0', 'aej123456', '엠제이소프트[안은준]', '796194338244' ) ========================2018-06-27 10:06:29======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 00030DCC4831E7F39CE sCDKey = 545441335904 sName = USER-PC ========================2018-06-27 10:06:29======================== 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 = '545441335904' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-27 10:06:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vv09' ========================2018-06-27 10:06:29======================== SELECT idx FROM macs WHERE mac_addr = '00030DCC4831E7F39CE' AND app_code = '039' ========================2018-06-27 10:06:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252977' ========================2018-06-27 10:06:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252977' ========================2018-06-27 10:06:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252977', '00030DCC4831E7F39CE', '039', 'USER-PC', '90', '1280', '800', 'vv09', '영동유업[김은해]', '545441335904' ) ========================2018-06-27 13:18:40======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-V8HEQLM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 48BA4E61092E1E6A96EF sCDKey = 932847330830 sName = DESKTOP-V8HEQLM ========================2018-06-27 13:18:40======================== 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 = '932847330830' AND r.app_code = '045' AND r.app_block = 0 ========================2018-06-27 13:18:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chamnara' ========================2018-06-27 13:18:40======================== SELECT idx FROM macs WHERE mac_addr = '48BA4E61092E1E6A96EF' AND app_code = '045' ========================2018-06-27 13:18:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241591' ========================2018-06-27 13:18:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241591' ========================2018-06-27 13:18:40======================== UPDATE mac_detail SET pc_name = 'DESKTOP-V8HEQLM', os_type = '110', user_id = 'chamnara', user_name = '(주)참나라 농업회사법인[임준상]', screen_w = '1920', screen_h = '1080', cdkey = '932847330830' WHERE mac_idx = '241591' ========================2018-06-27 13:39:09======================== noteurl_start parm_app_code = 050 parm_pc_name = BONGHAK parm_os_type = 109 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = F44D304EC66F2265D712 sCDKey = 474771527128 sName = BONGHAK ========================2018-06-27 13:39:09======================== 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 = '474771527128' AND r.app_code = '050' AND r.app_block = 0 ========================2018-06-27 13:39:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hak79' ========================2018-06-27 13:39:09======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304EC66F2265D712' AND app_code = '050' ========================2018-06-27 13:39:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240036' ========================2018-06-27 13:39:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240036' ========================2018-06-27 13:39:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240036', 'F44D304EC66F2265D712', '050', 'BONGHAK', '109', '1600', '900', 'hak79', '[이봉학1]', '474771527128' ) ========================2018-06-27 13:59:08======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 4CCC6A0EA346F4F91D0D sCDKey = 696245314127 sName = USER ========================2018-06-27 13:59:08======================== 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 = '696245314127' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-27 13:59:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'udolko95' ========================2018-06-27 13:59:08======================== SELECT idx FROM macs WHERE mac_addr = '4CCC6A0EA346F4F91D0D' AND app_code = '039' ========================2018-06-27 13:59:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252989' ========================2018-06-27 13:59:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252989' ========================2018-06-27 13:59:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252989', '4CCC6A0EA346F4F91D0D', '039', 'USER', '90', '1600', '900', 'udolko95', '미래테크[유학정]', '696245314127' ) ========================2018-06-27 16:41:03======================== noteurl_start parm_app_code = 047 parm_pc_name = SEC parm_os_type = �쐢�룄�슦 8 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C3AA264FDE40B954 sCDKey = 853979398456 sName = SEC ========================2018-06-27 16:41:03======================== 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 = '853979398456' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-27 16:41:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdy3445' ========================2018-06-27 16:41:03======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AA264FDE40B954' AND app_code = '047' ========================2018-06-27 16:41:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253020' ========================2018-06-27 16:41:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253020' ========================2018-06-27 16:41:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253020', '50B7C3AA264FDE40B954', '047', 'SEC', '�쐢�룄�슦 8', '0', '0', 'kdy3445', '[대원]', '853979398456' ) ========================2018-06-27 17:15:35======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC2 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30481362C6B26CA3 sCDKey = 339466362279 sName = USER-PC2 ========================2018-06-27 17:15:35======================== 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 = '339466362279' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-27 17:15:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jn3124' ========================2018-06-27 17:15:35======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30481362C6B26CA3' AND app_code = '039' ========================2018-06-27 17:15:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253022' ========================2018-06-27 17:15:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253022' ========================2018-06-27 17:15:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253022', 'F44D30481362C6B26CA3', '039', 'USER-PC2', '90', '1920', '1080', 'jn3124', '영진수출포장[엄장영]', '339466362279' ) ========================2018-06-27 17:48:56======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-7KSGVSK parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 54EE759CEBA540A6701D sCDKey = 126502428795 sName = DESKTOP-7KSGVSK ========================2018-06-27 17:48:56======================== 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 = '126502428795' AND r.app_code = '050' AND r.app_block = 0 ========================2018-06-27 17:48:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dansung' ========================2018-06-27 17:48:56======================== SELECT idx FROM macs WHERE mac_addr = '54EE759CEBA540A6701D' AND app_code = '050' ========================2018-06-27 17:48:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253027' ========================2018-06-27 17:48:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253027' ========================2018-06-27 17:48:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253027', '54EE759CEBA540A6701D', '050', 'DESKTOP-7KSGVSK', '109', '1536', '864', 'dansung', '(주)단성[김연규]', '126502428795' )