

========================2024-12-23 09:48:09======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = MANGHO-SUB1 
parm_os_type = 110 
parm_screen_w = 1440 
parm_screen_h = 900 
parm_user_mac = CC28AA05B338BC2409AD 
sCDKey = 999998270083 
sName = MANGHO-SUB1 
========================2024-12-23 09:48:09======================== 
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 = '999998270083' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2024-12-23 09:48:09======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mang7718'  
========================2024-12-23 09:48:09======================== 
SELECT idx FROM macs WHERE mac_addr = 'CC28AA05B338BC2409AD' AND app_code = '046' 
========================2024-12-23 09:48:09======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '415059' 
========================2024-12-23 09:48:09======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '415059' 
========================2024-12-23 09:48:09======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '415059', 'CC28AA05B338BC2409AD', '046', 'MANGHO-SUB1', '110', '1440', '900', 'mang7718', '(주)맹호기공[김경록]', '999998270083'  ) 


========================2024-12-23 09:54:20======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = 맹호 
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 74563C7E1CCD6219ADF7 
sCDKey = 999998270083 
sName = 맹호 
========================2024-12-23 09:54: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 = '999998270083' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2024-12-23 09:54:20======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mang7718'  
========================2024-12-23 09:54:20======================== 
SELECT idx FROM macs WHERE mac_addr = '74563C7E1CCD6219ADF7' AND app_code = '046' 
========================2024-12-23 09:54:20======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '398763' 
========================2024-12-23 09:54:20======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '398763' 
========================2024-12-23 09:54: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	 ( '398763', '74563C7E1CCD6219ADF7', '046', '맹호', '110', '1600', '900', 'mang7718', '(주)맹호기공[김경록]', '999998270083'  ) 


========================2024-12-23 10:54:16======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = 5C68 
parm_os_type = 109 
parm_screen_w = 2560 
parm_screen_h = 1440 
parm_user_mac = 001C423E5DC8FFFFFFFF 
sCDKey = 362230354924 
sName = 5C68 
========================2024-12-23 10:54:16======================== 
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 = '362230354924' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2024-12-23 15:18:45======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-D9LNDPC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 4CEDFB77EE23A20020EF 
sCDKey = 129660239588 
sName = DESKTOP-D9LNDPC 
========================2024-12-23 15:18:45======================== 
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 = '129660239588' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-12-23 15:18:45======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'han54'  
========================2024-12-23 15:18:45======================== 
SELECT idx FROM macs WHERE mac_addr = '4CEDFB77EE23A20020EF' AND app_code = '039' 
========================2024-12-23 15:18:45======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '415073' 
========================2024-12-23 15:18:45======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '415073' 
========================2024-12-23 15:18:45======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '415073', '4CEDFB77EE23A20020EF', '039', 'DESKTOP-D9LNDPC', '110', '1920', '1080', 'han54', '청농작업복[한정현]', '129660239588'  )