========================2019-07-18 08:02:39======================== noteurl_start parm_app_code = 048 parm_pc_name = 2층창가쪽 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DD940A00B06E21 sCDKey = 434133617514 sName = 2층창가쪽 ========================2019-07-18 08:02: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-07-18 08:02:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-07-18 08:02:39======================== SELECT idx FROM macs WHERE mac_addr = '988389DD940A00B06E21' AND app_code = '048' ========================2019-07-18 08:02:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285233' ========================2019-07-18 08:02:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285233' ========================2019-07-18 08:02:39======================== UPDATE mac_detail SET pc_name = '2층창가쪽', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '285233' ========================2019-07-18 10:04:58======================== noteurl_start parm_app_code = 051 parm_pc_name = HEA002174 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC8385F36B2DBC805A62 sCDKey = 937740825227 sName = HEA002174 ========================2019-07-18 10:04: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 = '937740825227' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-18 10:09:33======================== noteurl_start parm_app_code = 050 parm_pc_name = HJH-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 740774807614 sName = HJH-PC ========================2019-07-18 10:09:33======================== 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 = '740774807614' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-18 10:09:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2019-07-18 10:09:33======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '050' ========================2019-07-18 10:09:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '225470' ========================2019-07-18 10:09:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '225470' ========================2019-07-18 10:09:33======================== UPDATE mac_detail SET pc_name = 'HJH-PC', os_type = '109', user_id = 'wogus36', user_name = '[황재현]', screen_w = '1920', screen_h = '1080', cdkey = '740774807614' WHERE mac_idx = '225470' ========================2019-07-18 11:23:22======================== noteurl_start parm_app_code = 047 parm_pc_name = OKPOS parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975AACF10676634BC0 sCDKey = 749447224532 sName = OKPOS ========================2019-07-18 11:23: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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-18 11:23:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nexus' ========================2019-07-18 11:23:22======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AACF10676634BC0' AND app_code = '047' ========================2019-07-18 11:23:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291062' ========================2019-07-18 11:23:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291062' ========================2019-07-18 11:23: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 ( '291062', 'B8975AACF10676634BC0', '047', 'OKPOS', '�쐢�룄�슦 7', '0', '0', 'nexus', '넥서스메디케어[박종국]', '749447224532' ) ========================2019-07-18 14:19:59======================== noteurl_start parm_app_code = 050 parm_pc_name = PN401 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0C5899AC11C801E36F5 sCDKey = 571544737699 sName = PN401 ========================2019-07-18 14:19:59======================== 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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-18 14:19:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hancomm' ========================2019-07-18 14:19:59======================== SELECT idx FROM macs WHERE mac_addr = 'A0C5899AC11C801E36F5' AND app_code = '050' ========================2019-07-18 14:19:59======================== 값이 없을 경우 ========================2019-07-18 14:21:07======================== noteurl_start parm_app_code = 050 parm_pc_name = PN401 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0C5899AC11C801E36F5 sCDKey = 571544737699 sName = 한컴 ========================2019-07-18 14:21:07======================== 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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-18 14:21:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hancomm' ========================2019-07-18 14:21:07======================== SELECT idx FROM macs WHERE mac_addr = 'A0C5899AC11C801E36F5' AND app_code = '050' ========================2019-07-18 14:21:07======================== 값이 없을 경우 ========================2019-07-18 14:23:16======================== noteurl_start parm_app_code = 050 parm_pc_name = PN401 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0C5899AC11C801E36F5 sCDKey = 571544737699 sName = 한컴 ========================2019-07-18 14:23:16======================== 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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-18 14:23:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hancomm' ========================2019-07-18 14:23:16======================== SELECT idx FROM macs WHERE mac_addr = 'A0C5899AC11C801E36F5' AND app_code = '050' ========================2019-07-18 14:23:16======================== 값이 없을 경우 ========================2019-07-18 14:24:53======================== noteurl_start parm_app_code = 050 parm_pc_name = PN401 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0C5899AC11C801E36F5 sCDKey = 571544737699 sName = PN401 ========================2019-07-18 14:24: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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-18 14:24:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hancomm' ========================2019-07-18 14:24:53======================== SELECT idx FROM macs WHERE mac_addr = 'A0C5899AC11C801E36F5' AND app_code = '050' ========================2019-07-18 14:24:53======================== 값이 없을 경우 ========================2019-07-18 14:26:57======================== noteurl_start parm_app_code = 050 parm_pc_name = PN401 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0C5899AC11C801E36F5 sCDKey = 571544737699 sName = PN401 ========================2019-07-18 14:26:57======================== 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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-18 14:26:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hancomm' ========================2019-07-18 14:26:57======================== SELECT idx FROM macs WHERE mac_addr = 'A0C5899AC11C801E36F5' AND app_code = '050' ========================2019-07-18 14:26:57======================== 값이 없을 경우 ========================2019-07-18 14:27:54======================== noteurl_start parm_app_code = 050 parm_pc_name = PN401 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883893C6F35801E36F5 sCDKey = 571544737699 sName = PN401 ========================2019-07-18 14:27: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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-18 14:27:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hancomm' ========================2019-07-18 14:27:54======================== SELECT idx FROM macs WHERE mac_addr = '9883893C6F35801E36F5' AND app_code = '050' ========================2019-07-18 14:27:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291086' ========================2019-07-18 14:27:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291086' ========================2019-07-18 14:27: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 ( '291086', '9883893C6F35801E36F5', '050', 'PN401', '109', '1920', '1080', 'hancomm', '한컴[이수진]', '571544737699' ) ========================2019-07-18 14:30:05======================== noteurl_start parm_app_code = 046 parm_pc_name = PJH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 944629376206 sName = PJH ========================2019-07-18 14:30: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 = '944629376206' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-18 14:30:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youi92' ========================2019-07-18 14:30:05======================== SELECT idx FROM macs WHERE mac_addr = '7085C2B92617DABAE9EC' AND app_code = '046' ========================2019-07-18 14:30:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281354' ========================2019-07-18 14:30:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281354' ========================2019-07-18 14:30: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 ( '281354', '7085C2B92617DABAE9EC', '046', 'PJH', '110', '1920', '1080', 'youi92', '[박주현]', '944629376206' ) ========================2019-07-18 15:26:48======================== noteurl_start parm_app_code = 050 parm_pc_name = LSH-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245433345AC80F3AF1 sCDKey = 115092454601 sName = LSH-PC ========================2019-07-18 15:26: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 = '115092454601' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-18 15:26:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoonmin1121' ========================2019-07-18 15:26:48======================== SELECT idx FROM macs WHERE mac_addr = '00245433345AC80F3AF1' AND app_code = '050' ========================2019-07-18 15:26:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274546' ========================2019-07-18 15:26:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274546' ========================2019-07-18 15:26:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274546', '00245433345AC80F3AF1', '050', 'LSH-PC', '109', '1920', '1080', 'yoonmin1121', '[이수현]', '115092454601' )