========================2023-02-17 13:28:19======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-D5KB93A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30A472F29A2117FC sCDKey = 747413241531 sName = DESKTOP-D5KB93A ========================2023-02-17 13:28:19======================== 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 = '747413241531' AND r.app_code = '046' AND r.app_block = 0 ========================2023-02-17 13:28:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'damurak' ========================2023-02-17 13:28:19======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30A472F29A2117FC' AND app_code = '046' ========================2023-02-17 13:28:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '370250' ========================2023-02-17 13:28:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '370250' ========================2023-02-17 13:28:19======================== UPDATE mac_detail SET pc_name = 'DESKTOP-D5KB93A', os_type = '110', user_id = 'damurak', user_name = '섬지친환경원예사[서종태]', screen_w = '1920', screen_h = '1080', cdkey = '747413241531' WHERE mac_idx = '370250' ========================2023-02-17 13:28:26======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-D5KB93A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30A472F29A2117FC sCDKey = 747413241531 sName = DESKTOP-D5KB93A ========================2023-02-17 13:28:26======================== 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 = '747413241531' AND r.app_code = '046' AND r.app_block = 0 ========================2023-02-17 16:12:59======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9G5DE06 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FC34979F4DF3E8A0E64C sCDKey = 074145777218 sName = DESKTOP-9G5DE06 ========================2023-02-17 16:12:59======================== 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 = '074145777218' AND r.app_code = '039' AND r.app_block = 0 ========================2023-02-17 16:13:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9G5DE06 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FC34979F4DF3E8A0E64C sCDKey = 074145777218 sName = DESKTOP-9G5DE06 ========================2023-02-17 16:13: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 = '074145777218' AND r.app_code = '039' AND r.app_block = 0 ========================2023-02-17 16:13:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kja32' ========================2023-02-17 16:13:06======================== SELECT idx FROM macs WHERE mac_addr = 'FC34979F4DF3E8A0E64C' AND app_code = '039' ========================2023-02-17 16:13:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '382761' ========================2023-02-17 16:13:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '382761' ========================2023-02-17 16:13:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '382761', 'FC34979F4DF3E8A0E64C', '039', 'DESKTOP-9G5DE06', '110', '1920', '1080', 'kja32', '태영가스켓[강정아]', '074145777218' ) ========================2023-02-17 16:18:00======================== noteurl_start parm_app_code = 039 parm_pc_name = USER1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8AAD3BFCCA981610 sCDKey = 266187021804 sName = USER1 ========================2023-02-17 16:18:00======================== 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 = '266187021804' AND r.app_code = '039' AND r.app_block = 0 ========================2023-02-17 16:18:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'an53591104' ========================2023-02-17 16:18:00======================== SELECT idx FROM macs WHERE mac_addr = 'D8CB8AAD3BFCCA981610' AND app_code = '039' ========================2023-02-17 16:18:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '382756' ========================2023-02-17 16:18:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '382756' ========================2023-02-17 16:18:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '382756', 'D8CB8AAD3BFCCA981610', '039', 'USER1', '110', '1920', '1080', 'an53591104', '세정[안정환]', '266187021804' ) ========================2023-02-17 16:48:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-F74OTUG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8975A64C3AA6A43B233 sCDKey = 196042967550 sName = DESKTOP-F74OTUG ========================2023-02-17 16:48:38======================== 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 = '196042967550' AND r.app_code = '039' AND r.app_block = 0 ========================2023-02-17 16:48:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jm4022' ========================2023-02-17 16:48:38======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A64C3AA6A43B233' AND app_code = '039' ========================2023-02-17 16:48:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '382763' ========================2023-02-17 16:48:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '382763' ========================2023-02-17 16:48:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '382763', 'B8975A64C3AA6A43B233', '039', 'DESKTOP-F74OTUG', '110', '1920', '1080', 'jm4022', '대유수산[박용환]', '196042967550' )