========================2018-07-18 09:55:17======================== noteurl_start parm_app_code = 039 parm_pc_name = OWNER-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 1C1B0DB4E119AECD8748 sCDKey = 910583382474 sName = OWNER-PC ========================2018-07-18 09:55: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 = '910583382474' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-18 09:55:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'steel7989' ========================2018-07-18 09:55:17======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DB4E119AECD8748' AND app_code = '039' ========================2018-07-18 09:55:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253407' ========================2018-07-18 09:55:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253407' ========================2018-07-18 09:55:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253407', '1C1B0DB4E119AECD8748', '039', 'OWNER-PC', '90', '1600', '900', 'steel7989', '(주)이레강운[박선화]', '910583382474' ) ========================2018-07-18 11:36:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GI7SSF7 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883891922D91CD3735B sCDKey = 131722125192 sName = DESKTOP-GI7SSF7 ========================2018-07-18 11:36:50======================== 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 = '131722125192' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-18 11:37:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GI7SSF7 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883891922D91CD3735B sCDKey = 131722125192 sName = DESKTOP-GI7SSF7 ========================2018-07-18 11:37:57======================== 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 = '131722125192' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-18 11:41:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GI7SSF7 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883891922D91CD3735B sCDKey = 131722125192 sName = DESKTOP-GI7SSF7 ========================2018-07-18 11:41: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 = '131722125192' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-18 11:41:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodhoney' ========================2018-07-18 11:41:51======================== SELECT idx FROM macs WHERE mac_addr = '9883891922D91CD3735B' AND app_code = '039' ========================2018-07-18 11:41:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '227782' ========================2018-07-18 11:41:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '227782' ========================2018-07-18 11:41:51======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GI7SSF7', os_type = '110', user_id = 'goodhoney', user_name = '우성정보(주)[정기웅]', screen_w = '1366', screen_h = '768', cdkey = '131722125192' WHERE mac_idx = '227782' ========================2018-07-18 11:42:05======================== noteurl_start parm_app_code = 039 parm_pc_name = NT380E5J-KBF parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 98838916C0A4A459910D sCDKey = 131722125192 sName = NT380E5J-KBF ========================2018-07-18 11:42:05======================== 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 = '131722125192' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-18 11:42:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodhoney' ========================2018-07-18 11:42:05======================== SELECT idx FROM macs WHERE mac_addr = '98838916C0A4A459910D' AND app_code = '039' ========================2018-07-18 11:42:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '166653' ========================2018-07-18 11:42:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '166653' ========================2018-07-18 11:42:05======================== UPDATE mac_detail SET pc_name = 'NT380E5J-KBF', os_type = '110', user_id = 'goodhoney', user_name = '우성정보(주)[정기웅]', screen_w = '1366', screen_h = '768', cdkey = '131722125192' WHERE mac_idx = '166653' ========================2018-07-18 13:32:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BL67K4U parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 441CA84202C3A4A36B00 sCDKey = 076199019040 sName = DESKTOP-BL67K4U ========================2018-07-18 13:32: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 = '076199019040' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-18 13:32:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kt100722' ========================2018-07-18 13:32:09======================== SELECT idx FROM macs WHERE mac_addr = '441CA84202C3A4A36B00' AND app_code = '039' ========================2018-07-18 13:32:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '183165' ========================2018-07-18 13:32:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '183165' ========================2018-07-18 13:32: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 ( '183165', '441CA84202C3A4A36B00', '039', 'DESKTOP-BL67K4U', '110', '1600', '900', 'kt100722', '금탑주차장[김형석]', '076199019040' ) ========================2018-07-18 13:32:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BL67K4U parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 441CA84202C3A4A36B00 sCDKey = 076199019040 sName = DESKTOP-BL67K4U ========================2018-07-18 13:32:18======================== 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 = '076199019040' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-18 13:45:30======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04C3D0FC534627EBF sCDKey = 640146154677 sName = POS-PC ========================2018-07-18 13:45: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 = '640146154677' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-18 13:45:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sf5408' ========================2018-07-18 13:45:30======================== SELECT idx FROM macs WHERE mac_addr = '00E04C3D0FC534627EBF' AND app_code = '046' ========================2018-07-18 13:45:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254960' ========================2018-07-18 13:45:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254960' ========================2018-07-18 13:45: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 ( '254960', '00E04C3D0FC534627EBF', '046', 'POS-PC', '90', '1024', '768', 'sf5408', '호승식품[이명철]', '640146154677' ) ========================2018-07-18 13:46:05======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04C3D0FC534627EBF sCDKey = 640146154677 sName = 1번pos ========================2018-07-18 13:46:05======================== 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 = '640146154677' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-18 13:46:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sf5408' ========================2018-07-18 13:46:05======================== SELECT idx FROM macs WHERE mac_addr = '00E04C3D0FC534627EBF' AND app_code = '046' ========================2018-07-18 13:46:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254960' ========================2018-07-18 13:46:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254960' ========================2018-07-18 13:46:05======================== UPDATE mac_detail SET pc_name = '1번pos', os_type = '90', user_id = 'sf5408', user_name = '호승식품[이명철]', screen_w = '1024', screen_h = '768', cdkey = '640146154677' WHERE mac_idx = '254960' ========================2018-07-18 16:48:46======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732AF17DEE2B1141 sCDKey = 204076021100 sName = DESKTOP-IR4BE71 ========================2018-07-18 16:48: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 = '204076021100' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-18 16:48:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daon1004' ========================2018-07-18 16:48:46======================== SELECT idx FROM macs WHERE mac_addr = '50AF732AF17DEE2B1141' AND app_code = '046' ========================2018-07-18 16:48:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254982' ========================2018-07-18 16:48:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254982' ========================2018-07-18 16:48: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 ( '254982', '50AF732AF17DEE2B1141', '046', 'DESKTOP-IR4BE71', '110', '1024', '768', 'daon1004', '다온숲 (매점)[강형묵]', '204076021100' ) ========================2018-07-18 17:53:41======================== noteurl_start parm_app_code = 046 parm_pc_name = BONGHAK parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = F44D304EC66F2265D712 sCDKey = 340284741283 sName = BONGHAK ========================2018-07-18 17:53: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 = '340284741283' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-18 17:53:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hak79' ========================2018-07-18 17:53:41======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304EC66F2265D712' AND app_code = '046' ========================2018-07-18 17:53:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254993' ========================2018-07-18 17:53:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254993' ========================2018-07-18 17:53: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 ( '254993', 'F44D304EC66F2265D712', '046', 'BONGHAK', '110', '1600', '900', 'hak79', '[이봉학1]', '340284741283' ) ========================2018-07-18 20:09:22======================== noteurl_start parm_app_code = 046 parm_pc_name = PB-VCHJ7HQ0MQTV parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = C07CD1303B3DC0A59A4B sCDKey = 981323002872 sName = PB-VCHJ7HQ0MQTV ========================2018-07-18 20:09: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 = '981323002872' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-18 20:09:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'plusmart' ========================2018-07-18 20:09:22======================== SELECT idx FROM macs WHERE mac_addr = 'C07CD1303B3DC0A59A4B' AND app_code = '046' ========================2018-07-18 20:09:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255003' ========================2018-07-18 20:09:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255003' ========================2018-07-18 20:09:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '255003', 'C07CD1303B3DC0A59A4B', '046', 'PB-VCHJ7HQ0MQTV', '64', '1024', '768', 'plusmart', '플러스마트[김동진]', '981323002872' )