

========================2020-10-22 11:20:13======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = ADMIN01 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 005056B64637C225990F 
sCDKey = 003401679376 
sName = ADMIN01 
========================2020-10-22 11:20:13======================== 
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 = '003401679376' 
			AND r.app_code = '051'
			AND r.app_block = 0 


========================2020-10-22 14:34:26======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-6LFC940 
parm_os_type = 110 
parm_screen_w = 2048 
parm_screen_h = 1152 
parm_user_mac = 989E6337692A2469FF7 
sCDKey = 767635709828 
sName = DESKTOP-6LFC940 
========================2020-10-22 14:34: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 = '767635709828' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-10-22 14:37:56======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-6LFC940 
parm_os_type = 110 
parm_screen_w = 2048 
parm_screen_h = 1152 
parm_user_mac = 989E6337692A2469FF7 
sCDKey = 767635709828 
sName = DESKTOP-6LFC940 
========================2020-10-22 14:37:56======================== 
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 = '767635709828' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-10-22 14:37:56======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'josc'  
========================2020-10-22 14:37:56======================== 
SELECT idx FROM macs WHERE mac_addr = '989E6337692A2469FF7' AND app_code = '039' 
========================2020-10-22 14:37:56======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '328530' 
========================2020-10-22 14:37:56======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '328530' 
========================2020-10-22 14:37:56======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '328530', '989E6337692A2469FF7', '039', 'DESKTOP-6LFC940', '110', '2048', '1152', 'josc', '세영통상[조상철]', '767635709828'  ) 


========================2020-10-22 16:17:04======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-A3DLE8K 
parm_os_type = 110 
parm_screen_w = 3440 
parm_screen_h = 1440 
parm_user_mac = 04D4C44D6D353CF92C0D 
sCDKey = 172998658701 
sName = 세광 
========================2020-10-22 16:17:04======================== 
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 = '172998658701' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-10-22 16:17:34======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-A3DLE8K 
parm_os_type = 110 
parm_screen_w = 3440 
parm_screen_h = 1440 
parm_user_mac = 04D4C44D6D353CF92C0D 
sCDKey = 172998658701 
sName = DESKTOP-A3DLE8K 
========================2020-10-22 16:17:34======================== 
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 = '172998658701' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-10-22 16:22:01======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-A3DLE8K 
parm_os_type = 110 
parm_screen_w = 3440 
parm_screen_h = 1440 
parm_user_mac = 04D4C44D6D353CF92C0D 
sCDKey = 172998658701 
sName = 세광 
========================2020-10-22 16:22:01======================== 
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 = '172998658701' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-10-22 16:22:01======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sekwang0316'  
========================2020-10-22 16:22:01======================== 
SELECT idx FROM macs WHERE mac_addr = '04D4C44D6D353CF92C0D' AND app_code = '039' 
========================2020-10-22 16:22:01======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '328549' 
========================2020-10-22 16:22:01======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '328549' 
========================2020-10-22 16:22:01======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '328549', '04D4C44D6D353CF92C0D', '039', '세광', '110', '3440', '1440', 'sekwang0316', '세광[문경남]', '172998658701'  ) 


========================2020-10-22 16:22:05======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-A3DLE8K 
parm_os_type = 110 
parm_screen_w = 3440 
parm_screen_h = 1440 
parm_user_mac = 04D4C44D6D353CF92C0D 
sCDKey = 172998658701 
sName = 세광 
========================2020-10-22 16:22: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 = '172998658701' 
			AND r.app_code = '039'
			AND r.app_block = 0