========================2019-11-05 09:08:48======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-08 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 68ECC5280B9AD851F447 sCDKey = 683156263623 sName = HBDS-08 ========================2019-11-05 09:08:48======================== 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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-05 09:08:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2019-11-05 09:08:48======================== SELECT idx FROM macs WHERE mac_addr = '68ECC5280B9AD851F447' AND app_code = '039' ========================2019-11-05 09:08:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249078' ========================2019-11-05 09:08:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249078' ========================2019-11-05 09:08:48======================== UPDATE mac_detail SET pc_name = 'HBDS-08', os_type = '110', user_id = 'bangchun', user_name = '한반도[이진석]', screen_w = '1920', screen_h = '1080', cdkey = '683156263623' WHERE mac_idx = '249078' ========================2019-11-05 10:01:30======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HS99GI0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A9F87AF06B16A4 sCDKey = 230217355060 sName = DESKTOP-HS99GI0 ========================2019-11-05 10:01:30======================== 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 = '230217355060' AND r.app_code = '046' AND r.app_block = 0 ========================2019-11-05 10:01:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'good4924' ========================2019-11-05 10:01:30======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A9F87AF06B16A4' AND app_code = '046' ========================2019-11-05 10:01:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302061' ========================2019-11-05 10:01:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302061' ========================2019-11-05 10:01:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302061', '50B7C3A9F87AF06B16A4', '046', 'DESKTOP-HS99GI0', '110', '1920', '1080', 'good4924', '신우테크[조차현]', '230217355060' ) ========================2019-11-05 10:01:35======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HS99GI0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A9F87AF06B16A4 sCDKey = 230217355060 sName = DESKTOP-HS99GI0 ========================2019-11-05 10:01: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 = '230217355060' AND r.app_code = '046' AND r.app_block = 0 ========================2019-11-05 11:13:01======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-AAFR7NM parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2C56DC3E263798D93AD1 sCDKey = 188650376041 sName = DESKTOP-AAFR7NM ========================2019-11-05 11:13:01======================== 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 = '188650376041' AND r.app_code = '047' AND r.app_block = 0 ========================2019-11-05 11:13:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2019-11-05 11:13:01======================== SELECT idx FROM macs WHERE mac_addr = '2C56DC3E263798D93AD1' AND app_code = '047' ========================2019-11-05 11:13:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302069' ========================2019-11-05 11:13:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302069' ========================2019-11-05 11:13:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302069', '2C56DC3E263798D93AD1', '047', 'DESKTOP-AAFR7NM', '�쐢�룄�슦 10', '0', '0', 'parkstool', 'PARKS TOOL[박동훈]', '188650376041' ) ========================2019-11-05 11:55:58======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2019-11-05 11:55:58======================== 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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-05 11:55:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hando77' ========================2019-11-05 11:55:58======================== SELECT idx FROM macs WHERE mac_addr = '98838981F74D76D7F1ED' AND app_code = '039' ========================2019-11-05 11:55:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235354' ========================2019-11-05 11:55:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235354' ========================2019-11-05 11:55:58======================== UPDATE mac_detail SET pc_name = 'HANDO', os_type = '110', user_id = 'hando77', user_name = '한도교역[한도교역]', screen_w = '1920', screen_h = '1080', cdkey = '173379187341' WHERE mac_idx = '235354' ========================2019-11-05 12:35:44======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-9I6QOPS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2C4D54587135E89AD544 sCDKey = 695746037546 sName = DESKTOP-9I6QOPS ========================2019-11-05 12:35:44======================== 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 = '695746037546' AND r.app_code = '047' AND r.app_block = 0 ========================2019-11-05 13:46:16======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDA73A2DE6A60AD3 sCDKey = 676155885448 sName = PC ========================2019-11-05 13:46:16======================== 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 = '676155885448' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-05 13:46:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeong017' ========================2019-11-05 13:46:16======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDA73A2DE6A60AD3' AND app_code = '039' ========================2019-11-05 13:46:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '296300' ========================2019-11-05 13:46:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '296300' ========================2019-11-05 13:46:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '296300', 'B8AEEDA73A2DE6A60AD3', '039', 'PC', '110', '1920', '1080', 'jeong017', '천안어닝산업[정문권]', '676155885448' ) ========================2019-11-05 13:57:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-G80L3VV parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E995DAC8BB4DF071F sCDKey = 227076155905 sName = DESKTOP-G80L3VV ========================2019-11-05 13:57:36======================== 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 = '227076155905' AND r.app_code = '046' AND r.app_block = 0 ========================2019-11-05 13:57:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kwangpal10' ========================2019-11-05 13:57:36======================== SELECT idx FROM macs WHERE mac_addr = 'B42E995DAC8BB4DF071F' AND app_code = '046' ========================2019-11-05 13:57:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302084' ========================2019-11-05 13:57:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302084' ========================2019-11-05 13:57:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302084', 'B42E995DAC8BB4DF071F', '046', 'DESKTOP-G80L3VV', '110', '1920', '1080', 'kwangpal10', '신영공구[손광현]', '227076155905' ) ========================2019-11-05 14:30:48======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-9I6QOPS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2C4D54587135E89AD544 sCDKey = 695746037546 sName = MALLGOER_COU ========================2019-11-05 14:30:48======================== 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 = '695746037546' AND r.app_code = '047' AND r.app_block = 0 ========================2019-11-05 14:33:41======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-9I6QOPS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2C4D54587135E89AD544 sCDKey = 695746037546 sName = MALLGOER_COU ========================2019-11-05 14:33:41======================== 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 = '695746037546' AND r.app_code = '047' AND r.app_block = 0 ========================2019-11-05 14:33:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'amoross' ========================2019-11-05 14:33:41======================== SELECT idx FROM macs WHERE mac_addr = '2C4D54587135E89AD544' AND app_code = '047' ========================2019-11-05 14:33:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302077' ========================2019-11-05 14:33:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302077' ========================2019-11-05 14:33:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302077', '2C4D54587135E89AD544', '047', 'MALLGOER_COU', '�쐢�룄�슦 10', '0', '0', 'amoross', '데르나(derna)[조성길]', '695746037546' )