========================2023-10-11 10:14:12======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-N511QFU 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 18C04D39ED918CE1F6C8 
sCDKey = 566401472383 
sName = DESKTOP-N511QFU 
========================2023-10-11 10:14:12======================== 
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 = '566401472383' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2023-10-11 10:14:12======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'pje824'  
========================2023-10-11 10:14:12======================== 
SELECT idx FROM macs WHERE mac_addr = '18C04D39ED918CE1F6C8' AND app_code = '039' 
========================2023-10-11 10:14:12======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347278' 
========================2023-10-11 10:14:12======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '347278' 
========================2023-10-11 10:14:12======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-N511QFU', os_type = '110', user_id = 'pje824', user_name = 'º®¾ØÀåÀÎÅ׸®¾î[¹ÚÇö¼÷]',
												 screen_w = '1920', screen_h = '1080', cdkey = '566401472383'
								  WHERE mac_idx = '347278'  



========================2023-10-11 13:30:26======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-2419F97 
parm_os_type = 110 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = F44D30ADC3762CA2F25C 
sCDKey = 527120413208 
sName = DESKTOP-2419F97 
========================2023-10-11 13:30: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 = '527120413208' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2023-10-11 13:30:26======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'god7208'  
========================2023-10-11 13:30:26======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30ADC3762CA2F25C' AND app_code = '046' 
========================2023-10-11 13:30:26======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '394706' 
========================2023-10-11 13:30:26======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '394706' 
========================2023-10-11 13:30:26======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '394706', 'F44D30ADC3762CA2F25C', '046', 'DESKTOP-2419F97', '110', '1280', '1024', 'god7208', 'ÀÚ¿¬Ãà»ê[¹ÚÁ¤¼÷]', '527120413208'  ) 



========================2023-10-11 17:47:54======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = SKMALL2020 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A8A159871863EC22F36E 
sCDKey = 034473616812 
sName = SKMALL2020 
========================2023-10-11 17:47: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 = '034473616812' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2023-10-11 17:47:54======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'skmall2020'  
========================2023-10-11 17:47:54======================== 
SELECT idx FROM macs WHERE mac_addr = 'A8A159871863EC22F36E' AND app_code = '046' 
========================2023-10-11 17:47:54======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348954' 
========================2023-10-11 17:47:54======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '348954' 
========================2023-10-11 17:47:54======================== 
UPDATE mac_detail SET  pc_name = 'SKMALL2020', os_type = '110', user_id = 'skmall2020', user_name = 'Å·Äá¹Ú½º ¾Æ¸§Á¡[ÀÌÀº¼ø]',
												 screen_w = '1920', screen_h = '1080', cdkey = '034473616812'
								  WHERE mac_idx = '348954'  



========================2023-10-11 23:09:22======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-OSHBG9S 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0D271C2A360CDBEA 
sCDKey = 343408108095 
sName = DESKTOP-OSHBG9S 
========================2023-10-11 23:09: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 = '343408108095' 
			AND r.app_code = '046'
			AND r.app_block = 0 



========================2023-10-11 23:10:12======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-OSHBG9S 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0D271C2A360CDBEA 
sCDKey = 343408108095 
sName = 5775-°æÅ 
========================2023-10-11 23:10:12======================== 
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 = '343408108095' 
			AND r.app_code = '046'
			AND r.app_block = 0