

========================2019-11-19 09:22:17======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC 
parm_os_type = 90 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 002454928B68B04B8F8C 
sCDKey = 302068335544 
sName = PC 
========================2019-11-19 09:22:17======================== 
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 = '302068335544' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-11-19 09:22:17======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mbinc'  
========================2019-11-19 09:22:17======================== 
SELECT idx FROM macs WHERE mac_addr = '002454928B68B04B8F8C' AND app_code = '039' 
========================2019-11-19 09:22:17======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303119' 
========================2019-11-19 09:22:17======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '303119' 
========================2019-11-19 09:22:17======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '303119', '002454928B68B04B8F8C', '039', 'PC', '90', '1600', '900', 'mbinc', 'M.B 산업[조미정]', '302068335544'  ) 


========================2019-11-19 10:24:40======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = COM 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A4DB3082245280151477 
sCDKey = 342918991698 
sName = COM 
========================2019-11-19 10:24:40======================== 
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 = '342918991698' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-11-19 10:24:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jun9317718'  
========================2019-11-19 10:24:40======================== 
SELECT idx FROM macs WHERE mac_addr = 'A4DB3082245280151477' AND app_code = '046' 
========================2019-11-19 10:24:40======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '300832' 
========================2019-11-19 10:24:40======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '300832' 
========================2019-11-19 10:24:40======================== 
UPDATE mac_detail SET  pc_name = 'COM', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]',
												 screen_w = '1920', screen_h = '1080', cdkey = '342918991698'
								  WHERE mac_idx = '300832'  


========================2019-11-19 10:49:32======================== 
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 = 909F3309C73FA4AF7DFD 
sCDKey = 921252470168 
sName = HOMESPOS 
========================2019-11-19 10:49: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 = '921252470168' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-11-19 10:49:32======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cherhomes'  
========================2019-11-19 10:49:32======================== 
SELECT idx FROM macs WHERE mac_addr = '909F3309C73FA4AF7DFD' AND app_code = '046' 
========================2019-11-19 10:49:32======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303155' 
========================2019-11-19 10:49:32======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '303155' 
========================2019-11-19 10:49:32======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '303155', '909F3309C73FA4AF7DFD', '046', 'HOMESPOS', '110', '1024', '768', 'cherhomes', '쉐르홈즈[최화별]', '921252470168'  ) 


========================2019-11-19 10:52:18======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-3DH1BOK 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F4B5201DE6843484092C 
sCDKey = 334487476774 
sName = DESKTOP-3DH1BOK 
========================2019-11-19 10:52: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 = '334487476774' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-11-19 10:52:18======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hhc0301'  
========================2019-11-19 10:52:18======================== 
SELECT idx FROM macs WHERE mac_addr = 'F4B5201DE6843484092C' AND app_code = '039' 
========================2019-11-19 10:52:18======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301766' 
========================2019-11-19 10:52:18======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '301766' 
========================2019-11-19 10:52: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	 ( '301766', 'F4B5201DE6843484092C', '039', 'DESKTOP-3DH1BOK', '110', '1920', '1080', 'hhc0301', '한일모타펌프공사[하정훈]', '334487476774'  ) 


========================2019-11-19 11:52:36======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-KNQ7C1M 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 24F5AAEA4D1F12A3E273 
sCDKey = 736015519448 
sName = DESKTOP-KNQ7C1M 
========================2019-11-19 11:52: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 = '736015519448' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-11-19 11:52:36======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'tndbs12'  
========================2019-11-19 11:52:36======================== 
SELECT idx FROM macs WHERE mac_addr = '24F5AAEA4D1F12A3E273' AND app_code = '039' 
========================2019-11-19 11:52:36======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '184755' 
========================2019-11-19 11:52:36======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '184755' 
========================2019-11-19 11:52:36======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-KNQ7C1M', os_type = '110', user_id = 'tndbs12', user_name = '수복유통[김수윤]',
												 screen_w = '1920', screen_h = '1080', cdkey = '736015519448'
								  WHERE mac_idx = '184755'  


========================2019-11-19 15:15:14======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-L743FL4 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 00D861CBC8F04CF550FF 
sCDKey = 891924373584 
sName = DESKTOP-L743FL4 
========================2019-11-19 15:15: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 = '891924373584' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-11-19 15:15:14======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'beom0820'  
========================2019-11-19 15:15:14======================== 
SELECT idx FROM macs WHERE mac_addr = '00D861CBC8F04CF550FF' AND app_code = '039' 
========================2019-11-19 15:15:14======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303183' 
========================2019-11-19 15:15:14======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '303183' 
========================2019-11-19 15:15:14======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '303183', '00D861CBC8F04CF550FF', '039', 'DESKTOP-L743FL4', '110', '1920', '1080', 'beom0820', '범양스텐레스[김선량]', '891924373584'  ) 


========================2019-11-19 17:22:57======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = CLIENT-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 704D7B8440B670892F8C 
sCDKey = 551811080774 
sName = CLIENT-PC 
========================2019-11-19 17:22: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 = '551811080774' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-11-19 17:22:57======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'chsily'  
========================2019-11-19 17:22:57======================== 
SELECT idx FROM macs WHERE mac_addr = '704D7B8440B670892F8C' AND app_code = '046' 
========================2019-11-19 17:22:57======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221457' 
========================2019-11-19 17:22:57======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '221457' 
========================2019-11-19 17:22:57======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '221457', '704D7B8440B670892F8C', '046', 'CLIENT-PC', '90', '1920', '1080', 'chsily', '우성종합상사[전용기]', '551811080774'  ) 


========================2019-11-19 17:23:32======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = SERVER 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = C03FD5F7584FC8138940 
sCDKey = 551811080774 
sName = SERVER 
========================2019-11-19 17:23: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 = '551811080774' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-11-19 17:23:32======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'chsily'  
========================2019-11-19 17:23:32======================== 
SELECT idx FROM macs WHERE mac_addr = 'C03FD5F7584FC8138940' AND app_code = '046' 
========================2019-11-19 17:23:32======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303201' 
========================2019-11-19 17:23:32======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '303201' 
========================2019-11-19 17:23:32======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '303201', 'C03FD5F7584FC8138940', '046', 'SERVER', '90', '1920', '1080', 'chsily', '우성종합상사[전용기]', '551811080774'  ) 


========================2019-11-19 17:46:26======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = HJH-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F44D30B9AE60D8075059 
sCDKey = 737376171670 
sName = HJH-PC 
========================2019-11-19 17:46:26======================== 
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 = '737376171670' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-11-19 17:46:26======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'wogus36'  
========================2019-11-19 17:46:26======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '046' 
========================2019-11-19 17:46:26======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244420' 
========================2019-11-19 17:46:26======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '244420' 
========================2019-11-19 17:46:26======================== 
UPDATE mac_detail SET  pc_name = 'HJH-PC', os_type = '110', user_id = 'wogus36', user_name = '[황재현]',
												 screen_w = '1920', screen_h = '1080', cdkey = '737376171670'
								  WHERE mac_idx = '244420'