========================2018-01-23 08:47:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DX9ORFAEJQEGOMN parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6CF0495384B2BC106401 sCDKey = 266382448056 sName = DX9ORFAEJQEGOMN ========================2018-01-23 08:47: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 = '266382448056' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-23 09:07:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DX9ORFAEJQEGOMN parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6CF0495384B2BC106401 sCDKey = 266382448056 sName = DX9ORFAEJQEGOMN ========================2018-01-23 09:07:48======================== 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 = '266382448056' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-23 09:07:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tk9400' ========================2018-01-23 09:07:49======================== SELECT idx FROM macs WHERE mac_addr = '6CF0495384B2BC106401' AND app_code = '039' ========================2018-01-23 09:07:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235382' ========================2018-01-23 09:07:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235382' ========================2018-01-23 09:07:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '235382', '6CF0495384B2BC106401', '039', 'DX9ORFAEJQEGOMN', '90', '1920', '1080', 'tk9400', '태경전기[이진태]', '266382448056' ) ========================2018-01-23 09:47:37======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 00012E4AE436301EBC42 sCDKey = 939773888532 sName = USER-PC ========================2018-01-23 09:47: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 = '939773888532' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-23 09:47:46======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 00012E4AE436301EBC42 sCDKey = 939773888532 sName = sh32933 ========================2018-01-23 09:47: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 = '939773888532' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-23 09:48:20======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 00012E4AE436301EBC42 sCDKey = 939773888532 sName = sh32933 ========================2018-01-23 09:48: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 = '939773888532' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-23 09:57:10======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D739E9FEAFD372A sCDKey = 475639642848 sName = USER-PC ========================2018-01-23 09:57:10======================== 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 = '475639642848' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-23 09:57:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sharon' ========================2018-01-23 09:57:10======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D739E9FEAFD372A' AND app_code = '046' ========================2018-01-23 09:57:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '201414' ========================2018-01-23 09:57:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '201414' ========================2018-01-23 09:57:10======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'sharon', user_name = '샤론플라워랜드[김보필]', screen_w = '1920', screen_h = '1080', cdkey = '475639642848' WHERE mac_idx = '201414' ========================2018-01-23 11:06:46======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CFDA159924130FD9D75 sCDKey = 427808194172 sName = 클라pc ========================2018-01-23 11:06: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 = '427808194172' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-23 11:06:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'JMJ9885' ========================2018-01-23 11:06:46======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA159924130FD9D75' AND app_code = '039' ========================2018-01-23 11:06:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240128' ========================2018-01-23 11:06:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240128' ========================2018-01-23 11:06: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 ( '240128', '2CFDA159924130FD9D75', '039', '클라pc', '110', '1920', '1080', 'JMJ9885', '(주)진접골재산업[현수정]', '427808194172' ) ========================2018-01-23 12:37:42======================== noteurl_start parm_app_code = 046 parm_pc_name = HOMESPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF7325BFF3A4AF7DFD sCDKey = 921252470168 sName = HOMESPOS ========================2018-01-23 12:37:42======================== 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 = '921252470168' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-23 12:37:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2018-01-23 12:37:42======================== SELECT idx FROM macs WHERE mac_addr = '50AF7325BFF3A4AF7DFD' AND app_code = '046' ========================2018-01-23 12:37:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236522' ========================2018-01-23 12:37:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236522' ========================2018-01-23 12:37:42======================== UPDATE mac_detail SET pc_name = 'HOMESPOS', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1024', screen_h = '768', cdkey = '921252470168' WHERE mac_idx = '236522' ========================2018-01-23 14:26:49======================== noteurl_start parm_app_code = 050 parm_pc_name = KOSTI-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838915E7CDA46303F2 sCDKey = 964335646788 sName = KOSTI-PC ========================2018-01-23 14:26:49======================== 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 = '964335646788' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-23 14:26:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kosti' ========================2018-01-23 14:26:49======================== SELECT idx FROM macs WHERE mac_addr = '98838915E7CDA46303F2' AND app_code = '050' ========================2018-01-23 14:26:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235968' ========================2018-01-23 14:26:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235968' ========================2018-01-23 14:26:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '235968', '98838915E7CDA46303F2', '050', 'KOSTI-PC', '90', '1920', '1080', 'kosti', '전략물자관리원[홍종권]', '964335646788' ) ========================2018-01-23 14:32:23======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-UC5GCVJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307CAC253935 sCDKey = 570844097736 sName = DESKTOP-UC5GCVJ ========================2018-01-23 14:32: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 = '570844097736' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-23 14:32:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ria8210' ========================2018-01-23 14:32:23======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307CAC253935' AND app_code = '046' ========================2018-01-23 14:32:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '231694' ========================2018-01-23 14:32:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '231694' ========================2018-01-23 14:32:23======================== UPDATE mac_detail SET pc_name = 'DESKTOP-UC5GCVJ', os_type = '110', user_id = 'ria8210', user_name = '미진소프트[김민정]', screen_w = '1920', screen_h = '1080', cdkey = '570844097736' WHERE mac_idx = '231694' ========================2018-01-23 15:33:12======================== noteurl_start parm_app_code = 050 parm_pc_name = USER_IP parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1831BF247EA8C669F5D3 sCDKey = 248664335664 sName = USER_IP ========================2018-01-23 15:33: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 = '248664335664' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-23 15:33:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gwacheon' ========================2018-01-23 15:33:12======================== SELECT idx FROM macs WHERE mac_addr = '1831BF247EA8C669F5D3' AND app_code = '050' ========================2018-01-23 15:33:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240165' ========================2018-01-23 15:33:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240165' ========================2018-01-23 15:33:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240165', '1831BF247EA8C669F5D3', '050', 'USER_IP', '90', '1920', '1080', 'gwacheon', '과천청사관리소[관리과]', '248664335664' )