

========================2020-07-13 10:14:01======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = JK30 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 8C89A5E7D09F9CD98A17 
sCDKey = 488679380965 
sName = JK30 
========================2020-07-13 10:14: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 = '488679380965' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-07-13 10:14:01======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ksd15577'  
========================2020-07-13 10:14:01======================== 
SELECT idx FROM macs WHERE mac_addr = '8C89A5E7D09F9CD98A17' AND app_code = '039' 
========================2020-07-13 10:14:01======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321682' 
========================2020-07-13 10:14:01======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '321682' 
========================2020-07-13 10:14: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	 ( '321682', '8C89A5E7D09F9CD98A17', '039', 'JK30', '110', '1920', '1080', 'ksd15577', '동진안전공구[김인서]', '488679380965'  ) 


========================2020-07-13 11:54:16======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-T1UCVLC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 902B346C9F87DA168E5F 
sCDKey = 449570970624 
sName = DESKTOP-T1UCVLC 
========================2020-07-13 11: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 = '449570970624' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2020-07-13 11:54:16======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'sinsin00'  
========================2020-07-13 11:54:16======================== 
SELECT idx FROM macs WHERE mac_addr = '902B346C9F87DA168E5F' AND app_code = '046' 
========================2020-07-13 11:54:16======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235461' 
========================2020-07-13 11:54:16======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '235461' 
========================2020-07-13 11:54:16======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-T1UCVLC', os_type = '110', user_id = 'sinsin00', user_name = '신신낚시유성점[민홍기]',
												 screen_w = '1920', screen_h = '1080', cdkey = '449570970624'
								  WHERE mac_idx = '235461'  


========================2020-07-13 12:13:08======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name =  
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 74D4353AD1042E448871 
sCDKey = 950239637620 
sName = 한양건재-조달호 
========================2020-07-13 12:13:08======================== 
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 = '950239637620' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2020-07-13 12:13:08======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kkj8097'  
========================2020-07-13 12:13:08======================== 
SELECT idx FROM macs WHERE mac_addr = '74D4353AD1042E448871' AND app_code = '046' 
========================2020-07-13 12:13:08======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321697' 
========================2020-07-13 12:13:08======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '321697' 
========================2020-07-13 12:13:08======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '321697', '74D4353AD1042E448871', '046', '한양건재-조달호', '110', '1024', '768', 'kkj8097', '(주)한양건재[김기준]', '950239637620'  ) 


========================2020-07-13 13:34:39======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-L4LLJD1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6F6D89116 
sCDKey = 204467956951 
sName = DESKTOP-L4LLJD1 
========================2020-07-13 13:34: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 13:34:43======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-L4LLJD1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6F6D89116 
sCDKey = 204467956951 
sName = DESKTOP-L4LLJD1 
========================2020-07-13 13:34:43======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 13:34:46======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-L4LLJD1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6F6D89116 
sCDKey = 204467956951 
sName = DESKTOP-L4LLJD1 
========================2020-07-13 13:34:46======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 13:38:04======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-L4LLJD1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6F6D89116 
sCDKey = 204467956951 
sName = DESKTOP-L4LLJD1 
========================2020-07-13 13:38: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 13:38:18======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-L4LLJD1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6F6D89116 
sCDKey = 204467956951 
sName = aadmin 
========================2020-07-13 13:38:18======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 13:40:29======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-L4LLJD1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6F6D89116 
sCDKey = 204467956951 
sName = DESKTOP-L4LLJD1 
========================2020-07-13 13:40: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2020-07-13 13:40:29======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kdsoon0402'  
========================2020-07-13 13:40:29======================== 
SELECT idx FROM macs WHERE mac_addr = '94C691FA00D6F6D89116' AND app_code = '050' 
========================2020-07-13 13:40:29======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321710' 
========================2020-07-13 13:40:29======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '321710' 
========================2020-07-13 13:40: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	 ( '321710', '94C691FA00D6F6D89116', '050', 'DESKTOP-L4LLJD1', '109', '1920', '1080', 'kdsoon0402', '대전평생교육진흥원[대전평생교육진흥원]', '204467956951'  ) 


========================2020-07-13 13:40:32======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-L4LLJD1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6F6D89116 
sCDKey = 204467956951 
sName = DESKTOP-L4LLJD1 
========================2020-07-13 13:40: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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 13:44:27======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-L4LLJD1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 94C691FA00D6F6D89116 
sCDKey = 204467956951 
sName = DESKTOP-L4LLJD1 
========================2020-07-13 13:44:27======================== 
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 = '204467956951' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2020-07-13 13:44:27======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kdsoon0402'  
========================2020-07-13 13:44:27======================== 
SELECT idx FROM macs WHERE mac_addr = '94C691FA00D6F6D89116' AND app_code = '050' 
========================2020-07-13 13:44:27======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321710' 
========================2020-07-13 13:44:27======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '321710' 
========================2020-07-13 13:44:27======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-L4LLJD1', os_type = '109', user_id = 'kdsoon0402', user_name = '대전평생교육진흥원[대전평생교육진흥원]',
												 screen_w = '1920', screen_h = '1080', cdkey = '204467956951'
								  WHERE mac_idx = '321710'  


========================2020-07-13 14:13:04======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-1EAJV89 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 10E7C64C89158AE0A131 
sCDKey = D0509943BAB6 
sName = DESKTOP-1EAJV89 
========================2020-07-13 14:13: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 = 'D0509943BAB6' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 14:13:37======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-1EAJV89 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 10E7C64C89158AE0A131 
sCDKey = 959237939642 
sName = DESKTOP-1EAJV89 
========================2020-07-13 14:13: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 = '959237939642' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 14:14:12======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-1EAJV89 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 10E7C64C89158AE0A131 
sCDKey = 959237939642 
sName = 대전 
========================2020-07-13 14: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 = '959237939642' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-07-13 14:14:21======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-1EAJV89 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 10E7C64C89158AE0A131 
sCDKey = D0509943BAB6 
sName = 대전 
========================2020-07-13 14:14:21======================== 
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 = 'D0509943BAB6' 
			AND r.app_code = '050'
			AND r.app_block = 0