========================2020-04-03 09:34:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SICBRVM parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = D05099028CE8A0CE657A sCDKey = 924530203570 sName = 부광2 ========================2020-04-03 09:34:01======================== 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 = '924530203570' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-03 09:34:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bukwang2272' ========================2020-04-03 09:34:01======================== SELECT idx FROM macs WHERE mac_addr = 'D05099028CE8A0CE657A' AND app_code = '039' ========================2020-04-03 09:34:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314477' ========================2020-04-03 09:34:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314477' ========================2020-04-03 09:34:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314477', 'D05099028CE8A0CE657A', '039', '부광2', '110', '1360', '768', 'bukwang2272', '부광포장[박효정]', '924530203570' ) ========================2020-04-03 09:38:36======================== noteurl_start parm_app_code = 039 parm_pc_name = 부광2-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 001FC69E206EF8A72E49 sCDKey = 924530203570 sName = 서버pc ========================2020-04-03 09:38:36======================== 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 = '924530203570' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-03 09:38:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bukwang2272' ========================2020-04-03 09:38:37======================== SELECT idx FROM macs WHERE mac_addr = '001FC69E206EF8A72E49' AND app_code = '039' ========================2020-04-03 09:38:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '187107' ========================2020-04-03 09:38:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '187107' ========================2020-04-03 09:38:37======================== UPDATE mac_detail SET pc_name = '서버pc', os_type = '90', user_id = 'bukwang2272', user_name = '부광포장[박효정]', screen_w = '1366', screen_h = '768', cdkey = '924530203570' WHERE mac_idx = '187107' ========================2020-04-03 11:07:27======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN7-PRO parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 24F5AABF41739261C1E3 sCDKey = 460224480685 sName = WIN7-PRO ========================2020-04-03 11:07:27======================== 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 = '460224480685' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-03 11:07:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ykglobal' ========================2020-04-03 11:07:27======================== SELECT idx FROM macs WHERE mac_addr = '24F5AABF41739261C1E3' AND app_code = '046' ========================2020-04-03 11:07:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '140215' ========================2020-04-03 11:07:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '140215' ========================2020-04-03 11:07:27======================== UPDATE mac_detail SET pc_name = 'WIN7-PRO', os_type = '90', user_id = 'ykglobal', user_name = '영광수산[이영만]', screen_w = '1366', screen_h = '768', cdkey = '460224480685' WHERE mac_idx = '140215' ========================2020-04-03 11:27:16======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TDO8IG6 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 88366CFFB9E38AC971A2 sCDKey = 889358506037 sName = DESKTOP-TDO8IG6 ========================2020-04-03 11:27:16======================== 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 = '889358506037' AND r.app_code = '047' AND r.app_block = 0 ========================2020-04-03 11:27:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kd3424' ========================2020-04-03 11:27:16======================== SELECT idx FROM macs WHERE mac_addr = '88366CFFB9E38AC971A2' AND app_code = '047' ========================2020-04-03 11:27:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314605' ========================2020-04-03 11:27:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314605' ========================2020-04-03 11:27:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314605', '88366CFFB9E38AC971A2', '047', 'DESKTOP-TDO8IG6', '�쐢�룄�슦 10', '0', '0', 'kd3424', '(주)세훈SOS[홍성현]', '889358506037' ) ========================2020-04-03 11:39:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EK69AV7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99EBF9AE7E4BA5E7 sCDKey = 002990426440 sName = DESKTOP-EK69AV7 ========================2020-04-03 11:39: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 = '002990426440' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-03 11:39:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'houngsek123' ========================2020-04-03 11:39:45======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99EBF9AE7E4BA5E7' AND app_code = '039' ========================2020-04-03 11:39:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314608' ========================2020-04-03 11:39:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314608' ========================2020-04-03 11:39:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314608', 'B42E99EBF9AE7E4BA5E7', '039', 'DESKTOP-EK69AV7', '110', '1920', '1080', 'houngsek123', '신의정밀[홍성원]', '002990426440' ) ========================2020-04-03 11:59:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HTO3KJO parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 002454310BE1E62FC653 sCDKey = 617218682863 sName = DESKTOP-HTO3KJO ========================2020-04-03 11:59: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 = '617218682863' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-03 11:59:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ysgear311' ========================2020-04-03 11:59:05======================== SELECT idx FROM macs WHERE mac_addr = '002454310BE1E62FC653' AND app_code = '039' ========================2020-04-03 11:59:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314610' ========================2020-04-03 11:59:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314610' ========================2020-04-03 11:59: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 ( '314610', '002454310BE1E62FC653', '039', 'DESKTOP-HTO3KJO', '110', '1024', '768', 'ysgear311', '(주)피티코리아[유창열]', '617218682863' ) ========================2020-04-03 15:52:14======================== noteurl_start parm_app_code = 051 parm_pc_name = 김준영 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1590890F09845AE32 sCDKey = 378736978806 sName = 김준영 ========================2020-04-03 15:52:14======================== 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 = '378736978806' AND r.app_code = '051' AND r.app_block = 0 ========================2020-04-03 15:52:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bdirect1' ========================2020-04-03 15:52:14======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1590890F09845AE32' AND app_code = '051' ========================2020-04-03 15:52:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314311' ========================2020-04-03 15:52:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314311' ========================2020-04-03 15:52:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314311', 'A8A1590890F09845AE32', '051', '김준영', '109', '1920', '1080', 'bdirect1', '부동산다이렉트[김준영]', '378736978806' )