========================2019-02-11 08:51:39======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2019-02-11 08:51:39======================== 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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 08:51:56======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2019-02-11 08:51: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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 08:52:32======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2019-02-11 08:52:32======================== 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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 09:04:14======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2019-02-11 09:04: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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 09:04:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hando77' ========================2019-02-11 09:04:14======================== SELECT idx FROM macs WHERE mac_addr = '98838981F74D76D7F1ED' AND app_code = '039' ========================2019-02-11 09:04:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235354' ========================2019-02-11 09:04:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235354' ========================2019-02-11 09:04:14======================== UPDATE mac_detail SET pc_name = 'HANDO', os_type = '110', user_id = 'hando77', user_name = '한도교역[한도교역]', screen_w = '1920', screen_h = '1080', cdkey = '173379187341' WHERE mac_idx = '235354' ========================2019-02-11 10:03:18======================== noteurl_start parm_app_code = 039 parm_pc_name = 7P64-1809131437 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 7085C28EDDBFBA11E6F9 sCDKey = 340958508106 sName = 7P64-1809131437 ========================2019-02-11 10:03: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 = '340958508106' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 10:03:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhkdxo14' ========================2019-02-11 10:03:18======================== SELECT idx FROM macs WHERE mac_addr = '7085C28EDDBFBA11E6F9' AND app_code = '039' ========================2019-02-11 10:03:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275309' ========================2019-02-11 10:03:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275309' ========================2019-02-11 10:03:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275309', '7085C28EDDBFBA11E6F9', '039', '7P64-1809131437', '90', '1680', '1050', 'rhkdxo14', '(주)신평양찹쌀순대[최재민]', '340958508106' ) ========================2019-02-11 11:41:50======================== noteurl_start parm_app_code = 039 parm_pc_name = 2NDOFFICE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7427EADC629BE244476B sCDKey = 665859383034 sName = 2NDOFFICE ========================2019-02-11 11:41:50======================== 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 = '665859383034' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 11:41:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khb1783' ========================2019-02-11 11:41:50======================== SELECT idx FROM macs WHERE mac_addr = '7427EADC629BE244476B' AND app_code = '039' ========================2019-02-11 11:41:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276739' ========================2019-02-11 11:41:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276739' ========================2019-02-11 11:41:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '276739', '7427EADC629BE244476B', '039', '2NDOFFICE', '110', '1920', '1080', 'khb1783', '정엔지니어링[김근수]', '665859383034' ) ========================2019-02-11 13:47:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DHLMGO0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF47ECA79901BFF84 sCDKey = 772176789257 sName = DESKTOP-DHLMGO0 ========================2019-02-11 13:47: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 = '772176789257' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 13:47:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ryuej' ========================2019-02-11 13:47:54======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF47ECA79901BFF84' AND app_code = '039' ========================2019-02-11 13:47:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276760' ========================2019-02-11 13:47:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276760' ========================2019-02-11 13:47: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 ( '276760', 'BC5FF47ECA79901BFF84', '039', 'DESKTOP-DHLMGO0', '110', '1920', '1080', 'ryuej', '정인케미칼[류은정]', '772176789257' ) ========================2019-02-11 13:53:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EPJQAM7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B5200BE80D52BD6C91 sCDKey = 741342538303 sName = DESKTOP-EPJQAM7 ========================2019-02-11 13:53:46======================== 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 = '741342538303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 13:53:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jina2317' ========================2019-02-11 13:53:46======================== SELECT idx FROM macs WHERE mac_addr = 'F4B5200BE80D52BD6C91' AND app_code = '039' ========================2019-02-11 13:53:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276743' ========================2019-02-11 13:53:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276743' ========================2019-02-11 13:53:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '276743', 'F4B5200BE80D52BD6C91', '039', 'DESKTOP-EPJQAM7', '110', '1920', '1080', 'jina2317', '우성기업[조진숙]', '741342538303' ) ========================2019-02-11 16:35:11======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59603FD82 sCDKey = 337888468455 sName = chs1080 ========================2019-02-11 16:35:11======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 16:35:25======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59603FD82 sCDKey = 337888468455 sName = chs1080 ========================2019-02-11 16:35:25======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 16:36:05======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59603FD82 sCDKey = 337888468455 sName = chs1080 ========================2019-02-11 16:36: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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 16:36:09======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59603FD82 sCDKey = 337888468455 sName = chs1080 ========================2019-02-11 16:36:09======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 16:36:13======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59603FD82 sCDKey = 337888468455 sName = chs1080 ========================2019-02-11 16:36:13======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 17:00:05======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 88366CF4283D1230F0C3 sCDKey = 574734148735 sName = USER-PC ========================2019-02-11 17:00: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 = '574734148735' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-11 17:00:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khj1996' ========================2019-02-11 17:00:05======================== SELECT idx FROM macs WHERE mac_addr = '88366CF4283D1230F0C3' AND app_code = '039' ========================2019-02-11 17:00:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276797' ========================2019-02-11 17:00:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276797' ========================2019-02-11 17:00: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 ( '276797', '88366CF4283D1230F0C3', '039', 'USER-PC', '90', '1360', '768', 'khj1996', '하남희[하남희]', '574734148735' ) ========================2019-02-11 17:03:35======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59603FD82 sCDKey = 337888468455 sName = HSCHANG-N ========================2019-02-11 17:03:35======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0