========================2023-01-30 09:32:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7G69ENC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897E2BE45A574BEE sCDKey = 728526553167 sName = DESKTOP-7G69ENC ========================2023-01-30 09:32:51======================== 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 = '728526553167' AND r.app_code = '039' AND r.app_block = 0 ========================2023-01-30 09:32:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ycbd6202' ========================2023-01-30 09:32:51======================== SELECT idx FROM macs WHERE mac_addr = '9883897E2BE45A574BEE' AND app_code = '039' ========================2023-01-30 09:32:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381445' ========================2023-01-30 09:32:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381445' ========================2023-01-30 09:32:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '381445', '9883897E2BE45A574BEE', '039', 'DESKTOP-7G69ENC', '110', '1920', '1080', 'ycbd6202', '유창벤딩[유순정]', '728526553167' ) ========================2023-01-30 09:41:28======================== noteurl_start parm_app_code = 039 parm_pc_name = MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C6F6535039758C64156 sCDKey = 616845460996 sName = MAIN ========================2023-01-30 09:41:28======================== 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 = '616845460996' AND r.app_code = '039' AND r.app_block = 0 ========================2023-01-30 09:41:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jwp6767' ========================2023-01-30 09:41:28======================== SELECT idx FROM macs WHERE mac_addr = '1C6F6535039758C64156' AND app_code = '039' ========================2023-01-30 09:41:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '116789' ========================2023-01-30 09:41:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '116789' ========================2023-01-30 09:41:28======================== UPDATE mac_detail SET pc_name = 'MAIN', os_type = '110', user_id = 'jwp6767', user_name = '정우사[이윤희]', screen_w = '1920', screen_h = '1080', cdkey = '616845460996' WHERE mac_idx = '116789' ========================2023-01-30 09:41:34======================== noteurl_start parm_app_code = 039 parm_pc_name = MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C6F6535039758C64156 sCDKey = 616845460996 sName = MAIN ========================2023-01-30 09:41:34======================== 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 = '616845460996' AND r.app_code = '039' AND r.app_block = 0 ========================2023-01-30 09:52:05======================== noteurl_start parm_app_code = 050 parm_pc_name = USER parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74563C34A1564873F68E sCDKey = 149111290224 sName = USER ========================2023-01-30 09:52:05======================== 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 = '149111290224' AND r.app_code = '050' AND r.app_block = 0 ========================2023-01-30 09:52:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodwoman' ========================2023-01-30 09:52:05======================== SELECT idx FROM macs WHERE mac_addr = '74563C34A1564873F68E' AND app_code = '050' ========================2023-01-30 09:52:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381399' ========================2023-01-30 09:52:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381399' ========================2023-01-30 09:52:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '381399', '74563C34A1564873F68E', '050', 'USER', '109', '1920', '1080', 'goodwoman', '서울시중부여성발전센터[임은정]', '149111290224' ) ========================2023-01-30 10:49:30======================== noteurl_start parm_app_code = 051 parm_pc_name = 김동순 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691FA57C0D258648A sCDKey = 049624493773 sName = 김동순 ========================2023-01-30 10:49:30======================== 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 = '049624493773' AND r.app_code = '051' AND r.app_block = 0 ========================2023-01-30 10:49:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdsoon0402' ========================2023-01-30 10:49:30======================== SELECT idx FROM macs WHERE mac_addr = '94C691FA57C0D258648A' AND app_code = '051' ========================2023-01-30 10:49:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381450' ========================2023-01-30 10:49:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381450' ========================2023-01-30 10:49:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '381450', '94C691FA57C0D258648A', '051', '김동순', '109', '1920', '1080', 'kdsoon0402', '대전평생교육진흥원[대전평생교육진흥원]', '049624493773' ) ========================2023-01-30 10:58:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G0FRMCP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EB8135BCC5DA1CE sCDKey = 616845460996 sName = DESKTOP-G0FRMCP ========================2023-01-30 10:58: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 = '616845460996' AND r.app_code = '039' AND r.app_block = 0 ========================2023-01-30 10:58:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jwp6767' ========================2023-01-30 10:58:56======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EB8135BCC5DA1CE' AND app_code = '039' ========================2023-01-30 10:58:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381455' ========================2023-01-30 10:58:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381455' ========================2023-01-30 10:58:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '381455', 'E0D55EB8135BCC5DA1CE', '039', 'DESKTOP-G0FRMCP', '110', '1920', '1080', 'jwp6767', '정우사[이윤희]', '616845460996' ) ========================2023-01-30 11:13:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5IR9CC3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18473D2F59A3CCDCC06A sCDKey = 887299034147 sName = DESKTOP-5IR9CC3 ========================2023-01-30 11:13: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 = '887299034147' AND r.app_code = '039' AND r.app_block = 0 ========================2023-01-30 11:14:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5IR9CC3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18473D2F59A3CCDCC06A sCDKey = 887299034147 sName = DESKTOP-5IR9CC3 ========================2023-01-30 11:14:57======================== 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 = '887299034147' AND r.app_code = '039' AND r.app_block = 0 ========================2023-01-30 11:14:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'beejoelec' ========================2023-01-30 11:14:57======================== SELECT idx FROM macs WHERE mac_addr = '18473D2F59A3CCDCC06A' AND app_code = '039' ========================2023-01-30 11:14:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381461' ========================2023-01-30 11:14:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381461' ========================2023-01-30 11:14:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '381461', '18473D2F59A3CCDCC06A', '039', 'DESKTOP-5IR9CC3', '110', '1920', '1080', 'beejoelec', '(주)비조전자[서이택]', '887299034147' ) ========================2023-01-30 14:15:37======================== noteurl_start parm_app_code = 047 parm_pc_name = PC01 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C39F835ECAFD2E85 sCDKey = 657217185877 sName = PC01 ========================2023-01-30 14:15:37======================== 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 = '657217185877' AND r.app_code = '047' AND r.app_block = 0 ========================2023-01-30 14:15:45======================== noteurl_start parm_app_code = 047 parm_pc_name = PC01 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C39F835ECAFD2E85 sCDKey = 657217185877 sName = PC01 ========================2023-01-30 14:15:45======================== 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 = '657217185877' AND r.app_code = '047' AND r.app_block = 0 ========================2023-01-30 16:28:57======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-MAV8VDT parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2329B9710AD97FE sCDKey = 938133773741 sName = DESKTOP-MAV8VDT ========================2023-01-30 16:28:57======================== 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 = '938133773741' AND r.app_code = '047' AND r.app_block = 0 ========================2023-01-30 16:28:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2023-01-30 16:28:57======================== SELECT idx FROM macs WHERE mac_addr = '7085C2329B9710AD97FE' AND app_code = '047' ========================2023-01-30 16:28:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '381501' ========================2023-01-30 16:28:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '381501' ========================2023-01-30 16:28:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '381501', '7085C2329B9710AD97FE', '047', 'DESKTOP-MAV8VDT', '�쐢�룄�슦 10', '0', '0', 'wogus36', '엠제이소프트[황재현]', '938133773741' )