

========================2023-05-04 10:29:00======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-VRSQID9 
parm_os_type = 109 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 705DCCFF05A16EC43BFE 
sCDKey = 950428290210 
sName = DESKTOP-VRSQID9 
========================2023-05-04 10: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 = '950428290210' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2023-05-04 10:29:00======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jinsung1'  
========================2023-05-04 10:29:00======================== 
SELECT idx FROM macs WHERE mac_addr = '705DCCFF05A16EC43BFE' AND app_code = '050' 
========================2023-05-04 10:29:00======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387250' 
========================2023-05-04 10:29:00======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '387250' 
========================2023-05-04 10: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	 ( '387250', '705DCCFF05A16EC43BFE', '050', 'DESKTOP-VRSQID9', '109', '1536', '864', 'jinsung1', '진성이엔지[김형민]', '950428290210'  ) 


========================2023-05-04 10:35:49======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name =  
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F44D30B9B7BF8C01EB83 
sCDKey = 125106053341 
sName = 한동진 
========================2023-05-04 10:35: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 = '125106053341' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2023-05-04 10:35:49======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bestseller12'  
========================2023-05-04 10:35:49======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7BF8C01EB83' AND app_code = '050' 
========================2023-05-04 10:35:49======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '375682' 
========================2023-05-04 10:35:49======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '375682' 
========================2023-05-04 10:35:49======================== 
UPDATE mac_detail SET  pc_name = '한동진', os_type = '109', user_id = 'bestseller12', user_name = '엠제이소프트[엠제이소프트]',
												 screen_w = '1920', screen_h = '1080', cdkey = '125106053341'
								  WHERE mac_idx = '375682'  


========================2023-05-04 11:40:17======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-8D0CE5T 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 84144D92AEF578BF99D9 
sCDKey = 132244924361 
sName = DESKTOP-8D0CE5T 
========================2023-05-04 11:40:17======================== 
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 = '132244924361' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2023-05-04 11:40:17======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'oj1737'  
========================2023-05-04 11:40:17======================== 
SELECT idx FROM macs WHERE mac_addr = '84144D92AEF578BF99D9' AND app_code = '039' 
========================2023-05-04 11:40:17======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387287' 
========================2023-05-04 11:40:17======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '387287' 
========================2023-05-04 11:40:17======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '387287', '84144D92AEF578BF99D9', '039', 'DESKTOP-8D0CE5T', '110', '1536', '864', 'oj1737', '오정모터스[김연숙]', '132244924361'  ) 


========================2023-05-04 13:37:24======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-I4CIKFU 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 819 
parm_user_mac = 50E54916F958E4126E83 
sCDKey = 795072246964 
sName = DESKTOP-I4CIKFU 
========================2023-05-04 13:37: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 = '795072246964' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2023-05-04 13:37:24======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cjsxofkd00'  
========================2023-05-04 13:37:24======================== 
SELECT idx FROM macs WHERE mac_addr = '50E54916F958E4126E83' AND app_code = '046' 
========================2023-05-04 13:37:24======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387299' 
========================2023-05-04 13:37:24======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '387299' 
========================2023-05-04 13:37: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	 ( '387299', '50E54916F958E4126E83', '046', 'DESKTOP-I4CIKFU', '110', '1024', '819', 'cjsxofkd00', '대한물류[김지환]', '795072246964'  ) 


========================2023-05-04 13:47:01======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = LAPTOP-3T45H3M4 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = F8E4E37F0021D26A9782 
sCDKey = 321111538133 
sName = LAPTOP-3T45H3M4 
========================2023-05-04 13:47: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 = '321111538133' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2023-05-04 13:47:01======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'emz999'  
========================2023-05-04 13:47:01======================== 
SELECT idx FROM macs WHERE mac_addr = 'F8E4E37F0021D26A9782' AND app_code = '039' 
========================2023-05-04 13:47:01======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387298' 
========================2023-05-04 13:47:01======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '387298' 
========================2023-05-04 13:47: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	 ( '387298', 'F8E4E37F0021D26A9782', '039', 'LAPTOP-3T45H3M4', '110', '1536', '864', 'emz999', '최화정[최화정]', '321111538133'  ) 


========================2023-05-04 13:58:32======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-VRSQID9 
parm_os_type = 109 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 8CB0E92094386EC43BFE 
sCDKey = 950428290210 
sName = DESKTOP-VRSQID9 
========================2023-05-04 13:58: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 = '950428290210' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2023-05-04 13:58:32======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jinsung1'  
========================2023-05-04 13:58:32======================== 
SELECT idx FROM macs WHERE mac_addr = '8CB0E92094386EC43BFE' AND app_code = '050' 
========================2023-05-04 13:58:32======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387301' 
========================2023-05-04 13:58:32======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '387301' 
========================2023-05-04 13:58:32======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '387301', '8CB0E92094386EC43BFE', '050', 'DESKTOP-VRSQID9', '109', '1536', '864', 'jinsung1', '진성이엔지[김형민]', '950428290210'  ) 


========================2023-05-04 17:03:01======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC05 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 18C04DD9067112A481E4 
sCDKey = 109436997008 
sName = PC05 
========================2023-05-04 17:03: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 = '109436997008' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2023-05-04 17:03:01======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kimlee21'  
========================2023-05-04 17:03:01======================== 
SELECT idx FROM macs WHERE mac_addr = '18C04DD9067112A481E4' AND app_code = '039' 
========================2023-05-04 17:03:01======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387323' 
========================2023-05-04 17:03:01======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '387323' 
========================2023-05-04 17:03: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	 ( '387323', '18C04DD9067112A481E4', '039', 'PC05', '110', '1920', '1080', 'kimlee21', '(주)태봉산업개발[김남국]', '109436997008'  ) 


========================2023-05-04 17:04:59======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KTJ-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D8BBC119715890C13917 
sCDKey = 360412999829 
sName = KTJ-PC 
========================2023-05-04 17:04:59======================== 
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 = '360412999829' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2023-05-04 17:04:59======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ta1hun'  
========================2023-05-04 17:04:59======================== 
SELECT idx FROM macs WHERE mac_addr = 'D8BBC119715890C13917' AND app_code = '039' 
========================2023-05-04 17:04:59======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342771' 
========================2023-05-04 17:04:59======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '342771' 
========================2023-05-04 17:04:59======================== 
UPDATE mac_detail SET  pc_name = 'KTJ-PC', os_type = '110', user_id = 'ta1hun', user_name = '엠제이소프트[김태훈]',
												 screen_w = '1920', screen_h = '1080', cdkey = '360412999829'
								  WHERE mac_idx = '342771'