

========================2018-01-17 09:08:43======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HYUNPC 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 2CD05A714554D02CA63D 
sCDKey = 774078853154 
sName = HYUNPC 
========================2018-01-17 09:08: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 = '774078853154' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-17 09:08:43======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ja2126'  
========================2018-01-17 09:08:43======================== 
SELECT idx FROM macs WHERE mac_addr = '2CD05A714554D02CA63D' AND app_code = '039' 
========================2018-01-17 09:08:43======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '127459' 
========================2018-01-17 09:08:43======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '127459' 
========================2018-01-17 09:08:43======================== 
UPDATE mac_detail SET  pc_name = 'HYUNPC', os_type = '110', user_id = 'ja2126', user_name = '형제상사[윤종태]',
												 screen_w = '1366', screen_h = '768', cdkey = '774078853154'
								  WHERE mac_idx = '127459'  


========================2018-01-17 09:11:12======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = PC1 
parm_os_type = 110 
parm_screen_w = 1280 
parm_screen_h = 1024 
parm_user_mac = FFFFFFFFFFFF30C03522 
sCDKey = 677747547493 
sName = PC1 
========================2018-01-17 09:11: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 = '677747547493' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-17 09:11:12======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'topic65'  
========================2018-01-17 09:11:12======================== 
SELECT idx FROM macs WHERE mac_addr = 'FFFFFFFFFFFF30C03522' AND app_code = '039' 
========================2018-01-17 09:11:12======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239557' 
========================2018-01-17 09:11:12======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '239557' 
========================2018-01-17 09:11: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	 ( '239557', 'FFFFFFFFFFFF30C03522', '039', 'PC1', '110', '1280', '1024', 'topic65', '육오수산[정태화]', '677747547493'  ) 


========================2018-01-17 09:43:42======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-3HBRMO6 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9883897F6AF9B0C90E50 
sCDKey = 962100806174 
sName = 문영주 
========================2018-01-17 09:43: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 = '962100806174' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-01-17 09:49:50======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-3HBRMO6 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9883897F6AF9B0C90E50 
sCDKey = 962100806174 
sName = DESKTOP-3HBRMO6 
========================2018-01-17 09:49: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 = '962100806174' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-01-17 09:52:11======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-3HBRMO6 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9883897F6AF9B0C90E50 
sCDKey = 962100806174 
sName = DESKTOP-3HBRMO6 
========================2018-01-17 09:52:11======================== 
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 = '962100806174' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-01-17 09:52:11======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'nfcf0071'  
========================2018-01-17 09:52:11======================== 
SELECT idx FROM macs WHERE mac_addr = '9883897F6AF9B0C90E50' AND app_code = '046' 
========================2018-01-17 09:52:11======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239570' 
========================2018-01-17 09:52:11======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '239570' 
========================2018-01-17 09:52:11======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '239570', '9883897F6AF9B0C90E50', '046', 'DESKTOP-3HBRMO6', '110', '1920', '1080', 'nfcf0071', '산리조합중앙회광주전남지역본부[최기열]', '962100806174'  ) 


========================2018-01-17 09:52:19======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KIMJIHU 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 606C66B4F1DB6A6414AA 
sCDKey = 211075783847 
sName = KIMJIHU 
========================2018-01-17 09:52:19======================== 
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 = '211075783847' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-17 09:52:19======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'wellbiz1'  
========================2018-01-17 09:52:19======================== 
SELECT idx FROM macs WHERE mac_addr = '606C66B4F1DB6A6414AA' AND app_code = '039' 
========================2018-01-17 09:52:19======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '190230' 
========================2018-01-17 09:52:19======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '190230' 
========================2018-01-17 09:52:19======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '190230', '606C66B4F1DB6A6414AA', '039', 'KIMJIHU', '110', '1920', '1080', 'wellbiz1', '성호물산[김종수]', '211075783847'  ) 


========================2018-01-17 09:52:26======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KIMJIHU 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 606C66B4F1DB6A6414AA 
sCDKey = 211075783847 
sName = KIMJIHU 
========================2018-01-17 09:52: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 = '211075783847' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-01-17 09:52:55======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = KIMJIHU 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 606C66B4F1DB6A6414AA 
sCDKey = 211075783847 
sName = KIMJIHU 
========================2018-01-17 09:52:55======================== 
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 = '211075783847' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-01-17 10:14:52======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-9CFRMKR 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F44D30E46FDF9A0AC2E3 
sCDKey = 412794676239 
sName = DESKTOP-9CFRMKR 
========================2018-01-17 10:14:52======================== 
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 = '412794676239' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-17 10:14:52======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'industry2'  
========================2018-01-17 10:14:52======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30E46FDF9A0AC2E3' AND app_code = '039' 
========================2018-01-17 10:14:52======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239577' 
========================2018-01-17 10:14:52======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '239577' 
========================2018-01-17 10:14:52======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '239577', 'F44D30E46FDF9A0AC2E3', '039', 'DESKTOP-9CFRMKR', '110', '1920', '1080', 'industry2', '(주)한울[이공엽]', '412794676239'  ) 


========================2018-01-17 11:03:11======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = GAYA-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 24F5AAE388BFF29D3732 
sCDKey = 427014604950 
sName = GAYA-PC 
========================2018-01-17 11:03:11======================== 
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 = '427014604950' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-17 11:03:11======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ma0163'  
========================2018-01-17 11:03:11======================== 
SELECT idx FROM macs WHERE mac_addr = '24F5AAE388BFF29D3732' AND app_code = '039' 
========================2018-01-17 11:03:11======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238424' 
========================2018-01-17 11:03:11======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '238424' 
========================2018-01-17 11:03:11======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '238424', '24F5AAE388BFF29D3732', '039', 'GAYA-PC', '90', '1920', '1080', 'ma0163', '가야인테리어[문성수]', '427014604950'  ) 


========================2018-01-17 12:25:04======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-IKAABPO 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = A402B99DC98EF6EA77E0 
sCDKey = 921252470168 
sName = DESKTOP-IKAABPO 
========================2018-01-17 12:25: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 = '921252470168' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-01-17 12:25:04======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cherhomes'  
========================2018-01-17 12:25:04======================== 
SELECT idx FROM macs WHERE mac_addr = 'A402B99DC98EF6EA77E0' AND app_code = '046' 
========================2018-01-17 12:25:04======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '210244' 
========================2018-01-17 12:25:04======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '210244' 
========================2018-01-17 12:25:04======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-IKAABPO', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]',
												 screen_w = '1536', screen_h = '864', cdkey = '921252470168'
								  WHERE mac_idx = '210244'  


========================2018-01-17 12:37:10======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = HOMESPOS 
parm_os_type = 110 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 50AF7325BFF3A4AF7DFD 
sCDKey = 921252470168 
sName = HOMESPOS 
========================2018-01-17 12:37:10======================== 
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 = '921252470168' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-01-17 12:37:10======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cherhomes'  
========================2018-01-17 12:37:10======================== 
SELECT idx FROM macs WHERE mac_addr = '50AF7325BFF3A4AF7DFD' AND app_code = '046' 
========================2018-01-17 12:37:10======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236522' 
========================2018-01-17 12:37:10======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '236522' 
========================2018-01-17 12:37:10======================== 
UPDATE mac_detail SET  pc_name = 'HOMESPOS', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]',
												 screen_w = '1024', screen_h = '768', cdkey = '921252470168'
								  WHERE mac_idx = '236522'  


========================2018-01-17 13:11:34======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = WIN7-PC 
parm_os_type = 90 
parm_screen_w = 1360 
parm_screen_h = 768 
parm_user_mac = 1078D2975C9FCD5B6EB 
sCDKey = 491247338384 
sName = WIN7-PC 
========================2018-01-17 13:11: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 = '491247338384' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-17 13:11:34======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'wschoe1'  
========================2018-01-17 13:11:34======================== 
SELECT idx FROM macs WHERE mac_addr = '1078D2975C9FCD5B6EB' AND app_code = '039' 
========================2018-01-17 13:11:34======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239594' 
========================2018-01-17 13:11:34======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '239594' 
========================2018-01-17 13:11: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	 ( '239594', '1078D2975C9FCD5B6EB', '039', 'WIN7-PC', '90', '1360', '768', 'wschoe1', '맘푸드시스템[최원상]', '491247338384'  ) 


========================2018-01-17 15:38:35======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = ADMIN-PC 
parm_os_type = 90 
parm_screen_w = 1080 
parm_screen_h = 1920 
parm_user_mac = 7085C23AE263B1A5D36D 
sCDKey = 606997096553 
sName = ADMIN-PC 
========================2018-01-17 15:38: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 = '606997096553' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-01-17 15:38:35======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'pl7204'  
========================2018-01-17 15:38:35======================== 
SELECT idx FROM macs WHERE mac_addr = '7085C23AE263B1A5D36D' AND app_code = '039' 
========================2018-01-17 15:38:35======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238377' 
========================2018-01-17 15:38:35======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '238377' 
========================2018-01-17 15:38: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	 ( '238377', '7085C23AE263B1A5D36D', '039', 'ADMIN-PC', '90', '1080', '1920', 'pl7204', '주식회사피엘[정필]', '606997096553'  ) 


========================2018-01-17 15:52:17======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-IKAABPO 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = A402B99DC98EF6EA77E0 
sCDKey = 921252470168 
sName = DESKTOP-IKAABPO 
========================2018-01-17 15:52: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 = '921252470168' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-01-17 15:52:17======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'cherhomes'  
========================2018-01-17 15:52:17======================== 
SELECT idx FROM macs WHERE mac_addr = 'A402B99DC98EF6EA77E0' AND app_code = '046' 
========================2018-01-17 15:52:17======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '210244' 
========================2018-01-17 15:52:17======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '210244' 
========================2018-01-17 15:52:17======================== 
UPDATE mac_detail SET  pc_name = 'DESKTOP-IKAABPO', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]',
												 screen_w = '1536', screen_h = '864', cdkey = '921252470168'
								  WHERE mac_idx = '210244'