

========================2024-06-27 09:57:48======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IVLIJ2B 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C23428DCBAF38365 
sCDKey = 678905519571 
sName = DESKTOP-IVLIJ2B 
========================2024-06-27 09:57: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 = '678905519571' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2024-06-27 09:57:48======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'solbar'  
========================2024-06-27 09:57:48======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C23428DCBAF38365' AND app_code = '050' 
========================2024-06-27 09:57:48======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365019' 
========================2024-06-27 09:57:48======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '365019' 
========================2024-06-27 09:57:48======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-IVLIJ2B', os_type = '109', user_id = 'solbar', user_name = '(주)솔바텍[오영근]',
												 screen_w = '1920', screen_h = '1080', cdkey = '678905519571'
								  WHERE mac_idx = '365019'  


========================2024-06-27 10:20:07======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-8CIQFF2 
parm_os_type = 109 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = 64E599FB3E06B4FFE751 
sCDKey = 721062265539 
sName = DESKTOP-8CIQFF2 
========================2024-06-27 10:20: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 = '721062265539' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2024-06-27 10:20:07======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'adam5352'  
========================2024-06-27 10:20:07======================== 
SELECT idx FROM macs WHERE mac_addr = '64E599FB3E06B4FFE751' AND app_code = '050' 
========================2024-06-27 10:20:07======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390222' 
========================2024-06-27 10:20:07======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '390222' 
========================2024-06-27 10:20:07======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-8CIQFF2', os_type = '109', user_id = 'adam5352', user_name = '다미식품[오상목]',
												 screen_w = '1280', screen_h = '1024', cdkey = '721062265539'
								  WHERE mac_idx = '390222'  


========================2024-06-27 10:29:24======================== 
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 = 469505700148 
sName = HJH-PC 
========================2024-06-27 10:29:24======================== 
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 = '469505700148' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2024-06-27 10:29:24======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'wogus36'  
========================2024-06-27 10:29:24======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '046' 
========================2024-06-27 10:29:24======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244420' 
========================2024-06-27 10:29:24======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '244420' 
========================2024-06-27 10:29:24======================== 
UPDATE mac_detail SET  pc_name = 'HJH-PC', os_type = '110', user_id = 'wogus36', user_name = '엠제이소프트[황재현]',
												 screen_w = '1920', screen_h = '1080', cdkey = '469505700148'
								  WHERE mac_idx = '244420'  


========================2024-06-27 13:12:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = MINJU 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 0A002700000F54A0AD7F 
sCDKey = 682505689238 
sName = MINJU 
========================2024-06-27 13:12: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 = '682505689238' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-06-27 13:12:30======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kmj0801'  
========================2024-06-27 13:12:30======================== 
SELECT idx FROM macs WHERE mac_addr = '0A002700000F54A0AD7F' AND app_code = '039' 
========================2024-06-27 13:12:30======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '405418' 
========================2024-06-27 13:12:30======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '405418' 
========================2024-06-27 13:12: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	 ( '405418', '0A002700000F54A0AD7F', '039', 'MINJU', '110', '1920', '1080', 'kmj0801', '엠제이소프트[김민주]', '682505689238'  ) 


========================2024-06-27 15:38:25======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-JBUU3P2 
parm_os_type = 109 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = F8A2D657A73394D69375 
sCDKey = 075460165176 
sName = DESKTOP-JBUU3P2 
========================2024-06-27 15:38:25======================== 
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 = '075460165176' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2024-06-27 16:43:20======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-66EQ14N 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9C6B005CFB069C34C0B4 
sCDKey = 533364286570 
sName = DESKTOP-66EQ14N 
========================2024-06-27 16:43: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 = '533364286570' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-06-27 16:43:20======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'uksung1966'  
========================2024-06-27 16:43:20======================== 
SELECT idx FROM macs WHERE mac_addr = '9C6B005CFB069C34C0B4' AND app_code = '039' 
========================2024-06-27 16:43:20======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407461' 
========================2024-06-27 16:43:20======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '407461' 
========================2024-06-27 16:43:20======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '407461', '9C6B005CFB069C34C0B4', '039', 'DESKTOP-66EQ14N', '110', '1920', '1080', 'uksung1966', '욱성화학공업사[이성춘]', '533364286570'  ) 


========================2024-06-27 16:45:36======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = 욱성 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C2F4E8A5DAEFD597 
sCDKey = 533364286570 
sName = 욱성 
========================2024-06-27 16:45: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 = '533364286570' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-06-27 16:45:36======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'uksung1966'  
========================2024-06-27 16:45:36======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C2F4E8A5DAEFD597' AND app_code = '039' 
========================2024-06-27 16:45:36======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307281' 
========================2024-06-27 16:45:36======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '307281' 
========================2024-06-27 16:45:36======================== 
UPDATE mac_detail SET  pc_name = '욱성', os_type = '110', user_id = 'uksung1966', user_name = '욱성화학공업사[이성춘]',
												 screen_w = '1920', screen_h = '1080', cdkey = '533364286570'
								  WHERE mac_idx = '307281'