========================2019-04-12 00:01:45======================== noteurl_start parm_app_code = 039 parm_pc_name = YOUNGHUN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C4544484EAA774C7498D sCDKey = 807343105782 sName = YOUNGHUN ========================2019-04-12 00:01:45======================== 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 = '807343105782' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 00:07:31======================== noteurl_start parm_app_code = 039 parm_pc_name = YOUNGHUN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C4544484EAA774C7498D sCDKey = 807343105782 sName = YOUNGHUN ========================2019-04-12 00:07:31======================== 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 = '807343105782' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 00:12:52======================== noteurl_start parm_app_code = 039 parm_pc_name = YOUNGHUN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C4544484EAA774C7498D sCDKey = 807343105782 sName = kahve ========================2019-04-12 00: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 = '807343105782' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 00:17:27======================== noteurl_start parm_app_code = 039 parm_pc_name = YOUNGHUN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C4544484EAA774C7498D sCDKey = 807343105782 sName = YOUNGHUN ========================2019-04-12 00:17:27======================== 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 = '807343105782' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 00:25:12======================== noteurl_start parm_app_code = 039 parm_pc_name = YOUNGHUN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C4544484EAA774C7498D sCDKey = 807343105782 sName = 윤영훈 ========================2019-04-12 00:25:12======================== 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 = '807343105782' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 00:25:34======================== noteurl_start parm_app_code = 039 parm_pc_name = YOUNGHUN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C4544484EAA774C7498D sCDKey = 807343105782 sName = yoonh01 ========================2019-04-12 00:25:34======================== 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 = '807343105782' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 09:05:18======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732A4BFBA41C65F sCDKey = 292100950616 sName = USER-PC ========================2019-04-12 09:05: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 = '292100950616' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 09:05:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ppisystem' ========================2019-04-12 09:05:18======================== SELECT idx FROM macs WHERE mac_addr = '50AF732A4BFBA41C65F' AND app_code = '046' ========================2019-04-12 09:05:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235671' ========================2019-04-12 09:05:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235671' ========================2019-04-12 09:05:18======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'ppisystem', user_name = '대경종합상사[안희순]', screen_w = '1024', screen_h = '768', cdkey = '292100950616' WHERE mac_idx = '235671' ========================2019-04-12 10:34:24======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732CCDEFA41C65F sCDKey = 620623097096 sName = pos1 ========================2019-04-12 10:34:24======================== 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 = '620623097096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 10:35:00======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732CCDEFA41C65F sCDKey = 620623097096 sName = USER-PC ========================2019-04-12 10:35: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 = '620623097096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 10:35:12======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732CCDEFA41C65F sCDKey = 620623097096 sName = USER-PC ========================2019-04-12 10:35:12======================== 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 = '620623097096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 11:16:20======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732CCDEFA41C65F sCDKey = 620623097096 sName = USER-PC ========================2019-04-12 11:16:20======================== 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 = '620623097096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 11:16:29======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732CCDEFA41C65F sCDKey = 620623097096 sName = USER-PC ========================2019-04-12 11:16: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 = '620623097096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 11:17:00======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732CCDEFA41C65F sCDKey = 620623097096 sName = USER-PC ========================2019-04-12 11:17: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 = '620623097096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 11:18:34======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732CCDEFA41C65F sCDKey = 620623097096 sName = pos1 ========================2019-04-12 11:18:34======================== 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 = '620623097096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 11:18:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'diami' ========================2019-04-12 11:18:34======================== SELECT idx FROM macs WHERE mac_addr = '50AF732CCDEFA41C65F' AND app_code = '046' ========================2019-04-12 11:18:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275930' ========================2019-04-12 11:18:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275930' ========================2019-04-12 11:18:34======================== UPDATE mac_detail SET pc_name = 'pos1', os_type = '90', user_id = 'diami', user_name = '(주)샤인위드[김미원]', screen_w = '1024', screen_h = '768', cdkey = '620623097096' WHERE mac_idx = '275930' ========================2019-04-12 11:18:46======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732CCDEFA41C65F sCDKey = 620623097096 sName = pos1 ========================2019-04-12 11:18: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 = '620623097096' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 13:24:29======================== noteurl_start parm_app_code = 039 parm_pc_name = AUTOBVT-2 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883891CA7A9FB1D42F sCDKey = 979755277718 sName = AUTOBVT-2 ========================2019-04-12 13:24: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 = '979755277718' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 13:24:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dongmuh1' ========================2019-04-12 13:24:29======================== SELECT idx FROM macs WHERE mac_addr = '9883891CA7A9FB1D42F' AND app_code = '039' ========================2019-04-12 13:24:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283235' ========================2019-04-12 13:24:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283235' ========================2019-04-12 13:24: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 ( '283235', '9883891CA7A9FB1D42F', '039', 'AUTOBVT-2', '90', '1920', '1080', 'dongmuh1', '(주)아이유[박동무]', '979755277718' ) ========================2019-04-12 14:39:00======================== noteurl_start parm_app_code = 046 parm_pc_name = HD-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00238114F420C6E5380F sCDKey = 978886642020 sName = HD-PC ========================2019-04-12 14:39: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 = '978886642020' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 14:39:05======================== noteurl_start parm_app_code = 046 parm_pc_name = HD-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00238114F420C6E5380F sCDKey = 978886642020 sName = HD-PC ========================2019-04-12 14:39: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 = '978886642020' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 14:40:27======================== noteurl_start parm_app_code = 046 parm_pc_name = HD-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00238114F420C6E5380F sCDKey = 978886642020 sName = HD-PC ========================2019-04-12 14:40:27======================== 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 = '978886642020' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 14:41:00======================== noteurl_start parm_app_code = 046 parm_pc_name = HD-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00238114F420C6E5380F sCDKey = 978886642020 sName = HD-PC ========================2019-04-12 14:41: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 = '978886642020' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 14:41:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hdtss' ========================2019-04-12 14:41:00======================== SELECT idx FROM macs WHERE mac_addr = '00238114F420C6E5380F' AND app_code = '046' ========================2019-04-12 14:41:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283253' ========================2019-04-12 14:41:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283253' ========================2019-04-12 14:41:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283253', '00238114F420C6E5380F', '046', 'HD-PC', '110', '1920', '1080', 'hdtss', '현대공구상사[신동일]', '978886642020' ) ========================2019-04-12 15:37:10======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-CE6PB9S parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E06995C150A5C85748BF sCDKey = 304737735505 sName = DESKTOP-CE6PB9S ========================2019-04-12 15:37:10======================== 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 = '304737735505' AND r.app_code = '051' AND r.app_block = 0 ========================2019-04-12 15:37:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daeho5400' ========================2019-04-12 15:37:10======================== SELECT idx FROM macs WHERE mac_addr = 'E06995C150A5C85748BF' AND app_code = '051' ========================2019-04-12 15:37:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280917' ========================2019-04-12 15:37:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280917' ========================2019-04-12 15:37:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '280917', 'E06995C150A5C85748BF', '051', 'DESKTOP-CE6PB9S', '109', '1680', '1050', 'daeho5400', '(주)대호아이앤티[배혜진]', '304737735505' ) ========================2019-04-12 16:00:35======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 003067378F5A16D5B3AF sCDKey = 721073619364 sName = USER-PC ========================2019-04-12 16:00: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 = '721073619364' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 16:00:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'street6326' ========================2019-04-12 16:00:35======================== SELECT idx FROM macs WHERE mac_addr = '003067378F5A16D5B3AF' AND app_code = '039' ========================2019-04-12 16:00:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '217610' ========================2019-04-12 16:00:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '217610' ========================2019-04-12 16:00:35======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'street6326', user_name = '알투스[노송죽]', screen_w = '1680', screen_h = '1050', cdkey = '721073619364' WHERE mac_idx = '217610' ========================2019-04-12 16:00:41======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 003067378F5A16D5B3AF sCDKey = 721073619364 sName = USER-PC ========================2019-04-12 16:00: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 = '721073619364' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-12 17:26:21======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-NKLUSA0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838987BD078A3B632C sCDKey = 147236415063 sName = DESKTOP-NKLUSA0 ========================2019-04-12 17:26:21======================== 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 = '147236415063' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 17:26:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'interpet33' ========================2019-04-12 17:26:21======================== SELECT idx FROM macs WHERE mac_addr = '98838987BD078A3B632C' AND app_code = '046' ========================2019-04-12 17:26:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283268' ========================2019-04-12 17:26:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283268' ========================2019-04-12 17:26:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283268', '98838987BD078A3B632C', '046', 'DESKTOP-NKLUSA0', '110', '1920', '1080', 'interpet33', '인터펫코리아[오경미]', '147236415063' ) ========================2019-04-12 18:15:44======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA14FDBE6226AF6234 sCDKey = 768304081278 sName = POS2 ========================2019-04-12 18:15: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 = '768304081278' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-12 18:15:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ehdrb6310' ========================2019-04-12 18:15:44======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14FDBE6226AF6234' AND app_code = '046' ========================2019-04-12 18:15:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '190085' ========================2019-04-12 18:15:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '190085' ========================2019-04-12 18:15:44======================== UPDATE mac_detail SET pc_name = 'POS2', os_type = '90', user_id = 'ehdrb6310', user_name = '씨엔푸드[이동규]', screen_w = '1920', screen_h = '1080', cdkey = '768304081278' WHERE mac_idx = '190085'