========================2019-11-25 08:13:01======================== noteurl_start parm_app_code = 046 parm_pc_name = PRO18-09-28-55 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E0D55E79AB347CA4EDF7 sCDKey = 847210892454 sName = PRO18-09-28-55 ========================2019-11-25 08: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 = '847210892454' AND r.app_code = '046' AND r.app_block = 0 ========================2019-11-25 08:13:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'anwnwpdlf322' ========================2019-11-25 08:13:01======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E79AB347CA4EDF7' AND app_code = '046' ========================2019-11-25 08:13:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303637' ========================2019-11-25 08:13:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '303637' ========================2019-11-25 08: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 ( '303637', 'E0D55E79AB347CA4EDF7', '046', 'PRO18-09-28-55', '110', '1536', '864', 'anwnwpdlf322', '무주제일건재[이승훈]', '847210892454' ) ========================2019-11-25 09:35:47======================== 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-11-25 09:35: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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2019-11-25 09:35:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2019-11-25 09:35:47======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A832E380151477' AND app_code = '046' ========================2019-11-25 09:35:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298145' ========================2019-11-25 09:35:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298145' ========================2019-11-25 09:35:47======================== UPDATE mac_detail SET pc_name = 'COM', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]', screen_w = '1920', screen_h = '1080', cdkey = '342918991698' WHERE mac_idx = '298145' ========================2019-11-25 10:48:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0JEK6G3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D818D22360AE8 sCDKey = 748873380621 sName = DESKTOP-0JEK6G3 ========================2019-11-25 10:48:00======================== 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 = '748873380621' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 10:48:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0JEK6G3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D818D22360AE8 sCDKey = 748873380621 sName = DESKTOP-0JEK6G3 ========================2019-11-25 10:48: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 = '748873380621' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 10:49:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0JEK6G3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D818D22360AE8 sCDKey = 748873380621 sName = DESKTOP-0JEK6G3 ========================2019-11-25 10:49: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 = '748873380621' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 10:50:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0JEK6G3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D818D22360AE8 sCDKey = 748873380621 sName = DESKTOP-0JEK6G3 ========================2019-11-25 10:50: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 = '748873380621' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 10:50:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs396' ========================2019-11-25 10:50:48======================== SELECT idx FROM macs WHERE mac_addr = '9883892D818D22360AE8' AND app_code = '039' ========================2019-11-25 10:50:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303612' ========================2019-11-25 10:50:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '303612' ========================2019-11-25 10:50:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '303612', '9883892D818D22360AE8', '039', 'DESKTOP-0JEK6G3', '110', '1366', '768', 'bs396', '거흥중기[이윤복]', '748873380621' ) ========================2019-11-25 10:50:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0JEK6G3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D818D22360AE8 sCDKey = 748873380621 sName = DESKTOP-0JEK6G3 ========================2019-11-25 10:50: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 = '748873380621' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 10:51:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0JEK6G3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D818D22360AE8 sCDKey = 748873380621 sName = DESKTOP-0JEK6G3 ========================2019-11-25 10:51:17======================== 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 = '748873380621' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 14:17:09======================== noteurl_start parm_app_code = 039 parm_pc_name = ANNA-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067BAEBDFB2760122 sCDKey = 709587284577 sName = ANNA-PC ========================2019-11-25 14:17: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 = '709587284577' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 14:17:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyein1127' ========================2019-11-25 14:17:09======================== SELECT idx FROM macs WHERE mac_addr = '003067BAEBDFB2760122' AND app_code = '039' ========================2019-11-25 14:17:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248781' ========================2019-11-25 14:17:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248781' ========================2019-11-25 14:17:09======================== UPDATE mac_detail SET pc_name = 'ANNA-PC', os_type = '110', user_id = 'hyein1127', user_name = '[황혜인]', screen_w = '1920', screen_h = '1080', cdkey = '709587284577' WHERE mac_idx = '248781' ========================2019-11-25 16:32:06======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-AF1RAU423JJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E840F22A75666A7BC4A5 sCDKey = 129048108074 sName = WIN-AF1RAU423JJ ========================2019-11-25 16:32:06======================== 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 = '129048108074' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 16:32:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kgojkh' ========================2019-11-25 16:32:06======================== SELECT idx FROM macs WHERE mac_addr = 'E840F22A75666A7BC4A5' AND app_code = '039' ========================2019-11-25 16:32:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302346' ========================2019-11-25 16:32:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302346' ========================2019-11-25 16:32:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302346', 'E840F22A75666A7BC4A5', '039', 'WIN-AF1RAU423JJ', '110', '1920', '1080', 'kgojkh', '(주)원강테크닉스 [김지원]', '129048108074' ) ========================2019-11-25 16:52:36======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SUTN8A0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC22C1AA1B053 sCDKey = 116466244096 sName = DESKTOP-SUTN8A0 ========================2019-11-25 16:52: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 = '116466244096' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-25 16:52:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kpbox1' ========================2019-11-25 16:52:36======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC22C1AA1B053' AND app_code = '039' ========================2019-11-25 16:52:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303693' ========================2019-11-25 16:52:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '303693' ========================2019-11-25 16:52: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 ( '303693', 'F44D30BC22C1AA1B053', '039', 'DESKTOP-SUTN8A0', '110', '1920', '1080', 'kpbox1', '근풍실업[김혜숙]', '116466244096' )