

========================2021-02-15 09:24:24======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = NAMYANG9784-SAM 
parm_os_type = 110 
parm_screen_w = 1366 
parm_screen_h = 768 
parm_user_mac = 48D224C04E8FEF2DB70 
sCDKey = 494461870147 
sName = NAMYANG9784-SAM 
========================2021-02-15 09:24: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 = '494461870147' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-15 09:24:25======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'woon9784'  
========================2021-02-15 09:24:25======================== 
SELECT idx FROM macs WHERE mac_addr = '48D224C04E8FEF2DB70' AND app_code = '039' 
========================2021-02-15 09:24:25======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336898' 
========================2021-02-15 09:24:25======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '336898' 
========================2021-02-15 09:24:25======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '336898', '48D224C04E8FEF2DB70', '039', 'NAMYANG9784-SAM', '110', '1366', '768', 'woon9784', '남양석유[이명운]', '494461870147'  ) 


========================2021-02-15 10:02:06======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = JK30 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 8C89A5E7D09F9CD98A17 
sCDKey = 488679380965 
sName = JK30 
========================2021-02-15 10:02:06======================== 
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 = '488679380965' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-15 10:02:06======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ksd15577'  
========================2021-02-15 10:02:06======================== 
SELECT idx FROM macs WHERE mac_addr = '8C89A5E7D09F9CD98A17' AND app_code = '039' 
========================2021-02-15 10:02:06======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321682' 
========================2021-02-15 10:02:06======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '321682' 
========================2021-02-15 10:02:06======================== 
UPDATE mac_detail SET  pc_name = 'JK30', os_type = '110', user_id = 'ksd15577', user_name = '동진안전공구[김인서]',
												 screen_w = '1920', screen_h = '1080', cdkey = '488679380965'
								  WHERE mac_idx = '321682'  


========================2021-02-15 11:05:32======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = US57 
parm_os_type = 90 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 8C89A5E7D5902C3899D2 
sCDKey = 702871287149 
sName = US57 
========================2021-02-15 11:05: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 = '702871287149' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-15 11:05:32======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ksd1557'  
========================2021-02-15 11:05:32======================== 
SELECT idx FROM macs WHERE mac_addr = '8C89A5E7D5902C3899D2' AND app_code = '039' 
========================2021-02-15 11:05:32======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279412' 
========================2021-02-15 11:05:32======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '279412' 
========================2021-02-15 11:05:32======================== 
UPDATE mac_detail SET  pc_name = 'US57', os_type = '90', user_id = 'ksd1557', user_name = '유한회사 동진종합상사[김인범]',
												 screen_w = '1680', screen_h = '1050', cdkey = '702871287149'
								  WHERE mac_idx = '279412'  


========================2021-02-15 11:06:09======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = JUNE 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = BCAEC570E29690C8F1DA 
sCDKey = 702871287149 
sName = JUNE 
========================2021-02-15 11:06:09======================== 
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 = '702871287149' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-15 11:06:09======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'ksd1557'  
========================2021-02-15 11:06:09======================== 
SELECT idx FROM macs WHERE mac_addr = 'BCAEC570E29690C8F1DA' AND app_code = '039' 
========================2021-02-15 11:06:09======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279691' 
========================2021-02-15 11:06:09======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '279691' 
========================2021-02-15 11:06:09======================== 
UPDATE mac_detail SET  pc_name = 'JUNE', os_type = '90', user_id = 'ksd1557', user_name = '유한회사 동진종합상사[김인범]',
												 screen_w = '1920', screen_h = '1080', cdkey = '702871287149'
								  WHERE mac_idx = '279691'  


========================2021-02-15 12:16:42======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = JBH-PC 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A0A8CDE8C3A8BC1368E0 
sCDKey = 550400830049 
sName = bmtec 
========================2021-02-15 12:16: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 = '550400830049' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2021-02-15 14:47:12======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = USER1 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D050994BBECF8FFAEE0 
sCDKey = 353040810080 
sName = USER1 
========================2021-02-15 14:47: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 = '353040810080' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-15 14:47:12======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'jy0626'  
========================2021-02-15 14:47:12======================== 
SELECT idx FROM macs WHERE mac_addr = 'D050994BBECF8FFAEE0' AND app_code = '039' 
========================2021-02-15 14:47:12======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336997' 
========================2021-02-15 14:47:12======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '336997' 
========================2021-02-15 14:47: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	 ( '336997', 'D050994BBECF8FFAEE0', '039', 'USER1', '110', '1920', '1080', 'jy0626', '한국테크노히타[이진우]', '353040810080'  ) 


========================2021-02-15 15:43:24======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = HBDS-10 
parm_os_type = 110 
parm_screen_w = 1600 
parm_screen_h = 900 
parm_user_mac = C4850838C7465ABC1562 
sCDKey = 683156263623 
sName = HBDS-10 
========================2021-02-15 15:43: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 = '683156263623' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2021-02-15 15:43:25======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bangchun'  
========================2021-02-15 15:43:25======================== 
SELECT idx FROM macs WHERE mac_addr = 'C4850838C7465ABC1562' AND app_code = '039' 
========================2021-02-15 15:43:25======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '337021' 
========================2021-02-15 15:43:25======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '337021' 
========================2021-02-15 15:43:25======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '337021', 'C4850838C7465ABC1562', '039', 'HBDS-10', '110', '1600', '900', 'bangchun', '한반도[이진석]', '683156263623'  ) 


========================2021-02-15 18:22:14======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = BMTEC01 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 002522B428A1B8F264CF 
sCDKey = 550400830049 
sName = BMTEC 
========================2021-02-15 18:22:14======================== 
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 = '550400830049' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2021-02-15 18:22:19======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = BMTEC01 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 002522B428A1B8F264CF 
sCDKey = 550400830049 
sName = BMTEC 
========================2021-02-15 18:22: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 = '550400830049' 
			AND r.app_code = '039'
			AND r.app_block = 0