========================2018-02-28 11:24:54======================== noteurl_start parm_app_code = 039 parm_pc_name = SEGIPC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D05099312FCA12348122 sCDKey = 638321752964 sName = SEGIPC ========================2018-02-28 11:24:54======================== 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 ========================2018-02-28 11:24:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rth1513' ========================2018-02-28 11:24:54======================== SELECT idx FROM macs WHERE mac_addr = 'D05099312FCA12348122' AND app_code = '039' ========================2018-02-28 11:24:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242908' ========================2018-02-28 11:24:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242908' ========================2018-02-28 11:24:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '242908', 'D05099312FCA12348122', '039', 'SEGIPC', '90', '1600', '900', 'rth1513', '세기건설산업[류태희]', '638321752964' ) ========================2018-02-28 11:25:19======================== noteurl_start parm_app_code = 039 parm_pc_name = SEGIPC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D05099312FCA12348122 sCDKey = 638321752964 sName = SEGIPC ========================2018-02-28 11:25:19======================== 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 ========================2018-02-28 11:25:34======================== noteurl_start parm_app_code = 039 parm_pc_name = SEGIPC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D05099312FCA12348122 sCDKey = 638321752964 sName = SEGIPC ========================2018-02-28 11:25: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 = '638321752964' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-28 11:26:01======================== noteurl_start parm_app_code = 039 parm_pc_name = SEGIPC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D05099312FCA12348122 sCDKey = 638321752964 sName = SEGIPC ========================2018-02-28 11:26: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 = '638321752964' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-28 14:40:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EHUURF9 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 6045CB209521B85D7646 sCDKey = 917355058631 sName = DESKTOP-EHUURF9 ========================2018-02-28 14:40: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 = '917355058631' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-28 14:40:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbelectro' ========================2018-02-28 14:40:30======================== SELECT idx FROM macs WHERE mac_addr = '6045CB209521B85D7646' AND app_code = '039' ========================2018-02-28 14:40:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '227667' ========================2018-02-28 14:40:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '227667' ========================2018-02-28 14:40: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 ( '227667', '6045CB209521B85D7646', '039', 'DESKTOP-EHUURF9', '110', '1536', '864', 'jbelectro', '제이앤비[김선택]', '917355058631' ) ========================2018-02-28 16:57:20======================== noteurl_start parm_app_code = 050 parm_pc_name = 1600 parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = D850E6DBC7147260C65C sCDKey = 918884058469 sName = 1600 ========================2018-02-28 16:57:20======================== 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 = '918884058469' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-28 16:57:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cbo0311' ========================2018-02-28 16:57:20======================== SELECT idx FROM macs WHERE mac_addr = 'D850E6DBC7147260C65C' AND app_code = '050' ========================2018-02-28 16:57:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243169' ========================2018-02-28 16:57:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243169' ========================2018-02-28 16:57:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243169', 'D850E6DBC7147260C65C', '050', '1600', '90', '1280', '1024', 'cbo0311', '베스트정보[선은옥]', '918884058469' ) ========================2018-02-28 17:25:23======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-0OILSAC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883891F6DE9ECA0EAAC sCDKey = 788532054684 sName = DESKTOP-0OILSAC ========================2018-02-28 17:25:23======================== 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 = '788532054684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-28 17:25:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-0OILSAC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883891F6DE9ECA0EAAC sCDKey = 788532054684 sName = DESKTOP-0OILSAC ========================2018-02-28 17:25: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 = '788532054684' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-28 17:25:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hijaje' ========================2018-02-28 17:25:36======================== SELECT idx FROM macs WHERE mac_addr = '9883891F6DE9ECA0EAAC' AND app_code = '046' ========================2018-02-28 17:25:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243176' ========================2018-02-28 17:25:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243176' ========================2018-02-28 17:25:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '243176', '9883891F6DE9ECA0EAAC', '046', 'DESKTOP-0OILSAC', '110', '1920', '1080', 'hijaje', '헌인자재[박철교]', '788532054684' )