========================2021-11-10 10:46:38======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9QQTEVN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8C554A6B1A84A4B64364 sCDKey = 938134926570 sName = DESKTOP-9QQTEVN ========================2021-11-10 10:46: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 = '938134926570' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-10 10:50:26======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9QQTEVN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8C554A6B1A84A4B64364 sCDKey = 291546858846 sName = DESKTOP-9QQTEVN ========================2021-11-10 10:50: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 = '291546858846' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-10 10:50:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'leesuk5424' ========================2021-11-10 10:50:26======================== SELECT idx FROM macs WHERE mac_addr = '8C554A6B1A84A4B64364' AND app_code = '046' ========================2021-11-10 10:50:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353698' ========================2021-11-10 10:50:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353698' ========================2021-11-10 10:50:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353698', '8C554A6B1A84A4B64364', '046', 'DESKTOP-9QQTEVN', '110', '1920', '1080', 'leesuk5424', '자연햇살주식회사[이홍숙]', '291546858846' ) ========================2021-11-10 11:53:12======================== noteurl_start parm_app_code = 046 parm_pc_name = SJ-20141219NCCE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0AA05640CBE2CA sCDKey = 834962125925 sName = SJ-20141219NCCE ========================2021-11-10 11:53:12======================== 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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-10 11:53:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2021-11-10 11:53:12======================== SELECT idx FROM macs WHERE mac_addr = '00190F0AA05640CBE2CA' AND app_code = '046' ========================2021-11-10 11:53:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268192' ========================2021-11-10 11:53:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268192' ========================2021-11-10 11:53:12======================== UPDATE mac_detail SET pc_name = 'SJ-20141219NCCE', os_type = '64', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '268192' ========================2021-11-10 16:33:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-B2N80B6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23B713DFA94C03F sCDKey = 741506160169 sName = DESKTOP-B2N80B6 ========================2021-11-10 16:33:08======================== 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 = '741506160169' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-10 16:33:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yk264800' ========================2021-11-10 16:33:08======================== SELECT idx FROM macs WHERE mac_addr = '7085C23B713DFA94C03F' AND app_code = '039' ========================2021-11-10 16:33:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282463' ========================2021-11-10 16:33:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282463' ========================2021-11-10 16:33:08======================== UPDATE mac_detail SET pc_name = 'DESKTOP-B2N80B6', os_type = '110', user_id = 'yk264800', user_name = '영광종합상사[장두환]', screen_w = '1920', screen_h = '1080', cdkey = '741506160169' WHERE mac_idx = '282463' ========================2021-11-10 18:18:17======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-0RMGDJ6 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = F4066934AB07D6A1F178 sCDKey = 983237615519 sName = DESKTOP-0RMGDJ6 ========================2021-11-10 18:18:17======================== 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 = '983237615519' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-10 18:18:45======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-0RMGDJ6 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = F4066934AB07D6A1F178 sCDKey = 983237615519 sName = DESKTOP-0RMGDJ6 ========================2021-11-10 18:18: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 = '983237615519' AND r.app_code = '046' AND r.app_block = 0