========================2022-04-01 07:43:42======================== 
noteurl_start 
parm_app_code = 048 
parm_pc_name = DESKTOP-8NHG7QE 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 8CB0E9944FBFF2DE67F8 
sCDKey = 434133617514 
sName = DESKTOP-8NHG7QE 
========================2022-04-01 07:43: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 = '434133617514' 
			AND r.app_code = '048'
			AND r.app_block = 0 



========================2022-04-01 07:45:30======================== 
noteurl_start 
parm_app_code = 048 
parm_pc_name = DESKTOP-8NHG7QE 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 8CB0E9944FBFF2DE67F8 
sCDKey = 434133617514 
sName = DESKTOP-8NHG7QE 
========================2022-04-01 07:45:30======================== 
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 
========================2022-04-01 07:45:30======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'weblink'  
========================2022-04-01 07:45:30======================== 
SELECT idx FROM macs WHERE mac_addr = '8CB0E9944FBFF2DE67F8' AND app_code = '048' 
========================2022-04-01 07:45:30======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '364338' 
========================2022-04-01 07:45:30======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '364338' 
========================2022-04-01 07:45:30======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '364338', '8CB0E9944FBFF2DE67F8', '048', 'DESKTOP-8NHG7QE', '�쐢�룄�슦 10', '0', '0', 'weblink', '´ë¼ºÈ°¾î[°­Á¤¹Ì]', '434133617514'  ) 



========================2022-04-01 14:17:37======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-A10RJRE 
parm_os_type = 110 
parm_screen_w = 1280 
parm_screen_h = 720 
parm_user_mac = AC12030B320E3A672030 
sCDKey = 812967860035 
sName = DESKTOP-A10RJRE 
========================2022-04-01 14:17: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 = '812967860035' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-01 14:17:37======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ess301'  
========================2022-04-01 14:17:37======================== 
SELECT idx FROM macs WHERE mac_addr = 'AC12030B320E3A672030' AND app_code = '039' 
========================2022-04-01 14:17:37======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326354' 
========================2022-04-01 14:17:37======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '326354' 
========================2022-04-01 14:17:37======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-A10RJRE', os_type = '110', user_id = 'ess301', user_name = '½Å¿ë¾ç°¡±¸[¾ÈÁöÀº]',
												 screen_w = '1280', screen_h = '720', cdkey = '812967860035'
								  WHERE mac_idx = '326354'  



========================2022-04-01 14:52:05======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-R5UE1V5 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D45D6421B800EE42255E 
sCDKey = 116466244096 
sName = DESKTOP-R5UE1V5 
========================2022-04-01 14:52: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 = '116466244096' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-01 14:52:05======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kpbox1'  
========================2022-04-01 14:52:05======================== 
SELECT idx FROM macs WHERE mac_addr = 'D45D6421B800EE42255E' AND app_code = '039' 
========================2022-04-01 14:52:05======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '364321' 
========================2022-04-01 14:52:05======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '364321' 
========================2022-04-01 14:52: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	 ( '364321', 'D45D6421B800EE42255E', '039', 'DESKTOP-R5UE1V5', '110', '1920', '1080', 'kpbox1', '±Ùdz½Ç¾÷[±èÇý¼÷]', '116466244096'  ) 



========================2022-04-01 14:52:27======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-SPRDIUB 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 704D7B2EEE2C4A23CD3B 
sCDKey = 116466244096 
sName = DESKTOP-SPRDIUB 
========================2022-04-01 14:52:27======================== 
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 = '116466244096' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-01 14:52:27======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kpbox1'  
========================2022-04-01 14:52:27======================== 
SELECT idx FROM macs WHERE mac_addr = '704D7B2EEE2C4A23CD3B' AND app_code = '039' 
========================2022-04-01 14:52:27======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315585' 
========================2022-04-01 14:52:27======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '315585' 
========================2022-04-01 14:52:27======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-SPRDIUB', os_type = '110', user_id = 'kpbox1', user_name = '±Ùdz½Ç¾÷[±èÇý¼÷]',
												 screen_w = '1920', screen_h = '1080', cdkey = '116466244096'
								  WHERE mac_idx = '315585'  



========================2022-04-01 15:08:21======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = DESKTOP-GHTP11R 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 68EDA4445CA40EEF09AE 
sCDKey = 718475474074 
sName = DESKTOP-GHTP11R 
========================2022-04-01 15:08:21======================== 
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 = '718475474074' 
			AND r.app_code = '047'
			AND r.app_block = 0 
========================2022-04-01 15:08:21======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'onejinro'  
========================2022-04-01 15:08:21======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA4445CA40EEF09AE' AND app_code = '047' 
========================2022-04-01 15:08:21======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '363942' 
========================2022-04-01 15:08:21======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '363942' 
========================2022-04-01 15:08:21======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-GHTP11R', os_type = '�쐢�룄�슦 10', user_id = 'onejinro', user_name = '¿øǪµåÄÚÆÛ·¹À̼Ç[Á¤Å°Ç]',
												 screen_w = '0', screen_h = '0', cdkey = '718475474074'
								  WHERE mac_idx = '363942'  



========================2022-04-01 16:11:38======================== 
noteurl_start 
parm_app_code = 047 
parm_pc_name = DESKTOP-GHTP11R 
parm_os_type = �쐢�룄�슦 10 
parm_screen_w = 0 
parm_screen_h = 0 
parm_user_mac = 68EDA4445CA40EEF09AE 
sCDKey = 718475474074 
sName = DESKTOP-GHTP11R 
========================2022-04-01 16:11:38======================== 
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 = '718475474074' 
			AND r.app_code = '047'
			AND r.app_block = 0 
========================2022-04-01 16:11:38======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'onejinro'  
========================2022-04-01 16:11:38======================== 
SELECT idx FROM macs WHERE mac_addr = '68EDA4445CA40EEF09AE' AND app_code = '047' 
========================2022-04-01 16:11:38======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '363942' 
========================2022-04-01 16:11:38======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '363942' 
========================2022-04-01 16:11:38======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-GHTP11R', os_type = '�쐢�룄�슦 10', user_id = 'onejinro', user_name = '¿øǪµåÄÚÆÛ·¹À̼Ç[Á¤Å°Ç]',
												 screen_w = '0', screen_h = '0', cdkey = '718475474074'
								  WHERE mac_idx = '363942'