

========================2021-11-15 09:00:55======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-MN8AT67 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B8975A3786C15A2DE8EB 
sCDKey = 763571506375 
sName = DESKTOP-MN8AT67 
========================2021-11-15 09:00:55======================== 
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 = '763571506375' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2021-11-15 09:00:55======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'edenkim00'  
========================2021-11-15 09:00:55======================== 
SELECT idx FROM macs WHERE mac_addr = 'B8975A3786C15A2DE8EB' AND app_code = '046' 
========================2021-11-15 09:00:55======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '189977' 
========================2021-11-15 09:00:55======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '189977' 
========================2021-11-15 09:00:55======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-MN8AT67', os_type = '110', user_id = 'edenkim00', user_name = '서울유통[김영수]',
												 screen_w = '1920', screen_h = '1080', cdkey = '763571506375'
								  WHERE mac_idx = '189977'  


========================2021-11-15 09:05:20======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = 알파공구1-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0D55EE9AB4540C6C2E5 
sCDKey = 854361905453 
sName = 알파공구1-PC 
========================2021-11-15 09:05: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 = '854361905453' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2021-11-15 09:05:20======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'al660129'  
========================2021-11-15 09:05:20======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55EE9AB4540C6C2E5' AND app_code = '046' 
========================2021-11-15 09:05:20======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '354549' 
========================2021-11-15 09:05:20======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '354549' 
========================2021-11-15 09:05: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	 ( '354549', 'E0D55EE9AB4540C6C2E5', '046', '알파공구1-PC', '110', '1920', '1080', 'al660129', '(주)알파산업[민승홍]', '854361905453'  ) 


========================2021-11-15 09:05:23======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = 알파공구1-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0D55EE9AB4540C6C2E5 
sCDKey = 854361905453 
sName = 알파공구1-PC 
========================2021-11-15 09:05:23======================== 
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 = '854361905453' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2021-11-15 09:44:24======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-KHURQD6 
parm_os_type = 110 
parm_screen_w = 2560 
parm_screen_h = 1080 
parm_user_mac = 2CF05D0DEACDD4890142 
sCDKey = 526364460170 
sName = DESKTOP-KHURQD6 
========================2021-11-15 09:44: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 = '526364460170' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-11-15 09:44:24======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'namil3328'  
========================2021-11-15 09:44:24======================== 
SELECT idx FROM macs WHERE mac_addr = '2CF05D0DEACDD4890142' AND app_code = '039' 
========================2021-11-15 09:44:24======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '352778' 
========================2021-11-15 09:44:24======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '352778' 
========================2021-11-15 09:44:24======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '352778', '2CF05D0DEACDD4890142', '039', 'DESKTOP-KHURQD6', '110', '2560', '1080', 'namil3328', '남 일 공 업[백 남 일]', '526364460170'  ) 


========================2021-11-15 10:34:37======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-HE8J2V8 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 40167EAFD9FB64903387 
sCDKey = 854361905453 
sName = DESKTOP-HE8J2V8 
========================2021-11-15 10:34: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 = '854361905453' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2021-11-15 10:34:37======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'al660129'  
========================2021-11-15 10:34:37======================== 
SELECT idx FROM macs WHERE mac_addr = '40167EAFD9FB64903387' AND app_code = '046' 
========================2021-11-15 10:34:37======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282267' 
========================2021-11-15 10:34:37======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '282267' 
========================2021-11-15 10:34:37======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '282267', '40167EAFD9FB64903387', '046', 'DESKTOP-HE8J2V8', '110', '1920', '1080', 'al660129', '(주)알파산업[민승홍]', '854361905453'  ) 


========================2021-11-15 13:28:39======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = MC-CEO 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D85ED32B4B79724D37A8 
sCDKey = 519313570827 
sName = MC-CEO 
========================2021-11-15 13:28: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 = '519313570827' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-11-15 13:28:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'gldrhks'  
========================2021-11-15 13:28:40======================== 
SELECT idx FROM macs WHERE mac_addr = 'D85ED32B4B79724D37A8' AND app_code = '039' 
========================2021-11-15 13:28:40======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '354577' 
========================2021-11-15 13:28:40======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '354577' 
========================2021-11-15 13:28:40======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '354577', 'D85ED32B4B79724D37A8', '039', 'MC-CEO', '110', '1920', '1080', 'gldrhks', '만나화학[정형관]', '519313570827'  ) 


========================2021-11-15 16:29:29======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-QV75A3J 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 98838981451794DBA776 
sCDKey = 527769017292 
sName = DESKTOP-QV75A3J 
========================2021-11-15 16:29:29======================== 
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 = '527769017292' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-11-15 16:29:29======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'yytk77'  
========================2021-11-15 16:29:29======================== 
SELECT idx FROM macs WHERE mac_addr = '98838981451794DBA776' AND app_code = '039' 
========================2021-11-15 16:29:29======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '354601' 
========================2021-11-15 16:29:29======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '354601' 
========================2021-11-15 16:29:29======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '354601', '98838981451794DBA776', '039', 'DESKTOP-QV75A3J', '110', '1920', '1080', 'yytk77', '왕왕테크[진거부]', '527769017292'  ) 


========================2021-11-15 16:29:32======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-QV75A3J 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 98838981451794DBA776 
sCDKey = 527769017292 
sName = DESKTOP-QV75A3J 
========================2021-11-15 16:29: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 = '527769017292' 
			AND r.app_code = '039'
			AND r.app_block = 0