========================2019-09-24 10:45:02======================== noteurl_start parm_app_code = 047 parm_pc_name = PJH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 475643551819 sName = PJH ========================2019-09-24 10:45:02======================== 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 = '475643551819' AND r.app_code = '047' AND r.app_block = 0 ========================2019-09-24 10:45:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youi92' ========================2019-09-24 10:45:02======================== SELECT idx FROM macs WHERE mac_addr = '7085C2B92617DABAE9EC' AND app_code = '047' ========================2019-09-24 10:45:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280838' ========================2019-09-24 10:45:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280838' ========================2019-09-24 10:45:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '280838', '7085C2B92617DABAE9EC', '047', 'PJH', '�쐢�룄�슦 10', '0', '0', 'youi92', '[박주현]', '475643551819' ) ========================2019-09-24 13:12:52======================== noteurl_start parm_app_code = 046 parm_pc_name = COM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A832E380151477 sCDKey = 342918991698 sName = COM ========================2019-09-24 13:12:52======================== 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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2019-09-24 13:12:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2019-09-24 13:12:52======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A832E380151477' AND app_code = '046' ========================2019-09-24 13:12:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298145' ========================2019-09-24 13:12:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298145' ========================2019-09-24 13:12:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298145', '50B7C3A832E380151477', '046', 'COM', '110', '1920', '1080', 'jun9317718', '한농연농자재영농조합법인[전종석]', '342918991698' ) ========================2019-09-24 13:26:40======================== noteurl_start parm_app_code = 050 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 88366CFC22E9A2516CFF sCDKey = 734290493833 sName = USER-PC ========================2019-09-24 13:26: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 = '734290493833' AND r.app_code = '050' AND r.app_block = 0 ========================2019-09-24 13:26:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ajckorea' ========================2019-09-24 13:26:40======================== SELECT idx FROM macs WHERE mac_addr = '88366CFC22E9A2516CFF' AND app_code = '050' ========================2019-09-24 13:26:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298147' ========================2019-09-24 13:26:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298147' ========================2019-09-24 13:26:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298147', '88366CFC22E9A2516CFF', '050', 'USER-PC', '90', '1440', '900', 'ajckorea', '코아비스[안재찬]', '734290493833' ) ========================2019-09-24 14:38:14======================== noteurl_start parm_app_code = 047 parm_pc_name = USER-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D017C289056F146286CE sCDKey = 186774962276 sName = USER-PC ========================2019-09-24 14:38:14======================== 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 = '186774962276' AND r.app_code = '047' AND r.app_block = 0 ========================2019-09-24 14:38:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssangma9925' ========================2019-09-24 14:38:14======================== SELECT idx FROM macs WHERE mac_addr = 'D017C289056F146286CE' AND app_code = '047' ========================2019-09-24 14:38:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298165' ========================2019-09-24 14:38:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298165' ========================2019-09-24 14:38:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298165', 'D017C289056F146286CE', '047', 'USER-PC', '�쐢�룄�슦 7', '0', '0', 'ssangma9925', '쌍마장갑안전[유현민]', '186774962276' ) ========================2019-09-24 14:41:47======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PUVV8MJ parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A402B99DC98EC016F7D3 sCDKey = 921252470168 sName = DESKTOP-PUVV8MJ ========================2019-09-24 14:41:47======================== 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 = '921252470168' AND r.app_code = '046' AND r.app_block = 0 ========================2019-09-24 14:41:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2019-09-24 14:41:47======================== SELECT idx FROM macs WHERE mac_addr = 'A402B99DC98EC016F7D3' AND app_code = '046' ========================2019-09-24 14:41:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250285' ========================2019-09-24 14:41:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250285' ========================2019-09-24 14:41:47======================== UPDATE mac_detail SET pc_name = 'DESKTOP-PUVV8MJ', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1536', screen_h = '864', cdkey = '921252470168' WHERE mac_idx = '250285' ========================2019-09-24 16:20:22======================== noteurl_start parm_app_code = 046 parm_pc_name = HJH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 737376171670 sName = HJH-PC ========================2019-09-24 16:20:22======================== 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 = '737376171670' AND r.app_code = '046' AND r.app_block = 0 ========================2019-09-24 16:20:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2019-09-24 16:20:22======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '046' ========================2019-09-24 16:20:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244420' ========================2019-09-24 16:20:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244420' ========================2019-09-24 16:20:22======================== UPDATE mac_detail SET pc_name = 'HJH-PC', os_type = '110', user_id = 'wogus36', user_name = '[황재현]', screen_w = '1920', screen_h = '1080', cdkey = '737376171670' WHERE mac_idx = '244420' ========================2019-09-24 16:34:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1U08AFU parm_os_type = 110 parm_screen_w = 1344 parm_screen_h = 840 parm_user_mac = 9883898921428A3B632C sCDKey = 699676022619 sName = DESKTOP-1U08AFU ========================2019-09-24 16:34:38======================== 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 = '699676022619' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-24 16:34:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ko613200' ========================2019-09-24 16:34:38======================== SELECT idx FROM macs WHERE mac_addr = '9883898921428A3B632C' AND app_code = '039' ========================2019-09-24 16:34:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298190' ========================2019-09-24 16:34:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298190' ========================2019-09-24 16:34:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '298190', '9883898921428A3B632C', '039', 'DESKTOP-1U08AFU', '110', '1344', '840', 'ko613200', '대경산업[이숙자]', '699676022619' )