

========================2018-11-02 09:23:07======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = 거상6-PC 
parm_os_type = 90 
parm_screen_w = 1024 
parm_screen_h = 768 
parm_user_mac = 00241D7504FE986307D5 
sCDKey = 108094650671 
sName = 거상6-PC 
========================2018-11-02 09:23: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 = '108094650671' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-11-02 09:23:07======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'a09sang'  
========================2018-11-02 09:23:07======================== 
SELECT idx FROM macs WHERE mac_addr = '00241D7504FE986307D5' AND app_code = '046' 
========================2018-11-02 09:23:07======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '157720' 
========================2018-11-02 09:23:07======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '157720' 
========================2018-11-02 09:23:07======================== 
UPDATE mac_detail SET  pc_name = '거상6-PC', os_type = '90', user_id = 'a09sang', user_name = '(주)거상[장동익]',
												 screen_w = '1024', screen_h = '768', cdkey = '108094650671'
								  WHERE mac_idx = '157720'  


========================2018-11-02 09:29:17======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = 거상5-PC 
parm_os_type = 90 
parm_screen_w = 768 
parm_screen_h = 768 
parm_user_mac = 1C872C41524E986307D5 
sCDKey = 108094650671 
sName = 거상5-PC 
========================2018-11-02 09:29: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 = '108094650671' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-11-02 09:29:17======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'a09sang'  
========================2018-11-02 09:29:17======================== 
SELECT idx FROM macs WHERE mac_addr = '1C872C41524E986307D5' AND app_code = '046' 
========================2018-11-02 09:29:17======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '152578' 
========================2018-11-02 09:29:17======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '152578' 
========================2018-11-02 09:29:17======================== 
UPDATE mac_detail SET  pc_name = '거상5-PC', os_type = '90', user_id = 'a09sang', user_name = '(주)거상[장동익]',
												 screen_w = '768', screen_h = '768', cdkey = '108094650671'
								  WHERE mac_idx = '152578'  


========================2018-11-02 10:53:16======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-DSUMN3D 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = E0D55EC3B3DB82D150DA 
sCDKey = 571494353341 
sName = DESKTOP-DSUMN3D 
========================2018-11-02 10:53:16======================== 
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 = '571494353341' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-11-02 10:53:16======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'daechang2009'  
========================2018-11-02 10:53:16======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55EC3B3DB82D150DA' AND app_code = '039' 
========================2018-11-02 10:53:16======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266272' 
========================2018-11-02 10:53:16======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '266272' 
========================2018-11-02 10:53:16======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '266272', 'E0D55EC3B3DB82D150DA', '039', 'DESKTOP-DSUMN3D', '110', '1680', '1050', 'daechang2009', '대창열처리 [김재균]', '571494353341'  ) 


========================2018-11-02 11:21:41======================== 
noteurl_start 
parm_app_code = 045 
parm_pc_name = DESKTOP-RUEJK02 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 48BA4E61092E7C175E0C 
sCDKey = 932847330830 
sName = DESKTOP-RUEJK02 
========================2018-11-02 11:21:41======================== 
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 = '932847330830' 
			AND r.app_code = '045'
			AND r.app_block = 0 
========================2018-11-02 11:21:41======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'chamnara'  
========================2018-11-02 11:21:41======================== 
SELECT idx FROM macs WHERE mac_addr = '48BA4E61092E7C175E0C' AND app_code = '045' 
========================2018-11-02 11:21:41======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266350' 
========================2018-11-02 11:21:41======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '266350' 
========================2018-11-02 11:21:41======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '266350', '48BA4E61092E7C175E0C', '045', 'DESKTOP-RUEJK02', '110', '1920', '1080', 'chamnara', '(주)참나라 농업회사법인[임준상]', '932847330830'  ) 


========================2018-11-02 11:59:42======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-010 
parm_os_type = 64 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 20CF30DEA0C728BF4431 
sCDKey = 571494353341 
sName = USER-010 
========================2018-11-02 11:59: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 = '571494353341' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-11-02 11:59:42======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'daechang2009'  
========================2018-11-02 11:59:42======================== 
SELECT idx FROM macs WHERE mac_addr = '20CF30DEA0C728BF4431' AND app_code = '039' 
========================2018-11-02 11:59:42======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '144275' 
========================2018-11-02 11:59:42======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '144275' 
========================2018-11-02 11:59:42======================== 
UPDATE mac_detail SET  pc_name = 'USER-010', os_type = '64', user_id = 'daechang2009', user_name = '대창열처리 [김재균]',
												 screen_w = '1600', screen_h = '900', cdkey = '571494353341'
								  WHERE mac_idx = '144275'  


========================2018-11-02 12:00:03======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-010 
parm_os_type = 64 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 20CF30DEA0C728BF4431 
sCDKey = 571494353341 
sName = USER-010 
========================2018-11-02 12:00:03======================== 
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 = '571494353341' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-11-02 12:00:22======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-010 
parm_os_type = 64 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 20CF30DEA0C728BF4431 
sCDKey = 571494353341 
sName = USER-011 
========================2018-11-02 12:00:22======================== 
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 = '571494353341' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-11-02 12:00:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-010 
parm_os_type = 64 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 20CF30DEA0C728BF4431 
sCDKey = 571494353341 
sName = USER-010 
========================2018-11-02 12:00: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 = '571494353341' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-11-02 12:01:23======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-010 
parm_os_type = 64 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 20CF30DEA0C728BF4431 
sCDKey = 571494353341 
sName = USER-010 
========================2018-11-02 12:01: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 = '571494353341' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2018-11-02 12:05:21======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER-010 
parm_os_type = 64 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = 20CF30DEA0C728BF4431 
sCDKey = 571494353341 
sName = USER-010 
========================2018-11-02 12:05: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 = '571494353341' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-11-02 12:05:21======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'daechang2009'  
========================2018-11-02 12:05:21======================== 
SELECT idx FROM macs WHERE mac_addr = '20CF30DEA0C728BF4431' AND app_code = '039' 
========================2018-11-02 12:05:21======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '144275' 
========================2018-11-02 12:05:21======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '144275' 
========================2018-11-02 12:05:21======================== 
UPDATE mac_detail SET  pc_name = 'USER-010', os_type = '64', user_id = 'daechang2009', user_name = '대창열처리 [김재균]',
												 screen_w = '1600', screen_h = '900', cdkey = '571494353341'
								  WHERE mac_idx = '144275'  


========================2018-11-02 14:38:54======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HANMI-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = C03FD5AF68C9D69007EF 
sCDKey = 420544131609 
sName = HANMI-PC 
========================2018-11-02 14:38: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 = '420544131609' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2018-11-02 14:38:54======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'gstworld'  
========================2018-11-02 14:38:54======================== 
SELECT idx FROM macs WHERE mac_addr = 'C03FD5AF68C9D69007EF' AND app_code = '039' 
========================2018-11-02 14:38:54======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266373' 
========================2018-11-02 14:38:54======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '266373' 
========================2018-11-02 14:38:54======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '266373', 'C03FD5AF68C9D69007EF', '039', 'HANMI-PC', '90', '1920', '1080', 'gstworld', '(유)한미비철금속[조부형]', '420544131609'  ) 


========================2018-11-02 15:18:47======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = JYYSFGH7-PC 
parm_os_type = 90 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = B870F496E0851022EFC9 
sCDKey = 643239655302 
sName = JYYSFGH7-PC 
========================2018-11-02 15:18:47======================== 
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 = '643239655302' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-11-02 15:18:47======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ilsinchem'  
========================2018-11-02 15:18:47======================== 
SELECT idx FROM macs WHERE mac_addr = 'B870F496E0851022EFC9' AND app_code = '046' 
========================2018-11-02 15:18:47======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266382' 
========================2018-11-02 15:18:47======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '266382' 
========================2018-11-02 15:18:47======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '266382', 'B870F496E0851022EFC9', '046', 'JYYSFGH7-PC', '90', '1366', '768', 'ilsinchem', '(주)일신엠알오[허남도]', '643239655302'  ) 


========================2018-11-02 15:18:55======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = JYYSFGH7-PC 
parm_os_type = 90 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = B870F496E0851022EFC9 
sCDKey = 643239655302 
sName = JYYSFGH7-PC 
========================2018-11-02 15:18: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 = '643239655302' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-11-02 15:19:04======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = JYYSFGH7-PC 
parm_os_type = 90 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = B870F496E0851022EFC9 
sCDKey = 643239655302 
sName = JYYSFGH7-PC 
========================2018-11-02 15:19: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 = '643239655302' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-11-02 15:19:20======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = JYYSFGH7-PC 
parm_os_type = 90 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = B870F496E0851022EFC9 
sCDKey = 643239655302 
sName = JYYSFGH7-PC 
========================2018-11-02 15:19:20======================== 
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 = '643239655302' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-11-02 15:19:25======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = JYYSFGH7-PC 
parm_os_type = 90 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = B870F496E0851022EFC9 
sCDKey = 643239655302 
sName = JYYSFGH7-PC 
========================2018-11-02 15:19:25======================== 
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 = '643239655302' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2018-11-02 15:22:47======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = JYYSFGH7-PC 
parm_os_type = 90 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = B870F496E0851022EFC9 
sCDKey = 643239655302 
sName = JYYSFGH7-PC 
========================2018-11-02 15:22:47======================== 
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 = '643239655302' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2018-11-02 15:22:47======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ilsinchem'  
========================2018-11-02 15:22:47======================== 
SELECT idx FROM macs WHERE mac_addr = 'B870F496E0851022EFC9' AND app_code = '046' 
========================2018-11-02 15:22:47======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266382' 
========================2018-11-02 15:22:47======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '266382' 
========================2018-11-02 15:22:47======================== 
UPDATE mac_detail SET  pc_name = 'JYYSFGH7-PC', os_type = '90', user_id = 'ilsinchem', user_name = '(주)일신엠알오[허남도]',
												 screen_w = '1366', screen_h = '768', cdkey = '643239655302'
								  WHERE mac_idx = '266382'