========================2022-10-21 09:34:03======================== 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 = 705A0F92E108A4A36B00 sCDKey = 076199019040 sName = DESKTOP-BL67K4U ========================2022-10-21 09:34: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 = '076199019040' AND r.app_code = '039' AND r.app_block = 0 ========================2022-10-21 09:34:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kt100722' ========================2022-10-21 09:34:03======================== SELECT idx FROM macs WHERE mac_addr = '705A0F92E108A4A36B00' AND app_code = '039' ========================2022-10-21 09:34:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '183207' ========================2022-10-21 09:34:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '183207' ========================2022-10-21 09:34:03======================== UPDATE mac_detail SET pc_name = 'DESKTOP-BL67K4U', os_type = '110', user_id = 'kt100722', user_name = '금탑주차장[김형석]', screen_w = '1600', screen_h = '900', cdkey = '076199019040' WHERE mac_idx = '183207' ========================2022-10-21 10:43:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-U3FTUAK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D85ED3DC740C328D83A4 sCDKey = 149565056571 sName = DESKTOP-U3FTUAK ========================2022-10-21 10:43:01======================== 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 = '149565056571' AND r.app_code = '039' AND r.app_block = 0 ========================2022-10-21 10:43:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'zlzl0313' ========================2022-10-21 10:43:01======================== SELECT idx FROM macs WHERE mac_addr = 'D85ED3DC740C328D83A4' AND app_code = '039' ========================2022-10-21 10:43:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '375888' ========================2022-10-21 10:43:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '375888' ========================2022-10-21 10:43:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '375888', 'D85ED3DC740C328D83A4', '039', 'DESKTOP-U3FTUAK', '110', '1920', '1080', 'zlzl0313', '중앙모타[김진수]', '149565056571' ) ========================2022-10-21 13:11:06======================== noteurl_start parm_app_code = 046 parm_pc_name = HJNAIL1-PC parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = FCAA14C79097D018FE20 sCDKey = 547491127013 sName = HJNAIL1-PC ========================2022-10-21 13:11: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 = '547491127013' AND r.app_code = '046' AND r.app_block = 0 ========================2022-10-21 13:11:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjnailmall' ========================2022-10-21 13:11:06======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14C79097D018FE20' AND app_code = '046' ========================2022-10-21 13:11:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '375901' ========================2022-10-21 13:11:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '375901' ========================2022-10-21 13:11:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '375901', 'FCAA14C79097D018FE20', '046', 'HJNAIL1-PC', '110', '1600', '900', 'hjnailmall', '화정네일몰[이영미]', '547491127013' ) ========================2022-10-21 13:11:12======================== noteurl_start parm_app_code = 046 parm_pc_name = HJNAIL1-PC parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = FCAA14C79097D018FE20 sCDKey = 547491127013 sName = HJNAIL1-PC ========================2022-10-21 13:11: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 = '547491127013' AND r.app_code = '046' AND r.app_block = 0 ========================2022-10-21 14:12:52======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8ITRTI1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C3A20F761448122A sCDKey = 342715251937 sName = DESKTOP-8ITRTI1 ========================2022-10-21 14: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 = '342715251937' AND r.app_code = '047' AND r.app_block = 0 ========================2022-10-21 14:12:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cheongsol4' ========================2022-10-21 14:12:52======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A20F761448122A' AND app_code = '047' ========================2022-10-21 14:12:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '372851' ========================2022-10-21 14:12:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '372851' ========================2022-10-21 14:12:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '372851', '50B7C3A20F761448122A', '047', 'DESKTOP-8ITRTI1', '�쐢�룄�슦 10', '0', '0', 'cheongsol4', '도깨비시장[박현배]', '342715251937' ) ========================2022-10-21 17:52:04======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-V1CLHFQ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAE8AADB764D8975 sCDKey = 210741297134 sName = DESKTOP-V1CLHFQ ========================2022-10-21 17:52: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 = '210741297134' AND r.app_code = '047' AND r.app_block = 0 ========================2022-10-21 17:52:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gm5745' ========================2022-10-21 17:52:04======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE8AADB764D8975' AND app_code = '047' ========================2022-10-21 17:52:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '375929' ========================2022-10-21 17:52:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '375929' ========================2022-10-21 17:52: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 ( '375929', '24F5AAE8AADB764D8975', '047', 'DESKTOP-V1CLHFQ', '�쐢�룄�슦 10', '0', '0', 'gm5745', '(주)광명종합물류[임혜미]', '210741297134' )