

========================2020-03-16 10:15:55======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-527FS3P 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 14DAE9B1B06D9278C356 
sCDKey = 293765819265 
sName = DESKTOP-527FS3P 
========================2020-03-16 10:15: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 = '293765819265' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-03-16 10:17:07======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-527FS3P 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 14DAE9B1B06D9278C356 
sCDKey = 293768519265 
sName = DESKTOP-527FS3P 
========================2020-03-16 10:17: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 = '293768519265' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-03-16 10:17:07======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'samcoppy'  
========================2020-03-16 10:17:07======================== 
SELECT idx FROM macs WHERE mac_addr = '14DAE9B1B06D9278C356' AND app_code = '039' 
========================2020-03-16 10:17:07======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313106' 
========================2020-03-16 10:17:08======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '313106' 
========================2020-03-16 10:17:08======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '313106', '14DAE9B1B06D9278C356', '039', 'DESKTOP-527FS3P', '110', '1680', '1050', 'samcoppy', '삼성인쇄사[이은숙]', '293768519265'  ) 


========================2020-03-16 10:17:25======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-527FS3P 
parm_os_type = 110 
parm_screen_w = 1680 
parm_screen_h = 1050 
parm_user_mac = 14DAE9B1B06D9278C356 
sCDKey = 293768519265 
sName = DESKTOP-527FS3P 
========================2020-03-16 10:17: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 = '293768519265' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-03-16 10:47:31======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD67A927E26 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 10:47:31======================== 
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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 10:52:48======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD67A927E26 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 10:52:48======================== 
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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 10:52:59======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD67A927E26 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 10:52: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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 11:09:41======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-D83VPQN 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0D2094AE1ED63250 
sCDKey = mjsof2020031 
sName = DESKTOP-D83VPQN 
========================2020-03-16 11:09: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 = 'MJSOF2020031' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-03-16 11:12:16======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-D83VPQN 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0D2094AE1ED63250 
sCDKey = mjsof2020031 
sName = DESKTOP-D83VPQN 
========================2020-03-16 11:12: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 = 'MJSOF2020031' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-03-16 11:19:55======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-D83VPQN 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0D2094AE1ED63250 
sCDKey = 505709793149 
sName = 우영복 
========================2020-03-16 11:19: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 = '505709793149' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2020-03-16 11:19:55======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kk032w'  
========================2020-03-16 11:19:55======================== 
SELECT idx FROM macs WHERE mac_addr = '1C1B0D2094AE1ED63250' AND app_code = '039' 
========================2020-03-16 11:19:55======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310718' 
========================2020-03-16 11:19:55======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '310718' 
========================2020-03-16 11:19:55======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '310718', '1C1B0D2094AE1ED63250', '039', '우영복', '110', '1920', '1080', 'kk032w', '(주)건국내츄럴에프앤비[우영삼]', '505709793149'  ) 


========================2020-03-16 11:20:00======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-D83VPQN 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 1C1B0D2094AE1ED63250 
sCDKey = 505709793149 
sName = 우영복 
========================2020-03-16 11:20: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 = '505709793149' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2020-03-16 11:39:31======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD6E4D37468 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 11:39:31======================== 
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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 11:40:03======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD6E4D37468 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 11:40: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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 11:42:15======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD6E4D37468 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 11:42:15======================== 
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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 12:26:39======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = SAMSUNG-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 00E04C822531C7A5DC4 
sCDKey = 662073584754 
sName = SAMSUNG-PC 
========================2020-03-16 12:26: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 = '662073584754' 
			AND r.app_code = '046'
			AND r.app_block = 0 


========================2020-03-16 12:28:54======================== 
noteurl_start 
parm_app_code = 046 
parm_pc_name = SAMSUNG-PC 
parm_os_type = 90 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 00E04C822531C7A5DC4 
sCDKey = 662073584754 
sName = SAMSUNG-PC 
========================2020-03-16 12:28: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 = '662073584754' 
			AND r.app_code = '046'
			AND r.app_block = 0 
========================2020-03-16 12:28:54======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'simsjg'  
========================2020-03-16 12:28:54======================== 
SELECT idx FROM macs WHERE mac_addr = '00E04C822531C7A5DC4' AND app_code = '046' 
========================2020-03-16 12:28:54======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304918' 
========================2020-03-16 12:28:54======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '304918' 
========================2020-03-16 12:28: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	 ( '304918', '00E04C822531C7A5DC4', '046', 'SAMSUNG-PC', '90', '1920', '1080', 'simsjg', '삼일민속제과[권영희]', '662073584754'  ) 


========================2020-03-16 14:18:31======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD67A927E26 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 14:18:31======================== 
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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 14:18:49======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD67A927E26 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 14:18:49======================== 
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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 14:21:44======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD6E4D37468 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 14:21: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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 


========================2020-03-16 15:13:46======================== 
noteurl_start 
parm_app_code = 050 
parm_pc_name = DESKTOP-IFBVNE1 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = B42E99423BD6E4D37468 
sCDKey = 658355265661 
sName = DESKTOP-IFBVNE1 
========================2020-03-16 15:13: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 = '658355265661' 
			AND r.app_code = '050'
			AND r.app_block = 0 
========================2020-03-16 15:13:46======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'click061'  
========================2020-03-16 15:13:46======================== 
SELECT idx FROM macs WHERE mac_addr = 'B42E99423BD6E4D37468' AND app_code = '050' 
========================2020-03-16 15:13:46======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313123' 
========================2020-03-16 15:13:46======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '313123' 
========================2020-03-16 15:13:46======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '313123', 'B42E99423BD6E4D37468', '050', 'DESKTOP-IFBVNE1', '109', '1920', '1080', 'click061', '전라남도체육회[배상호]', '658355265661'  )