

========================2022-04-26 09:05:34======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-3858FI9 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 0433C298918FCC427F47 
sCDKey = 035796380749 
sName = DESKTOP-3858FI9 
========================2022-04-26 09:05: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 = '035796380749' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-26 09:05:34======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'hisync18'  
========================2022-04-26 09:05:34======================== 
SELECT idx FROM macs WHERE mac_addr = '0433C298918FCC427F47' AND app_code = '039' 
========================2022-04-26 09:05:34======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339572' 
========================2022-04-26 09:05:34======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '339572' 
========================2022-04-26 09:05:34======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '339572', '0433C298918FCC427F47', '039', 'DESKTOP-3858FI9', '110', '1536', '864', 'hisync18', '(주)송인글로텍[김경현]', '035796380749'  ) 


========================2022-04-26 09:17:38======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = BOOK-P8CCG5RL9P 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 70A8D31512794A54D730 
sCDKey = 755853048887 
sName = BOOK-P8CCG5RL9P 
========================2022-04-26 09:17:38======================== 
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 = '755853048887' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-26 09:17:38======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mreakeu'  
========================2022-04-26 09:17:38======================== 
SELECT idx FROM macs WHERE mac_addr = '70A8D31512794A54D730' AND app_code = '039' 
========================2022-04-26 09:17:38======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365782' 
========================2022-04-26 09:17:38======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '365782' 
========================2022-04-26 09:17:38======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '365782', '70A8D31512794A54D730', '039', 'BOOK-P8CCG5RL9P', '110', '1536', '864', 'mreakeu', '용접박사[조만기]', '755853048887'  ) 


========================2022-04-26 09:39:35======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = 고성훈 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50EBF69AC497DEABDB72 
sCDKey = 886831559904 
sName = 고성훈 
========================2022-04-26 09:39:35======================== 
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 = '886831559904' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-26 09:39:35======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ksh0324a'  
========================2022-04-26 09:39:35======================== 
SELECT idx FROM macs WHERE mac_addr = '50EBF69AC497DEABDB72' AND app_code = '039' 
========================2022-04-26 09:39:35======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365810' 
========================2022-04-26 09:39:35======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '365810' 
========================2022-04-26 09:39:35======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '365810', '50EBF69AC497DEABDB72', '039', '고성훈', '110', '1920', '1080', 'ksh0324a', '성지테크[고성훈]', '886831559904'  ) 


========================2022-04-26 10:31:26======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-FPQS69J 
parm_os_type = 110 
parm_screen_w = 2560 
parm_screen_h = 1440 
parm_user_mac = 309C23DEBF71605997A2 
sCDKey = 405845474891 
sName = DESKTOP-FPQS69J 
========================2022-04-26 10:31: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 = '405845474891' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2022-04-26 10:32:29======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-FPQS69J 
parm_os_type = 110 
parm_screen_w = 2560 
parm_screen_h = 1440 
parm_user_mac = 309C23DEBF71605997A2 
sCDKey = 405845474891 
sName = kocomled 
========================2022-04-26 10:32: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 = '405845474891' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2022-04-26 11:07:42======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = SS1 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50B7C3AAEAEC866A305B 
sCDKey = 088904116579 
sName = SS1 
========================2022-04-26 11:07:42======================== 
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 = '088904116579' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-26 11:07:42======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'mllm2000'  
========================2022-04-26 11:07:42======================== 
SELECT idx FROM macs WHERE mac_addr = '50B7C3AAEAEC866A305B' AND app_code = '039' 
========================2022-04-26 11:07:42======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '138180' 
========================2022-04-26 11:07:42======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '138180' 
========================2022-04-26 11:07:42======================== 
UPDATE mac_detail SET  pc_name = 'SS1', os_type = '110', user_id = 'mllm2000', user_name = '쌀로만제과[조해순]',
												 screen_w = '1920', screen_h = '1080', cdkey = '088904116579'
								  WHERE mac_idx = '138180'  


========================2022-04-26 13:51:23======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 50EBF6B11A86F875A670 
sCDKey = 892592379421 
sName = DESKTOP 
========================2022-04-26 13:51:23======================== 
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 = '892592379421' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-26 13:51:23======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'gosen2012'  
========================2022-04-26 13:51:23======================== 
SELECT idx FROM macs WHERE mac_addr = '50EBF6B11A86F875A670' AND app_code = '039' 
========================2022-04-26 13:51:23======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365483' 
========================2022-04-26 13:51:23======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '365483' 
========================2022-04-26 13:51:23======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '365483', '50EBF6B11A86F875A670', '039', 'DESKTOP', '110', '1920', '1080', 'gosen2012', '고센산업개발(주)[김은자]', '892592379421'  ) 


========================2022-04-26 15:53:02======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-TNUJ8HM 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A8A159AF4B78DCBCF3A0 
sCDKey = 873547340169 
sName = TNUJ 
========================2022-04-26 15:53:02======================== 
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 = '873547340169' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-26 15:53:02======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ujinled'  
========================2022-04-26 15:53:02======================== 
SELECT idx FROM macs WHERE mac_addr = 'A8A159AF4B78DCBCF3A0' AND app_code = '039' 
========================2022-04-26 15:53:02======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365839' 
========================2022-04-26 15:53:02======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '365839' 
========================2022-04-26 15:53:02======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '365839', 'A8A159AF4B78DCBCF3A0', '039', 'TNUJ', '110', '1920', '1080', 'ujinled', '(주)유진엘이디[남선영]', '873547340169'  ) 


========================2022-04-26 17:25:59======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-4VOHEJM 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = B42E99F70E23749834A0 
sCDKey = 467634474095 
sName = DESKTOP-4VOHEJM 
========================2022-04-26 17:25: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 = '467634474095' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2022-04-26 17:25:59======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'park19570106'  
========================2022-04-26 17:25:59======================== 
SELECT idx FROM macs WHERE mac_addr = 'B42E99F70E23749834A0' AND app_code = '039' 
========================2022-04-26 17:25:59======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365762' 
========================2022-04-26 17:25:59======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '365762' 
========================2022-04-26 17:25:59======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '365762', 'B42E99F70E23749834A0', '039', 'DESKTOP-4VOHEJM', '110', '1680', '1050', 'park19570106', '박제득부동산[박제득]', '467634474095'  )