========================2020-07-09 09:33:07======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RMIOFPN parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = F4B5202528AAD458A007 sCDKey = 550811266227 sName = DESKTOP-RMIOFPN ========================2020-07-09 09:33: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 = '550811266227' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-09 09:33:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'zmsakxm' ========================2020-07-09 09:33:07======================== SELECT idx FROM macs WHERE mac_addr = 'F4B5202528AAD458A007' AND app_code = '046' ========================2020-07-09 09:33:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321476' ========================2020-07-09 09:33:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '321476' ========================2020-07-09 09:33: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 ( '321476', 'F4B5202528AAD458A007', '046', 'DESKTOP-RMIOFPN', '110', '1280', '1024', 'zmsakxm', '제일큰마트[이용택]', '550811266227' ) ========================2020-07-09 09:33:56======================== noteurl_start parm_app_code = 039 parm_pc_name = MASTER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 00245431C4C728ADBB7 sCDKey = 048089056617 sName = MASTER-PC ========================2020-07-09 09:33: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 = '048089056617' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-09 09:33:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoo8383' ========================2020-07-09 09:33:56======================== SELECT idx FROM macs WHERE mac_addr = '00245431C4C728ADBB7' AND app_code = '039' ========================2020-07-09 09:33:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320190' ========================2020-07-09 09:33:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320190' ========================2020-07-09 09:33:56======================== UPDATE mac_detail SET pc_name = 'MASTER-PC', os_type = '90', user_id = 'yoo8383', user_name = '세림건기[임재환]', screen_w = '1440', screen_h = '900', cdkey = '048089056617' WHERE mac_idx = '320190' ========================2020-07-09 10:17:22======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = D050997A9BCC8EC49231 sCDKey = 550811266227 sName = MSDN-SPECIAL ========================2020-07-09 10:17: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 = '550811266227' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-09 10:17:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'zmsakxm' ========================2020-07-09 10:17:22======================== SELECT idx FROM macs WHERE mac_addr = 'D050997A9BCC8EC49231' AND app_code = '046' ========================2020-07-09 10:17:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '162016' ========================2020-07-09 10:17:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '162016' ========================2020-07-09 10:17:22======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '90', user_id = 'zmsakxm', user_name = '제일큰마트[이용택]', screen_w = '1024', screen_h = '768', cdkey = '550811266227' WHERE mac_idx = '162016' ========================2020-07-09 13:08:41======================== noteurl_start parm_app_code = 046 parm_pc_name = KTJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 936245283016 sName = KTJ ========================2020-07-09 13:08: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 = '936245283016' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-09 13:08:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeong4023' ========================2020-07-09 13:08:42======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '046' ========================2020-07-09 13:08:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269824' ========================2020-07-09 13:08:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269824' ========================2020-07-09 13:08:42======================== UPDATE mac_detail SET pc_name = 'KTJ', os_type = '110', user_id = 'jeong4023', user_name = '[김태정]', screen_w = '1920', screen_h = '1080', cdkey = '936245283016' WHERE mac_idx = '269824' ========================2020-07-09 13:10:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IF2O4US parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04D29CE4F4E08CA88 sCDKey = 397768335853 sName = DESKTOP-IF2O4US ========================2020-07-09 13:10:53======================== 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 = '397768335853' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-09 13:10:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sch0817' ========================2020-07-09 13:10:53======================== SELECT idx FROM macs WHERE mac_addr = '18C04D29CE4F4E08CA88' AND app_code = '039' ========================2020-07-09 13:10:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321501' ========================2020-07-09 13:10:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '321501' ========================2020-07-09 13:10:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '321501', '18C04D29CE4F4E08CA88', '039', 'DESKTOP-IF2O4US', '110', '1920', '1080', 'sch0817', '금강카고크레인[신창환]', '397768335853' ) ========================2020-07-09 14:20:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VJFRTCM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D45D6445F806E80DEB46 sCDKey = 241713244619 sName = DESKTOP-VJFRTCM ========================2020-07-09 14:20:42======================== 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 = '241713244619' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-09 14:20:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunlight' ========================2020-07-09 14:20:42======================== SELECT idx FROM macs WHERE mac_addr = 'D45D6445F806E80DEB46' AND app_code = '039' ========================2020-07-09 14:20:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321513' ========================2020-07-09 14:20:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '321513' ========================2020-07-09 14:20:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '321513', 'D45D6445F806E80DEB46', '039', 'DESKTOP-VJFRTCM', '110', '1920', '1080', 'sunlight', '일광공업[김명희]', '241713244619' )