

========================2019-08-28 09:02:36======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9A1120524153A829457 
sCDKey = 683156263623 
sName = HBDS-02 
========================2019-08-28 09:02: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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 09:02:36======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 09:02:36======================== 
SELECT idx FROM macs WHERE mac_addr = '9A1120524153A829457' AND app_code = '039' 
========================2019-08-28 09:02:36======================== 
값이 없을 경우 


========================2019-08-28 09:02:59======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9A1120524153A829457 
sCDKey = 683156263623 
sName = HBDS-02 
========================2019-08-28 09:02: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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 09:02:59======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 09:02:59======================== 
SELECT idx FROM macs WHERE mac_addr = '9A1120524153A829457' AND app_code = '039' 
========================2019-08-28 09:02:59======================== 
값이 없을 경우 


========================2019-08-28 09:03:40======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9A1120524153A829457 
sCDKey = 683156263623 
sName = HBDS-02 
========================2019-08-28 09:03:40======================== 
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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 09:03:40======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 09:03:40======================== 
SELECT idx FROM macs WHERE mac_addr = '9A1120524153A829457' AND app_code = '039' 
========================2019-08-28 09:03:40======================== 
값이 없을 경우 


========================2019-08-28 09:05:08======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9A1120524153A829457 
sCDKey = 683156263623 
sName = HBDS-02 
========================2019-08-28 09:05: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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 09:05:08======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 09:05:08======================== 
SELECT idx FROM macs WHERE mac_addr = '9A1120524153A829457' AND app_code = '039' 
========================2019-08-28 09:05:08======================== 
값이 없을 경우 


========================2019-08-28 09:05:39======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9A1120524153A829457 
sCDKey = 683156263623 
sName = HBDS-02 
========================2019-08-28 09:05: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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 09:05:39======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 09:05:39======================== 
SELECT idx FROM macs WHERE mac_addr = '9A1120524153A829457' AND app_code = '039' 
========================2019-08-28 09:05:39======================== 
값이 없을 경우 


========================2019-08-28 09:05:44======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9A1120524153A829457 
sCDKey = 683156263623 
sName = HBDS-02 
========================2019-08-28 09:05:44======================== 
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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 09:05:44======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 09:05:44======================== 
SELECT idx FROM macs WHERE mac_addr = '9A1120524153A829457' AND app_code = '039' 
========================2019-08-28 09:05:44======================== 
값이 없을 경우 


========================2019-08-28 09:06:00======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = ADMINISTRATOR 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = B8975AF53333942362F3 
sCDKey = 591867603635 
sName = ADMINISTRATOR 
========================2019-08-28 09:06: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 = '591867603635' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-08-28 09:06:00======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'n1352244271'  
========================2019-08-28 09:06:00======================== 
SELECT idx FROM macs WHERE mac_addr = 'B8975AF53333942362F3' AND app_code = '046' 
========================2019-08-28 09:06:00======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '224796' 
========================2019-08-28 09:06:00======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '224796' 
========================2019-08-28 09:06:00======================== 
UPDATE mac_detail SET  pc_name = 'ADMINISTRATOR', os_type = '90', user_id = 'n1352244271', user_name = '신원종합주방[임상혁]',
												 screen_w = '1024', screen_h = '768', cdkey = '591867603635'
								  WHERE mac_idx = '224796'  


========================2019-08-28 09:07:54======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9A1120524153A829457 
sCDKey = 683156263623 
sName = HBDS-02 
========================2019-08-28 09:07:54======================== 
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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 09:07:54======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 09:07:54======================== 
SELECT idx FROM macs WHERE mac_addr = '9A1120524153A829457' AND app_code = '039' 
========================2019-08-28 09:07:54======================== 
값이 없을 경우 


========================2019-08-28 09:10:21======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 9A1120524153A829457 
sCDKey = 683156263623 
sName = HBDS-02 
========================2019-08-28 09:10: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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 09:10:21======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 09:10:21======================== 
SELECT idx FROM macs WHERE mac_addr = '9A1120524153A829457' AND app_code = '039' 
========================2019-08-28 09:10:21======================== 
값이 없을 경우 


========================2019-08-28 09:36:05======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = POS2 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E9951C4F0265CFF06 
sCDKey = 270965864323 
sName = POS2 
========================2019-08-28 09:36: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 = '270965864323' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2019-08-28 09:36:10======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = POS2 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E9951C4F0265CFF06 
sCDKey = 270965864323 
sName = POS2 
========================2019-08-28 09:36: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 = '270965864323' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2019-08-28 10:00:35======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = POS2 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E9951C4F0265CFF06 
sCDKey = 270965864323 
sName = POS2 
========================2019-08-28 10:00: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 = '270965864323' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2019-08-28 10:00:35======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kyr0909'  
========================2019-08-28 10:00:35======================== 
SELECT idx FROM macs WHERE mac_addr = 'B42E9951C4F0265CFF06' AND app_code = '046' 
========================2019-08-28 10:00:35======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294153' 
========================2019-08-28 10:00:35======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '294153' 
========================2019-08-28 10:00: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	 ( '294153', 'B42E9951C4F0265CFF06', '046', 'POS2', '90', '1920', '1080', 'kyr0909', '동양종합식품[김영록]', '270965864323'  ) 


========================2019-08-28 10:00:40======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = POS2 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E9951C4F0265CFF06 
sCDKey = 270965864323 
sName = POS2 
========================2019-08-28 10:00:40======================== 
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 = '270965864323' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2019-08-28 11:19:45======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-03 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1200 
parm_user_mac = 50B7C3A4C46424641C48 
sCDKey = 683156263623 
sName = HBDS-03 
========================2019-08-28 11:19:45======================== 
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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2019-08-28 11:20:07======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-03 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1200 
parm_user_mac = 50B7C3A4C46424641C48 
sCDKey = 683156263623 
sName = HBDS-03 
========================2019-08-28 11:20:07======================== 
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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 11:20:07======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 11:20:07======================== 
SELECT idx FROM macs WHERE mac_addr = '50B7C3A4C46424641C48' AND app_code = '039' 
========================2019-08-28 11:20:07======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '85443' 
========================2019-08-28 11:20:07======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '85443' 
========================2019-08-28 11:20:07======================== 
UPDATE mac_detail SET  pc_name = 'HBDS-03', os_type = '110', user_id = 'bangchun', user_name = '한반도[이진석]',
												 screen_w = '1920', screen_h = '1200', cdkey = '683156263623'
								  WHERE mac_idx = '85443'  


========================2019-08-28 11:22:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-05 
parm_os_type = 110 
parm_screen_w = 1536 
parm_screen_h = 864 
parm_user_mac = 6C2995857AF5E2543F23 
sCDKey = 683156263623 
sName = HBDS-05 
========================2019-08-28 11:22:30======================== 
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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 11:22:30======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 11:22:30======================== 
SELECT idx FROM macs WHERE mac_addr = '6C2995857AF5E2543F23' AND app_code = '039' 
========================2019-08-28 11:22:30======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '219390' 
========================2019-08-28 11:22:30======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '219390' 
========================2019-08-28 11:22:30======================== 
UPDATE mac_detail SET  pc_name = 'HBDS-05', os_type = '110', user_id = 'bangchun', user_name = '한반도[이진석]',
												 screen_w = '1536', screen_h = '864', cdkey = '683156263623'
								  WHERE mac_idx = '219390'  


========================2019-08-28 11:26:46======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-04 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 74E5F94706DF4F3F2DA 
sCDKey = 683156263623 
sName = HBDS-04 
========================2019-08-28 11:26: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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2019-08-28 11:26:46======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2019-08-28 11:26:46======================== 
SELECT idx FROM macs WHERE mac_addr = '74E5F94706DF4F3F2DA' AND app_code = '039' 
========================2019-08-28 11:26:46======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266265' 
========================2019-08-28 11:26:46======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '266265' 
========================2019-08-28 11:26:46======================== 
UPDATE mac_detail SET  pc_name = 'HBDS-04', os_type = '110', user_id = 'bangchun', user_name = '한반도[이진석]',
												 screen_w = '1920', screen_h = '1080', cdkey = '683156263623'
								  WHERE mac_idx = '266265'