========================2019-09-06 09:35:43======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-HF0J90M parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 3E95E4CE9CFE3AD14C57 sCDKey = 548696432089 sName = DESKTOP-HF0J90M ========================2019-09-06 09:35:43======================== 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 = '548696432089' AND r.app_code = '045' AND r.app_block = 0 ========================2019-09-06 09:35:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onco' ========================2019-09-06 09:35:43======================== SELECT idx FROM macs WHERE mac_addr = '3E95E4CE9CFE3AD14C57' AND app_code = '045' ========================2019-09-06 09:35:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238648' ========================2019-09-06 09:35:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238648' ========================2019-09-06 09:35:43======================== UPDATE mac_detail SET pc_name = 'DESKTOP-HF0J90M', os_type = '110', user_id = 'onco', user_name = 'onco/온코[은순조]', screen_w = '1536', screen_h = '864', cdkey = '548696432089' WHERE mac_idx = '238648' ========================2019-09-06 11:51:12======================== noteurl_start parm_app_code = 048 parm_pc_name = 관리 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00D8617258A7AC141A76 sCDKey = 853141265990 sName = 관리 ========================2019-09-06 11:51: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 = '853141265990' AND r.app_code = '048' AND r.app_block = 0 ========================2019-09-06 11:51:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjs120532' ========================2019-09-06 11:51:12======================== SELECT idx FROM macs WHERE mac_addr = '00D8617258A7AC141A76' AND app_code = '048' ========================2019-09-06 11:51:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '295582' ========================2019-09-06 11:51:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '295582' ========================2019-09-06 11:51:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '295582', '00D8617258A7AC141A76', '048', '관리', '�쐢�룄�슦 10', '0', '0', 'kjs120532', '서원상사[김종석]', '853141265990' ) ========================2019-09-06 11:56:36======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN7-PRO parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 24F5AABF41739261C1E3 sCDKey = 460224480685 sName = WIN7-PRO ========================2019-09-06 11:56: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 = '460224480685' AND r.app_code = '046' AND r.app_block = 0 ========================2019-09-06 11:59:06======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN7-PRO parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 24F5AABF41739261C1E3 sCDKey = 460224480685 sName = WIN7-PRO ========================2019-09-06 11:59: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 = '460224480685' AND r.app_code = '046' AND r.app_block = 0 ========================2019-09-06 11:59:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ykglobal' ========================2019-09-06 11:59:06======================== SELECT idx FROM macs WHERE mac_addr = '24F5AABF41739261C1E3' AND app_code = '046' ========================2019-09-06 11:59:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '140215' ========================2019-09-06 11:59:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '140215' ========================2019-09-06 11:59:06======================== UPDATE mac_detail SET pc_name = 'WIN7-PRO', os_type = '90', user_id = 'ykglobal', user_name = '영광수산[이영만]', screen_w = '1366', screen_h = '768', cdkey = '460224480685' WHERE mac_idx = '140215' ========================2019-09-06 15:30:56======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-FOR4OSG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 88532E7E3B9B281CA389 sCDKey = 188650376041 sName = DESKTOP-FOR4OSG ========================2019-09-06 15:30: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 = '188650376041' AND r.app_code = '047' AND r.app_block = 0 ========================2019-09-06 15:30:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2019-09-06 15:30:56======================== SELECT idx FROM macs WHERE mac_addr = '88532E7E3B9B281CA389' AND app_code = '047' ========================2019-09-06 15:30:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '295643' ========================2019-09-06 15:30:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '295643' ========================2019-09-06 15:30:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '295643', '88532E7E3B9B281CA389', '047', 'DESKTOP-FOR4OSG', '�쐢�룄�슦 10', '0', '0', 'parkstool', 'PARKS TOOL[박동훈]', '188650376041' ) ========================2019-09-06 17:50:28======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-3BC96KUN7M2 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 94DE804793FE907DE66C sCDKey = 636415060493 sName = WIN-3BC96KUN7M2 ========================2019-09-06 17:50:28======================== 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 = '636415060493' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-06 17:50:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cmo1020' ========================2019-09-06 17:50:28======================== SELECT idx FROM macs WHERE mac_addr = '94DE804793FE907DE66C' AND app_code = '039' ========================2019-09-06 17:50:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '295614' ========================2019-09-06 17:50:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '295614' ========================2019-09-06 17:50:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '295614', '94DE804793FE907DE66C', '039', 'WIN-3BC96KUN7M2', '90', '1600', '900', 'cmo1020', '대림철물공구[최미옥]', '636415060493' )