========================2024-07-30 09:53:10======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-TGIBM6F parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2CBC302C03F98BF sCDKey = 678905519571 sName = DESKTOP-TGIBM6F ========================2024-07-30 09:53: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 = '678905519571' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-30 09:53:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'solbar' ========================2024-07-30 09:53:10======================== SELECT idx FROM macs WHERE mac_addr = '7085C2CBC302C03F98BF' AND app_code = '050' ========================2024-07-30 09:53:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '406719' ========================2024-07-30 09:53:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '406719' ========================2024-07-30 09:53:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '406719', '7085C2CBC302C03F98BF', '050', 'DESKTOP-TGIBM6F', '109', '1920', '1080', 'solbar', '(주)솔바텍[오영근]', '678905519571' ) ========================2024-07-30 11:48:53======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732762BFA41C65F sCDKey = 776035659991 sName = USER-PC ========================2024-07-30 11:48:53======================== 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 = '776035659991' AND r.app_code = '046' AND r.app_block = 0 ========================2024-07-30 11:48:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'millepet1' ========================2024-07-30 11:48:53======================== SELECT idx FROM macs WHERE mac_addr = '50AF732762BFA41C65F' AND app_code = '046' ========================2024-07-30 11:48:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '409053' ========================2024-07-30 11:48:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '409053' ========================2024-07-30 11:48:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '409053', '50AF732762BFA41C65F', '046', 'USER-PC', '90', '1024', '768', 'millepet1', '밀레펫주식회사[심준희]', '776035659991' ) ========================2024-07-30 14:29:40======================== noteurl_start parm_app_code = 050 parm_pc_name = 자산관리 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3C7C3F81FDC3888C3E19 sCDKey = 130359793033 sName = 자산관리 ========================2024-07-30 14:29:40======================== 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 = '130359793033' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-30 14:29:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gltec1' ========================2024-07-30 14:29:40======================== SELECT idx FROM macs WHERE mac_addr = '3C7C3F81FDC3888C3E19' AND app_code = '050' ========================2024-07-30 14:29:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '409057' ========================2024-07-30 14:29:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '409057' ========================2024-07-30 14:29:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '409057', '3C7C3F81FDC3888C3E19', '050', '자산관리', '109', '1920', '1080', 'gltec1', '지오기술(주)[김민희]', '130359793033' ) ========================2024-07-30 14:29:48======================== noteurl_start parm_app_code = 050 parm_pc_name = 자산관리 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3C7C3F81FDC3888C3E19 sCDKey = 130359793033 sName = 자산관리 ========================2024-07-30 14:29:48======================== 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 = '130359793033' AND r.app_code = '050' AND r.app_block = 0 ========================2024-07-30 14:41:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-V7BS1EM parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 70C94E9DEDCDDA6A0A23 sCDKey = 583218043414 sName = DESKTOP-V7BS1EM ========================2024-07-30 14:41:49======================== 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 = '583218043414' AND r.app_code = '039' AND r.app_block = 0 ========================2024-07-30 14:41:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tntzzzzzz' ========================2024-07-30 14:41:50======================== SELECT idx FROM macs WHERE mac_addr = '70C94E9DEDCDDA6A0A23' AND app_code = '039' ========================2024-07-30 14:41:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '409031' ========================2024-07-30 14:41:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '409031' ========================2024-07-30 14:41:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '409031', '70C94E9DEDCDDA6A0A23', '039', 'DESKTOP-V7BS1EM', '110', '1536', '864', 'tntzzzzzz', '성신상회[이신애]', '583218043414' ) ========================2024-07-30 17:12:03======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8B2E5VO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9CA2F4A5E2A1AC40AF83 sCDKey = 186768539826 sName = DESKTOP-8B2E5VO ========================2024-07-30 17:12: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 = '186768539826' AND r.app_code = '047' AND r.app_block = 0 ========================2024-07-30 17:12:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'welding09' ========================2024-07-30 17:12:04======================== SELECT idx FROM macs WHERE mac_addr = '9CA2F4A5E2A1AC40AF83' AND app_code = '047' ========================2024-07-30 17:12:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '408061' ========================2024-07-30 17:12:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '408061' ========================2024-07-30 17:12:04======================== UPDATE mac_detail SET pc_name = 'DESKTOP-8B2E5VO', os_type = '�쐢�룄�슦 10', user_id = 'welding09', user_name = '웰딩09[박을규]', screen_w = '0', screen_h = '0', cdkey = '186768539826' WHERE mac_idx = '408061'