

========================2020-06-15 10:20:43======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = DESKTOP-S6O7D2L 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C2D94A48A48EA750 
sCDKey = 429712037749 
sName = DESKTOP-S6O7D2L 
========================2020-06-15 10:20: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 = '429712037749' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2020-06-15 10:20:43======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'dyetec'  
========================2020-06-15 10:20:43======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C2D94A48A48EA750' AND app_code = '051' 
========================2020-06-15 10:20:43======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319721' 
========================2020-06-15 10:20:43======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '319721' 
========================2020-06-15 10:20:43======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '319721', '7085C2D94A48A48EA750', '051', 'DESKTOP-S6O7D2L', '109', '1920', '1080', 'dyetec', 'DYETEC연구원[조석진]', '429712037749'  ) 


========================2020-06-15 11:25:57======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-DM3OD4U 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C2295083BEB48AE8 
sCDKey = 300171682637 
sName = DESKTOP-DM3OD4U 
========================2020-06-15 11:25:57======================== 
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 = '300171682637' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2020-06-15 11:26:08======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-DM3OD4U 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 7085C2295083BEB48AE8 
sCDKey = 300171682637 
sName = DESKTOP-DM3OD4U 
========================2020-06-15 11:26: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 = '300171682637' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2020-06-15 13:30:12======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = WIN10_1909 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1200 
parm_user_mac = BC5FF4F207B76400BDB6 
sCDKey = 110772231677 
sName = WIN10_1909 
========================2020-06-15 13:30: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 = '110772231677' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-06-15 13:30:12======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ms7061'  
========================2020-06-15 13:30:12======================== 
SELECT idx FROM macs WHERE mac_addr = 'BC5FF4F207B76400BDB6' AND app_code = '039' 
========================2020-06-15 13:30:12======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319748' 
========================2020-06-15 13:30:12======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '319748' 
========================2020-06-15 13:30:12======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '319748', 'BC5FF4F207B76400BDB6', '039', 'WIN10_1909', '110', '1920', '1200', 'ms7061', '마샬전자음향[김진경]', '110772231677'  ) 


========================2020-06-15 14:17:46======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LAPTOP-BLS69EEE 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 84C5A64637E62617377A 
sCDKey = 395870147363 
sName = LAPTOP-BLS69EEE 
========================2020-06-15 14:17: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 = '395870147363' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-06-15 14:17:46======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'a01048791163'  
========================2020-06-15 14:17:46======================== 
SELECT idx FROM macs WHERE mac_addr = '84C5A64637E62617377A' AND app_code = '039' 
========================2020-06-15 14:17:46======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318275' 
========================2020-06-15 14:17:46======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '318275' 
========================2020-06-15 14:17:46======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '318275', '84C5A64637E62617377A', '039', 'LAPTOP-BLS69EEE', '110', '1536', '864', 'a01048791163', '29번중도매인[당승진]', '395870147363'  ) 


========================2020-06-15 15:14:05======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-VBRK6CF 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = A01D48F97BAC12419632 
sCDKey = 587810805864 
sName = DESKTOP-VBRK6CF 
========================2020-06-15 15:14: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 = '587810805864' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-06-15 15:14:05======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'withusptns'  
========================2020-06-15 15:14:05======================== 
SELECT idx FROM macs WHERE mac_addr = 'A01D48F97BAC12419632' AND app_code = '039' 
========================2020-06-15 15:14:05======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319756' 
========================2020-06-15 15:14:05======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '319756' 
========================2020-06-15 15:14:05======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '319756', 'A01D48F97BAC12419632', '039', 'DESKTOP-VBRK6CF', '110', '1536', '864', 'withusptns', '위더스파트너스주식회사[노현국]', '587810805864'  ) 


========================2020-06-15 15:14:36======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-VBRK6CF 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = A01D48F97BAC12419632 
sCDKey = 587810805864 
sName = DESKTOP-VBRK6CF 
========================2020-06-15 15:14:36======================== 
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 = '587810805864' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-06-15 15:29:00======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DALLAITI 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B88687D8C89074258B30 
sCDKey = 892232246788 
sName = DALLAITI 
========================2020-06-15 15:29:00======================== 
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 = '892232246788' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2020-06-15 15:29:00======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kumnam'  
========================2020-06-15 15:29:00======================== 
SELECT idx FROM macs WHERE mac_addr = 'B88687D8C89074258B30' AND app_code = '046' 
========================2020-06-15 15:29:00======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '230508' 
========================2020-06-15 15:29:00======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '230508' 
========================2020-06-15 15:29:00======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '230508', 'B88687D8C89074258B30', '046', 'DALLAITI', '110', '1920', '1080', 'kumnam', '(주)금남[한진용]', '892232246788'  ) 


========================2020-06-15 15:32:50======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KCTECH-1 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A8A1590D7036E06AE10E 
sCDKey = 014062314734 
sName = KCTECH-1 
========================2020-06-15 15:32:50======================== 
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 = '014062314734' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-06-15 15:32:50======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kctech25'  
========================2020-06-15 15:32:50======================== 
SELECT idx FROM macs WHERE mac_addr = 'A8A1590D7036E06AE10E' AND app_code = '039' 
========================2020-06-15 15:32:50======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319758' 
========================2020-06-15 15:32:50======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '319758' 
========================2020-06-15 15:32:50======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '319758', 'A8A1590D7036E06AE10E', '039', 'KCTECH-1', '110', '1920', '1080', 'kctech25', '케이씨테크[이영아]', '014062314734'  ) 


========================2020-06-15 16:57:14======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-POVGE87 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 2CF05D28E01AB8B2B16C 
sCDKey = 602999716586 
sName = DESKTOP-POVGE87 
========================2020-06-15 16:57:14======================== 
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 = '602999716586' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2020-06-15 16:57:14======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cjo0505'  
========================2020-06-15 16:57:14======================== 
SELECT idx FROM macs WHERE mac_addr = '2CF05D28E01AB8B2B16C' AND app_code = '046' 
========================2020-06-15 16:57:14======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319276' 
========================2020-06-15 16:57:14======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '319276' 
========================2020-06-15 16:57:14======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-POVGE87', os_type = '110', user_id = 'cjo0505', user_name = '우송건재[최종은]',
												 screen_w = '1920', screen_h = '1080', cdkey = '602999716586'
								  WHERE mac_idx = '319276'  


========================2020-06-15 17:40:49======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-RPFIS2T 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 2CF05D28E013562AFF15 
sCDKey = 602999716586 
sName = DESKTOP-RPFIS2T 
========================2020-06-15 17:40:49======================== 
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 = '602999716586' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2020-06-15 17:40:50======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cjo0505'  
========================2020-06-15 17:40:50======================== 
SELECT idx FROM macs WHERE mac_addr = '2CF05D28E013562AFF15' AND app_code = '046' 
========================2020-06-15 17:40:50======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319278' 
========================2020-06-15 17:40:50======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '319278' 
========================2020-06-15 17:40:50======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-RPFIS2T', os_type = '110', user_id = 'cjo0505', user_name = '우송건재[최종은]',
												 screen_w = '1920', screen_h = '1080', cdkey = '602999716586'
								  WHERE mac_idx = '319278'