========================2023-06-21 09:26:08======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-SSGJFC3 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 244BFE8DA92906EA819A sCDKey = 132108890415 sName = DESKTOP-SSGJFC3 ========================2023-06-21 09:26:08======================== 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 = '132108890415' AND r.app_code = '048' AND r.app_block = 0 ========================2023-06-21 09:26:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ngyt1' ========================2023-06-21 09:26:08======================== SELECT idx FROM macs WHERE mac_addr = '244BFE8DA92906EA819A' AND app_code = '048' ========================2023-06-21 09:26:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '389427' ========================2023-06-21 09:26:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '389427' ========================2023-06-21 09:26:08======================== UPDATE mac_detail SET pc_name = 'DESKTOP-SSGJFC3', os_type = '�쐢�룄�슦 10', user_id = 'ngyt1', user_name = '농업회사법인 (주)강남푸드[(주) 강남푸드]', screen_w = '0', screen_h = '0', cdkey = '132108890415' WHERE mac_idx = '389427' ========================2023-06-21 09:26:12======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-SSGJFC3 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 244BFE8DA92906EA819A sCDKey = 132108890415 sName = DESKTOP-SSGJFC3 ========================2023-06-21 09:26: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 = '132108890415' AND r.app_code = '048' AND r.app_block = 0 ========================2023-06-21 11:59:29======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-N1NL3GUT parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C4D0E333B6B16E7CE9AC sCDKey = 996742661755 sName = LAPTOP-N1NL3GUT ========================2023-06-21 11:59:29======================== 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 = '996742661755' AND r.app_code = '039' AND r.app_block = 0 ========================2023-06-21 11:59:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'miya3098' ========================2023-06-21 11:59:29======================== SELECT idx FROM macs WHERE mac_addr = 'C4D0E333B6B16E7CE9AC' AND app_code = '039' ========================2023-06-21 11:59:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '389465' ========================2023-06-21 11:59:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '389465' ========================2023-06-21 11:59:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '389465', 'C4D0E333B6B16E7CE9AC', '039', 'LAPTOP-N1NL3GUT', '110', '1536', '864', 'miya3098', '영천상회[이대열]', '996742661755' ) ========================2023-06-21 12:05:35======================== noteurl_start parm_app_code = 039 parm_pc_name = SVC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 48D224BFEF3C66EA6C29 sCDKey = 996742661755 sName = SVC ========================2023-06-21 12:05:35======================== 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 = '996742661755' AND r.app_code = '039' AND r.app_block = 0 ========================2023-06-21 12:05:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'miya3098' ========================2023-06-21 12:05:35======================== SELECT idx FROM macs WHERE mac_addr = '48D224BFEF3C66EA6C29' AND app_code = '039' ========================2023-06-21 12:05:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '389467' ========================2023-06-21 12:05:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '389467' ========================2023-06-21 12:05:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '389467', '48D224BFEF3C66EA6C29', '039', 'SVC', '110', '1366', '768', 'miya3098', '영천상회[이대열]', '996742661755' ) ========================2023-06-21 12:06:21======================== noteurl_start parm_app_code = 039 parm_pc_name = SVC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 48D224BFEF3CF6CDBEBD sCDKey = 996742661755 sName = SVC ========================2023-06-21 12:06:21======================== 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 = '996742661755' AND r.app_code = '039' AND r.app_block = 0 ========================2023-06-21 12:06:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'miya3098' ========================2023-06-21 12:06:21======================== SELECT idx FROM macs WHERE mac_addr = '48D224BFEF3CF6CDBEBD' AND app_code = '039' ========================2023-06-21 12:06:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '205467' ========================2023-06-21 12:06:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '205467' ========================2023-06-21 12:06:21======================== UPDATE mac_detail SET pc_name = 'SVC', os_type = '110', user_id = 'miya3098', user_name = '영천상회[이대열]', screen_w = '1366', screen_h = '768', cdkey = '996742661755' WHERE mac_idx = '205467'