========================2021-10-19 10:10:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-893M098 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA14E1438C780F461F sCDKey = 462113377203 sName = DESKTOP-893M098 ========================2021-10-19 10:10:30======================== 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 = '462113377203' AND r.app_code = '039' AND r.app_block = 0 ========================2021-10-19 10:10:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'edagi1' ========================2021-10-19 10:10:30======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14E1438C780F461F' AND app_code = '039' ========================2021-10-19 10:10:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '352861' ========================2021-10-19 10:10:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '352861' ========================2021-10-19 10:10:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '352861', 'FCAA14E1438C780F461F', '039', 'DESKTOP-893M098', '110', '1920', '1080', 'edagi1', '이다기[김용환]', '462113377203' ) ========================2021-10-19 10:33:54======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-AUUGFB9 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E069D3BB8 sCDKey = 987976167880 sName = DESKTOP-AUUGFB9 ========================2021-10-19 10:33:54======================== 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 = '987976167880' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-19 10:33:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'world4day_db' ========================2021-10-19 10:33:54======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E069D3BB8' AND app_code = '047' ========================2021-10-19 10:33:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '349348' ========================2021-10-19 10:33:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '349348' ========================2021-10-19 10:33:54======================== UPDATE mac_detail SET pc_name = 'DESKTOP-AUUGFB9', os_type = '�쐢�룄�슦 10', user_id = 'world4day_db', user_name = '엠제이소프트[김현우]', screen_w = '0', screen_h = '0', cdkey = '987976167880' WHERE mac_idx = '349348' ========================2021-10-19 13:19:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UUUEPQK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C26D049F0E85414 sCDKey = 110810768510 sName = DESKTOP-UUUEPQK ========================2021-10-19 13:19: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 = '110810768510' AND r.app_code = '039' AND r.app_block = 0 ========================2021-10-19 13:19:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pack121234' ========================2021-10-19 13:19:12======================== SELECT idx FROM macs WHERE mac_addr = '408D5C26D049F0E85414' AND app_code = '039' ========================2021-10-19 13:19:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '352881' ========================2021-10-19 13:19:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '352881' ========================2021-10-19 13:19: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 ( '352881', '408D5C26D049F0E85414', '039', 'DESKTOP-UUUEPQK', '110', '1920', '1080', 'pack121234', '고평주유소[박종백]', '110810768510' ) ========================2021-10-19 14:43:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-MG9P092 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 305A3A0760A2925066D3 sCDKey = 901683225720 sName = DESKTOP-MG9P092 ========================2021-10-19 14:43: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 = '901683225720' AND r.app_code = '046' AND r.app_block = 0 ========================2021-10-19 14:43:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjretail' ========================2021-10-19 14:43:56======================== SELECT idx FROM macs WHERE mac_addr = '305A3A0760A2925066D3' AND app_code = '046' ========================2021-10-19 14:43:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '352888' ========================2021-10-19 14:43:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '352888' ========================2021-10-19 14:43: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 ( '352888', '305A3A0760A2925066D3', '046', 'DESKTOP-MG9P092', '110', '1280', '1024', 'sjretail', '(주)에스제이리테일[김선재]', '901683225720' ) ========================2021-10-19 14:44:10======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-MG9P092 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 305A3A0760A2925066D3 sCDKey = 901683225720 sName = DESKTOP-MG9P092 ========================2021-10-19 14:44:10======================== 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 = '901683225720' AND r.app_code = '046' AND r.app_block = 0 ========================2021-10-19 14:44:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjretail' ========================2021-10-19 14:44:10======================== SELECT idx FROM macs WHERE mac_addr = '305A3A0760A2925066D3' AND app_code = '046' ========================2021-10-19 14:44:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '352888' ========================2021-10-19 14:44:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '352888' ========================2021-10-19 14:44:10======================== UPDATE mac_detail SET pc_name = 'DESKTOP-MG9P092', os_type = '110', user_id = 'sjretail', user_name = '(주)에스제이리테일[김선재]', screen_w = '1280', screen_h = '1024', cdkey = '901683225720' WHERE mac_idx = '352888'