========================2020-11-09 10:38:30======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-VEFG2EF 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 74D4351DA14A1EC0B7CB 
sCDKey = 266382448056 
sName = DESKTOP-VEFG2EF 
========================2020-11-09 10:38: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 = '266382448056' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-11-09 10:38:30======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'tk9400'  
========================2020-11-09 10:38:30======================== 
SELECT idx FROM macs WHERE mac_addr = '74D4351DA14A1EC0B7CB' AND app_code = '039' 
========================2020-11-09 10:38:30======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '325998' 
========================2020-11-09 10:38:30======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '325998' 
========================2020-11-09 10:38:30======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '325998', '74D4351DA14A1EC0B7CB', '039', 'DESKTOP-VEFG2EF', '110', '1680', '1050', 'tk9400', 'Å°æÀü±â[ÀÌÁøÅÂ]', '266382448056'  ) 



========================2020-11-09 13:16:42======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = OMS 
parm_os_type = 110 
parm_screen_w = 1360 
parm_screen_h = 768 
parm_user_mac = D45D643AFE0AE96767A 
sCDKey = 566189208903 
sName = OMS 
========================2020-11-09 13: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 = '566189208903' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-11-09 13:16:42======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'unikorea001'  
========================2020-11-09 13:16:42======================== 
SELECT idx FROM macs WHERE mac_addr = 'D45D643AFE0AE96767A' AND app_code = '039' 
========================2020-11-09 13:16:42======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329725' 
========================2020-11-09 13:16:42======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '329725' 
========================2020-11-09 13:16:42======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '329725', 'D45D643AFE0AE96767A', '039', 'OMS', '110', '1360', '768', 'unikorea001', 'À¯¾Ø¾ÆÀÌ[±è³²Ã¶]', '566189208903'  ) 



========================2020-11-09 14:50:54======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-2AT5MQO 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = E0D55E1F0C7E6855D080 
sCDKey = 009830290223 
sName = DESKTOP-2AT5MQO 
========================2020-11-09 14:50: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 = '009830290223' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-11-09 14:50:54======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kyy0424'  
========================2020-11-09 14:50:54======================== 
SELECT idx FROM macs WHERE mac_addr = 'E0D55E1F0C7E6855D080' AND app_code = '039' 
========================2020-11-09 14:50:54======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329662' 
========================2020-11-09 14:50:54======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '329662' 
========================2020-11-09 14:50: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	 ( '329662', 'E0D55E1F0C7E6855D080', '039', 'DESKTOP-2AT5MQO', '110', '1920', '1080', 'kyy0424', '¹Ì·¡Æ¯¼ö°í¹«[Á¤°æ¾Ö]', '009830290223'  ) 



========================2020-11-09 16:56:07======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = DESKTOP-GJS4MU0 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F44D30E98CE9222809D7 
sCDKey = 930217526571 
sName = DESKTOP-GJS4MU0 
========================2020-11-09 16:56: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 = '930217526571' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2020-11-09 16:56:07======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'siriuswhite'  
========================2020-11-09 16:56:07======================== 
SELECT idx FROM macs WHERE mac_addr = 'F44D30E98CE9222809D7' AND app_code = '046' 
========================2020-11-09 16:56:07======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329752' 
========================2020-11-09 16:56:07======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '329752' 
========================2020-11-09 16:56:07======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '329752', 'F44D30E98CE9222809D7', '046', 'DESKTOP-GJS4MU0', '110', '1920', '1080', 'siriuswhite', '(À¯)´ë¼ºÁ¾ÇÕ»ó»ç[¹éÁØ¿Á]', '930217526571'  )