========================2025-08-25 10:29:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-TO04TVD parm_os_type = 110 parm_screen_w = 1780 parm_screen_h = 1025 parm_user_mac = 10C37B4A5C14ECC7F55B sCDKey = 930976225175 sName = DESKTOP-TO04TVD ========================2025-08-25 10:29:31======================== 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 = '930976225175' AND r.app_code = '039' AND r.app_block = 0 ========================2025-08-25 10:29:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'imkingdon' ========================2025-08-25 10:29:31======================== SELECT idx FROM macs WHERE mac_addr = '10C37B4A5C14ECC7F55B' AND app_code = '039' ========================2025-08-25 10:29:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '427787' ========================2025-08-25 10:29:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '427787' ========================2025-08-25 10:29:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '427787', '10C37B4A5C14ECC7F55B', '039', 'DESKTOP-TO04TVD', '110', '1780', '1025', 'imkingdon', '안산판넬[정민철]', '930976225175' ) ========================2025-08-25 14:28:06======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-JJ3PBMJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 705DCCFB218404358BCA sCDKey = 375510806225 sName = DESKTOP-JJ3PBMJ ========================2025-08-25 14:28: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 = '375510806225' AND r.app_code = '047' AND r.app_block = 0 ========================2025-08-25 14:28:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssnet' ========================2025-08-25 14:28:06======================== SELECT idx FROM macs WHERE mac_addr = '705DCCFB218404358BCA' AND app_code = '047' ========================2025-08-25 14:28:06======================== 값이 없을 경우 ========================2025-08-25 14:29:32======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-JJ3PBMJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 705DCCFB218404358BCA sCDKey = 375510806225 sName = DESKTOP-JJ3PBMJ ========================2025-08-25 14:29:32======================== 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 = '375510806225' AND r.app_code = '047' AND r.app_block = 0 ========================2025-08-25 14:29:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssnet' ========================2025-08-25 14:29:32======================== SELECT idx FROM macs WHERE mac_addr = '705DCCFB218404358BCA' AND app_code = '047' ========================2025-08-25 14:29:32======================== 값이 없을 경우 ========================2025-08-25 14:34:47======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-JJ3PBMJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 705DCCFB218404358BCA sCDKey = 375510806225 sName = DESKTOP-JJ3PBMJ ========================2025-08-25 14:34:47======================== 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 = '375510806225' AND r.app_code = '047' AND r.app_block = 0 ========================2025-08-25 14:34:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssnet' ========================2025-08-25 14:34:47======================== SELECT idx FROM macs WHERE mac_addr = '705DCCFB218404358BCA' AND app_code = '047' ========================2025-08-25 14:34:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '427805' ========================2025-08-25 14:34:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '427805' ========================2025-08-25 14:34:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '427805', '705DCCFB218404358BCA', '047', 'DESKTOP-JJ3PBMJ', '�쐢�룄�슦 10', '0', '0', 'ssnet', '상생네트웍[김종명]', '375510806225' ) ========================2025-08-25 14:34:50======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-JJ3PBMJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 705DCCFB218404358BCA sCDKey = 375510806225 sName = DESKTOP-JJ3PBMJ ========================2025-08-25 14:34:50======================== 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 = '375510806225' AND r.app_code = '047' AND r.app_block = 0 ========================2025-08-25 17:27:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1KB6J5O parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F40669179841507F5234 sCDKey = 587944082586 sName = DESKTOP-1KB6J5O ========================2025-08-25 17:27: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 = '587944082586' AND r.app_code = '039' AND r.app_block = 0 ========================2025-08-25 17:27:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bjk400' ========================2025-08-25 17:27:56======================== SELECT idx FROM macs WHERE mac_addr = 'F40669179841507F5234' AND app_code = '039' ========================2025-08-25 17:27:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '363693' ========================2025-08-25 17:27:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '363693' ========================2025-08-25 17:27:56======================== UPDATE mac_detail SET pc_name = 'DESKTOP-1KB6J5O', os_type = '110', user_id = 'bjk400', user_name = '신명직물[김중배]', screen_w = '1536', screen_h = '864', cdkey = '587944082586' WHERE mac_idx = '363693'