========================2020-03-02 09:28:52======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 00E04C3744472CF7F6B9 sCDKey = 773623978231 sName = ========================2020-03-02 09:28:52======================== 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 = '773623978231' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-02 09:28:58======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 00E04C3744472CF7F6B9 sCDKey = 773623978231 sName = 태광시스템 ========================2020-03-02 09:28:58======================== 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 = '773623978231' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-02 09:28:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xrzx4756' ========================2020-03-02 09:28:58======================== SELECT idx FROM macs WHERE mac_addr = '00E04C3744472CF7F6B9' AND app_code = '039' ========================2020-03-02 09:28:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311830' ========================2020-03-02 09:28:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311830' ========================2020-03-02 09:28:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311830', '00E04C3744472CF7F6B9', '039', '태광시스템', '110', '1280', '720', 'xrzx4756', '주식회사 태광시스템[박정희]', '773623978231' ) ========================2020-03-02 10:03:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3S2HOTC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99EAFF7BBAB51973 sCDKey = 015452661740 sName = DESKTOP-3S2HOTC ========================2020-03-02 10:03: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 = '015452661740' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-02 10:03:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pjk5372' ========================2020-03-02 10:03:56======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99EAFF7BBAB51973' AND app_code = '039' ========================2020-03-02 10:03:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311876' ========================2020-03-02 10:03:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311876' ========================2020-03-02 10:03: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 ( '311876', 'B42E99EAFF7BBAB51973', '039', 'DESKTOP-3S2HOTC', '110', '1920', '1080', 'pjk5372', '대호산업[박준경]', '015452661740' ) ========================2020-03-02 11:35:37======================== noteurl_start parm_app_code = 039 parm_pc_name = W10-I3PC-4130 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D05099312FCAC66A96A0 sCDKey = 638321752964 sName = W10-I3PC-4130 ========================2020-03-02 11:35: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 = '638321752964' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-02 11:35:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rth1513' ========================2020-03-02 11:35:37======================== SELECT idx FROM macs WHERE mac_addr = 'D05099312FCAC66A96A0' AND app_code = '039' ========================2020-03-02 11:35:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311972' ========================2020-03-02 11:35:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311972' ========================2020-03-02 11:35:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '311972', 'D05099312FCAC66A96A0', '039', 'W10-I3PC-4130', '110', '1600', '900', 'rth1513', '세기건설산업[류태희]', '638321752964' ) ========================2020-03-02 17:06:18======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-PI2TB7MN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 988389484F1D4A31507D sCDKey = 115259231493 sName = LAPTOP-PI2TB7MN ========================2020-03-02 17:06:18======================== 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 = '115259231493' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-02 17:06:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'esmed' ========================2020-03-02 17:06:18======================== SELECT idx FROM macs WHERE mac_addr = '988389484F1D4A31507D' AND app_code = '039' ========================2020-03-02 17:06:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '295748' ========================2020-03-02 17:06:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '295748' ========================2020-03-02 17:06:18======================== UPDATE mac_detail SET pc_name = 'LAPTOP-PI2TB7MN', os_type = '110', user_id = 'esmed', user_name = '은성메디케어[임상훈]', screen_w = '1536', screen_h = '864', cdkey = '115259231493' WHERE mac_idx = '295748' ========================2020-03-02 17:31:22======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-6UKNQRK parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23F116648769668 sCDKey = 565849073446 sName = DESKTOP-6UKNQRK ========================2020-03-02 17:31:22======================== 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 = '565849073446' AND r.app_code = '050' AND r.app_block = 0 ========================2020-03-02 17:31:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dasstech' ========================2020-03-02 17:31:22======================== SELECT idx FROM macs WHERE mac_addr = '7085C23F116648769668' AND app_code = '050' ========================2020-03-02 17:31:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308842' ========================2020-03-02 17:31:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308842' ========================2020-03-02 17:31:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308842', '7085C23F116648769668', '050', 'DESKTOP-6UKNQRK', '109', '1920', '1080', 'dasstech', '다쓰테크[최명철]', '565849073446' )