========================2023-07-19 13:38:25======================== noteurl_start parm_app_code = 047 parm_pc_name = JEON-MAC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F45C89AA9CB506C7F9F9 sCDKey = 394527000962 sName = demei 노트북 ========================2023-07-19 13:38:25======================== 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 = '394527000962' AND r.app_code = '047' AND r.app_block = 0 ========================2023-07-19 13:38:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'demei' ========================2023-07-19 13:38:25======================== SELECT idx FROM macs WHERE mac_addr = 'F45C89AA9CB506C7F9F9' AND app_code = '047' ========================2023-07-19 13:38:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390874' ========================2023-07-19 13:38:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390874' ========================2023-07-19 13:38:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '390874', 'F45C89AA9CB506C7F9F9', '047', 'demei 노트북', '�쐢�룄�슦 10', '0', '0', 'demei', '드메이[이성득]', '394527000962' ) ========================2023-07-19 13:46:24======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-LK0T8OG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897CE2D164A5F009 sCDKey = 342067082511 sName = DESKTOP-LK0T8OG ========================2023-07-19 13:46: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 = '342067082511' AND r.app_code = '045' AND r.app_block = 0 ========================2023-07-19 13:46:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'taesung3939' ========================2023-07-19 13:46:24======================== SELECT idx FROM macs WHERE mac_addr = '9883897CE2D164A5F009' AND app_code = '045' ========================2023-07-19 13:46:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '384490' ========================2023-07-19 13:46:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '384490' ========================2023-07-19 13:46:24======================== UPDATE mac_detail SET pc_name = 'DESKTOP-LK0T8OG', os_type = '110', user_id = 'taesung3939', user_name = '태성타일[정점교]', screen_w = '1920', screen_h = '1080', cdkey = '342067082511' WHERE mac_idx = '384490' ========================2023-07-19 15:14:39======================== noteurl_start parm_app_code = 045 parm_pc_name = KTJ-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8BBC119715890C13917 sCDKey = 723777217480 sName = KTJ-PC ========================2023-07-19 15:14:39======================== 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 = '723777217480' AND r.app_code = '045' AND r.app_block = 0 ========================2023-07-19 15:14:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ta1hun' ========================2023-07-19 15:14:39======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC119715890C13917' AND app_code = '045' ========================2023-07-19 15:14:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381356' ========================2023-07-19 15:14:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381356' ========================2023-07-19 15:14:39======================== UPDATE mac_detail SET pc_name = 'KTJ-PC', os_type = '110', user_id = 'ta1hun', user_name = '엠제이소프트[김태훈]', screen_w = '1920', screen_h = '1080', cdkey = '723777217480' WHERE mac_idx = '381356' ========================2023-07-19 17:01:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FQN0IQS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389825F48DAB017AA sCDKey = 507493827944 sName = DESKTOP-FQN0IQS ========================2023-07-19 17:01: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 = '507493827944' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-19 17:01:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunguard' ========================2023-07-19 17:01:44======================== SELECT idx FROM macs WHERE mac_addr = '988389825F48DAB017AA' AND app_code = '039' ========================2023-07-19 17:01:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390891' ========================2023-07-19 17:01:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390891' ========================2023-07-19 17:01:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '390891', '988389825F48DAB017AA', '039', 'DESKTOP-FQN0IQS', '110', '1920', '1080', 'sunguard', '(주)썬가드광학[황경미]', '507493827944' ) ========================2023-07-19 17:03:56======================== noteurl_start parm_app_code = 039 parm_pc_name = BOOK-KNUURSEAOH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E9CD20EFE60F843B sCDKey = 507493827944 sName = BOOK-KNUURSEAOH ========================2023-07-19 17:03: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 = '507493827944' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-19 17:03:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunguard' ========================2023-07-19 17:03:56======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9CD20EFE60F843B' AND app_code = '039' ========================2023-07-19 17:03:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390892' ========================2023-07-19 17:03:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390892' ========================2023-07-19 17:03: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 ( '390892', '8CB0E9CD20EFE60F843B', '039', 'BOOK-KNUURSEAOH', '110', '1920', '1080', 'sunguard', '(주)썬가드광학[황경미]', '507493827944' )