========================2018-07-31 09:39:05======================== noteurl_start parm_app_code = 050 parm_pc_name = 문완식 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D3048F2C0780A5D3E sCDKey = 641664081151 sName = 문완식 ========================2018-07-31 09:39: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 = '641664081151' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-31 09:39:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yeojufmc031' ========================2018-07-31 09:39:05======================== SELECT idx FROM macs WHERE mac_addr = 'F44D3048F2C0780A5D3E' AND app_code = '050' ========================2018-07-31 09:39:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256055' ========================2018-07-31 09:39:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256055' ========================2018-07-31 09:39: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 ( '256055', 'F44D3048F2C0780A5D3E', '050', '문완식', '109', '1920', '1080', 'yeojufmc031', '여주군시설관리공단[양승관]', '641664081151' ) ========================2018-07-31 10:17:18======================== noteurl_start parm_app_code = 050 parm_pc_name = KAIST21 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C8600056D2DAB06CDA02 sCDKey = 3359666wd112 sName = KAIST21 ========================2018-07-31 10:17: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 = '3359666WD112' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-31 11:00:43======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A493ABC8BBB sCDKey = 851095746023 sName = SEOWL17H15185 ========================2018-07-31 11:00:43======================== 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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2018-07-31 11:34:53======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883893EF3073E19A3CD sCDKey = 224600287283 sName = ========================2018-07-31 11:34:53======================== 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 = '224600287283' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-31 11:35:01======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883893EF3073E19A3CD sCDKey = 224600287283 sName = 덕천공장 ========================2018-07-31 11:35: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 = '224600287283' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-31 11:35:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lhm688' ========================2018-07-31 11:35:01======================== SELECT idx FROM macs WHERE mac_addr = '9883893EF3073E19A3CD' AND app_code = '039' ========================2018-07-31 11:35:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256074' ========================2018-07-31 11:35:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256074' ========================2018-07-31 11:35: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 ( '256074', '9883893EF3073E19A3CD', '039', '덕천공장', '110', '1920', '1080', 'lhm688', '덕천공장[이형모]', '224600287283' ) ========================2018-07-31 12:28:54======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ATUMISP parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEC87D9F6BAF49E sCDKey = 134315523299 sName = DESKTOP-ATUMISP ========================2018-07-31 12:28: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 = '134315523299' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-31 12:28:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'namsun2844' ========================2018-07-31 12:28:54======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEC87D9F6BAF49E' AND app_code = '047' ========================2018-07-31 12:28:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241130' ========================2018-07-31 12:28:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241130' ========================2018-07-31 12:28:54======================== UPDATE mac_detail SET pc_name = 'DESKTOP-ATUMISP', os_type = '�쐢�룄�슦 10', user_id = 'namsun2844', user_name = '남선종합유통(주)[정주연]', screen_w = '0', screen_h = '0', cdkey = '134315523299' WHERE mac_idx = '241130' ========================2018-07-31 13:05:52======================== noteurl_start parm_app_code = 039 parm_pc_name = JR-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1831BFCC2424AE7C5E3 sCDKey = 720212658677 sName = JR-PC ========================2018-07-31 13:05: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 = '720212658677' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-31 13:05:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'study80jin' ========================2018-07-31 13:05:52======================== SELECT idx FROM macs WHERE mac_addr = '1831BFCC2424AE7C5E3' AND app_code = '039' ========================2018-07-31 13:05:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256084' ========================2018-07-31 13:05:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256084' ========================2018-07-31 13:05:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256084', '1831BFCC2424AE7C5E3', '039', 'JR-PC', '110', '1920', '1080', 'study80jin', '준메디케어[박경숙]', '720212658677' ) ========================2018-07-31 14:28:55======================== noteurl_start parm_app_code = 039 parm_pc_name = 20180620-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001966CFE6FBEE1999FD sCDKey = 505525054564 sName = 20180620-PC ========================2018-07-31 14:28:55======================== 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 = '505525054564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-31 14:28:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dud7791' ========================2018-07-31 14:28:55======================== SELECT idx FROM macs WHERE mac_addr = '001966CFE6FBEE1999FD' AND app_code = '039' ========================2018-07-31 14:28:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253182' ========================2018-07-31 14:28:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253182' ========================2018-07-31 14:28:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253182', '001966CFE6FBEE1999FD', '039', '20180620-PC', '90', '1920', '1080', 'dud7791', '영창빌딩[김영식]', '505525054564' ) ========================2018-07-31 16:24:02======================== noteurl_start parm_app_code = 045 parm_pc_name = ART-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D8BDD468CFA75B1 sCDKey = 053389245573 sName = ART-PC ========================2018-07-31 16:24:02======================== 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 = '053389245573' AND r.app_code = '045' AND r.app_block = 0 ========================2018-07-31 16:24:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nodenskorea' ========================2018-07-31 16:24:02======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D8BDD468CFA75B1' AND app_code = '045' ========================2018-07-31 16:24:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256114' ========================2018-07-31 16:24:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256114' ========================2018-07-31 16:24:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256114', '1C1B0D8BDD468CFA75B1', '045', 'ART-PC', '90', '1920', '1080', 'nodenskorea', '(주)노덴스코리아[유창덕]', '053389245573' ) ========================2018-07-31 17:06:05======================== noteurl_start parm_app_code = 046 parm_pc_name = TM1610 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDBF57D85C7378A5 sCDKey = 709794354855 sName = TM1610 ========================2018-07-31 17:06: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 = '709794354855' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-31 17:06:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cgbeauty2' ========================2018-07-31 17:06:05======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDBF57D85C7378A5' AND app_code = '046' ========================2018-07-31 17:06:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256123' ========================2018-07-31 17:06:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256123' ========================2018-07-31 17:06: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 ( '256123', 'B8AEEDBF57D85C7378A5', '046', 'TM1610', '110', '1920', '1080', 'cgbeauty2', '청구미용재료[최윤정]', '709794354855' )