========================2018-11-08 09:55:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-964T5EM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A89AA1BCE19AA4 sCDKey = 622586809641 sName = DESKTOP-964T5EM ========================2018-11-08 09:55:04======================== 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 = '622586809641' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-08 09:55:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'choiji803' ========================2018-11-08 09:55:04======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A89AA1BCE19AA4' AND app_code = '039' ========================2018-11-08 09:55:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267015' ========================2018-11-08 09:55:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267015' ========================2018-11-08 09:55:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '267015', '50B7C3A89AA1BCE19AA4', '039', 'DESKTOP-964T5EM', '110', '1920', '1080', 'choiji803', '경일산업[최종일]', '622586809641' ) ========================2018-11-08 10:01:41======================== noteurl_start parm_app_code = 046 parm_pc_name = XPPRO parm_os_type = 64 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 001CC49DB9527C1CE267 sCDKey = 794659223172 sName = XPPRO ========================2018-11-08 10:01: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 = '794659223172' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-08 10:01:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnjstjrdbxhd' ========================2018-11-08 10:01:41======================== SELECT idx FROM macs WHERE mac_addr = '001CC49DB9527C1CE267' AND app_code = '046' ========================2018-11-08 10:01:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266867' ========================2018-11-08 10:01:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266867' ========================2018-11-08 10:01:41======================== UPDATE mac_detail SET pc_name = 'XPPRO', os_type = '64', user_id = 'dnjstjrdbxhd', user_name = '롯데칠성음료만안점[김영미]', screen_w = '1280', screen_h = '1024', cdkey = '794659223172' WHERE mac_idx = '266867' ========================2018-11-08 10:54:38======================== noteurl_start parm_app_code = 039 parm_pc_name = KIMKYUNGHYUN-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 0C8BFD96419B2C1C3EBE sCDKey = 414564140616 sName = KIMKYUNGHYUN-PC ========================2018-11-08 10:54: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 = '414564140616' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-08 10:54:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hisync17' ========================2018-11-08 10:54:38======================== SELECT idx FROM macs WHERE mac_addr = '0C8BFD96419B2C1C3EBE' AND app_code = '039' ========================2018-11-08 10:54:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267026' ========================2018-11-08 10:54:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267026' ========================2018-11-08 10:54: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 ( '267026', '0C8BFD96419B2C1C3EBE', '039', 'KIMKYUNGHYUN-PC', '90', '1600', '900', 'hisync17', '송인테크[김경현]', '414564140616' ) ========================2018-11-08 14:36:03======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41DC2C9942362F3 sCDKey = 322460136018 sName = ADMINISTRATOR ========================2018-11-08 14:36:03======================== 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 = '322460136018' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-08 14:36:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gncjsgk' ========================2018-11-08 14:36:03======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41DC2C9942362F3' AND app_code = '046' ========================2018-11-08 14:36:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267070' ========================2018-11-08 14:36:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267070' ========================2018-11-08 14:36:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '267070', '68EDA41DC2C9942362F3', '046', 'ADMINISTRATOR', '90', '1024', '768', 'gncjsgk', '오성상회[이후종]', '322460136018' ) ========================2018-11-08 14:36:36======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41DC2C9942362F3 sCDKey = 322460136018 sName = ADMINISTRATOR ========================2018-11-08 14:36: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 = '322460136018' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-08 16:48:38======================== noteurl_start parm_app_code = 039 parm_pc_name = HOME-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 002522586475E86CBB55 sCDKey = 225075510617 sName = HOME-PC ========================2018-11-08 16:48: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 = '225075510617' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-08 16:51:07======================== noteurl_start parm_app_code = 039 parm_pc_name = HOME-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 002522586475E86CBB55 sCDKey = 225075510617 sName = HOME-PC ========================2018-11-08 16:51:07======================== 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 = '225075510617' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-08 16:51:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gyt6988' ========================2018-11-08 16:51:07======================== SELECT idx FROM macs WHERE mac_addr = '002522586475E86CBB55' AND app_code = '039' ========================2018-11-08 16:51:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267095' ========================2018-11-08 16:51:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267095' ========================2018-11-08 16:51:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '267095', '002522586475E86CBB55', '039', 'HOME-PC', '90', '1920', '1200', 'gyt6988', '기연테크[윤형석]', '225075510617' )