========================2023-02-02 09:08:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NKR4PP8 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B5202657FF5480B7E3 sCDKey = 279637570827 sName = DESKTOP-NKR4PP8 ========================2023-02-02 09:08:33======================== 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 = '279637570827' AND r.app_code = '039' AND r.app_block = 0 ========================2023-02-02 09:08:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wlsgks0406' ========================2023-02-02 09:08:33======================== SELECT idx FROM macs WHERE mac_addr = 'F4B5202657FF5480B7E3' AND app_code = '039' ========================2023-02-02 09:08:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '380868' ========================2023-02-02 09:08:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '380868' ========================2023-02-02 09:08:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '380868', 'F4B5202657FF5480B7E3', '039', 'DESKTOP-NKR4PP8', '110', '1920', '1080', 'wlsgks0406', '대일종합[나진한]', '279637570827' ) ========================2023-02-02 10:37:46======================== noteurl_start parm_app_code = 050 parm_pc_name = SKAI-YB-MAIN parm_os_type = 109 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 50EBF6994CA964A6A30E sCDKey = 858865714604 sName = SKAI-YB-MAIN ========================2023-02-02 10:37:46======================== 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 = '858865714604' AND r.app_code = '050' AND r.app_block = 0 ========================2023-02-02 16:14:38======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-BO54SUQ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E994E956F3B5AC3E0 sCDKey = 709619230339 sName = DESKTOP-BO54SUQ ========================2023-02-02 16:14: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 = '709619230339' AND r.app_code = '050' AND r.app_block = 0 ========================2023-02-02 16:14:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk4045' ========================2023-02-02 16:14:38======================== SELECT idx FROM macs WHERE mac_addr = 'B42E994E956F3B5AC3E0' AND app_code = '050' ========================2023-02-02 16:14:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381743' ========================2023-02-02 16:14:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381743' ========================2023-02-02 16:14: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 ( '381743', 'B42E994E956F3B5AC3E0', '050', 'DESKTOP-BO54SUQ', '109', '1920', '1080', 'kyk4045', '대전세종연구원[김영기]', '709619230339' ) ========================2023-02-02 16:14:43======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-BO54SUQ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E994E956F3B5AC3E0 sCDKey = 709619230339 sName = DESKTOP-BO54SUQ ========================2023-02-02 16:14:43======================== 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 = '709619230339' AND r.app_code = '050' AND r.app_block = 0 ========================2023-02-02 16:32:32======================== noteurl_start parm_app_code = 046 parm_pc_name = G200_SERIES parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF734081D04C1AD54F sCDKey = 573190698474 sName = G200_SERIES ========================2023-02-02 16:32: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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2023-02-02 16:32:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'groutmart' ========================2023-02-02 16:32:32======================== SELECT idx FROM macs WHERE mac_addr = '50AF734081D04C1AD54F' AND app_code = '046' ========================2023-02-02 16:32:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381751' ========================2023-02-02 16:32:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381751' ========================2023-02-02 16:32:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '381751', '50AF734081D04C1AD54F', '046', 'G200_SERIES', '110', '1024', '768', 'groutmart', '크린앤네이처[줄눈마트]', '573190698474' ) ========================2023-02-02 17:55:10======================== noteurl_start parm_app_code = 047 parm_pc_name = D-1 parm_os_type = �쐢�룄�슦 8 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C3A3D874CA50CBD3 sCDKey = 210741297134 sName = D-1 ========================2023-02-02 17:55: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 = '210741297134' AND r.app_code = '047' AND r.app_block = 0 ========================2023-02-02 17:55:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gm5745' ========================2023-02-02 17:55:10======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A3D874CA50CBD3' AND app_code = '047' ========================2023-02-02 17:55:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '375522' ========================2023-02-02 17:55:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '375522' ========================2023-02-02 17:55:10======================== UPDATE mac_detail SET pc_name = 'D-1', os_type = '�쐢�룄�슦 8', user_id = 'gm5745', user_name = '(주)광명종합물류[임혜미]', screen_w = '0', screen_h = '0', cdkey = '210741297134' WHERE mac_idx = '375522'