

========================2024-12-18 11:03:34======================== 
noteurl_start 
parm_app_code = 051 
parm_pc_name = BO_GA_AJY 
parm_os_type = 109 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = A8595FD466B570B3C0D3 
sCDKey = 144271475147 
sName = BO_GA_AJY 
========================2024-12-18 11:03:34======================== 
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 = '144271475147' 
			AND r.app_code = '051'
			AND r.app_block = 0 
========================2024-12-18 11:03:34======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'bavarian1'  
========================2024-12-18 11:03:34======================== 
SELECT idx FROM macs WHERE mac_addr = 'A8595FD466B570B3C0D3' AND app_code = '051' 
========================2024-12-18 11:03:34======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414912' 
========================2024-12-18 11:03:34======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '414912' 
========================2024-12-18 11:03:34======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '414912', 'A8595FD466B570B3C0D3', '051', 'BO_GA_AJY', '109', '1920', '1080', 'bavarian1', '바바리안모터스[김성근]', '144271475147'  ) 


========================2024-12-18 11:24:35======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-FCRT43E 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 74563C54F3AEDA281E79 
sCDKey = 323029878132 
sName = KORYO 
========================2024-12-18 11:24: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 = '323029878132' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-12-18 11:24:35======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'kr808187'  
========================2024-12-18 11:24:35======================== 
SELECT idx FROM macs WHERE mac_addr = '74563C54F3AEDA281E79' AND app_code = '039' 
========================2024-12-18 11:24:35======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414917' 
========================2024-12-18 11:24:35======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '414917' 
========================2024-12-18 11:24: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	 ( '414917', '74563C54F3AEDA281E79', '039', 'KORYO', '110', '1920', '1080', 'kr808187', '고려테크[김덕율]', '323029878132'  ) 


========================2024-12-18 14:41:16======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-62EO3S7 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 408D5CF98F8218E662EF 
sCDKey = 409636375789 
sName = DESKTOP-62EO3S7 
========================2024-12-18 14:41: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 = '409636375789' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-12-18 14:41:16======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'zebra998'  
========================2024-12-18 14:41:16======================== 
SELECT idx FROM macs WHERE mac_addr = '408D5CF98F8218E662EF' AND app_code = '039' 
========================2024-12-18 14:41:16======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414924' 
========================2024-12-18 14:41:16======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '414924' 
========================2024-12-18 14:41: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	 ( '414924', '408D5CF98F8218E662EF', '039', 'DESKTOP-62EO3S7', '110', '1920', '1080', 'zebra998', '동부자동차부분세차정비공업사[김영숙]', '409636375789'  ) 


========================2024-12-18 17:15:54======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-L9DP2FA 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F4B5206BFD6E1786E1CC 
sCDKey = 999859363809 
sName = DESKTOP-L9DP2FA 
========================2024-12-18 17:15: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 = '999859363809' 
			AND r.app_code = '039'
			AND r.app_block = 0 


========================2024-12-18 17:27:08======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-B948PMK 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = D45D6427FFA676237AD2 
sCDKey = 999859363809 
sName = 이춘화 
========================2024-12-18 17:27: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 = '999859363809' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-12-18 17:27:09======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'nkh10710'  
========================2024-12-18 17:27:09======================== 
SELECT idx FROM macs WHERE mac_addr = 'D45D6427FFA676237AD2' AND app_code = '039' 
========================2024-12-18 17:27:09======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '388188' 
========================2024-12-18 17:27:09======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '388188' 
========================2024-12-18 17:27:09======================== 
UPDATE mac_detail SET  pc_name = '이춘화', os_type = '110', user_id = 'nkh10710', user_name = '벧엘콘테이너[나광훈]',
												 screen_w = '1920', screen_h = '1080', cdkey = '999859363809'
								  WHERE mac_idx = '388188'  


========================2024-12-18 17:28:23======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-91AG4DG 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = 24F5AAEC82CE12A3E273 
sCDKey = 999859363809 
sName = 나경훈 
========================2024-12-18 17:28: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 = '999859363809' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-12-18 17:28:23======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'nkh10710'  
========================2024-12-18 17:28:23======================== 
SELECT idx FROM macs WHERE mac_addr = '24F5AAEC82CE12A3E273' AND app_code = '039' 
========================2024-12-18 17:28:23======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '192926' 
========================2024-12-18 17:28:23======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '192926' 
========================2024-12-18 17:28:23======================== 
UPDATE mac_detail SET  pc_name = '나경훈', os_type = '110', user_id = 'nkh10710', user_name = '벧엘콘테이너[나광훈]',
												 screen_w = '1920', screen_h = '1080', cdkey = '999859363809'
								  WHERE mac_idx = '192926'  


========================2024-12-18 17:29:01======================== 
noteurl_start 
parm_app_code = 039 
parm_pc_name = DESKTOP-L9DP2FA 
parm_os_type = 110 
parm_screen_w = 1920 
parm_screen_h = 1080 
parm_user_mac = F4B5206BFD6E1786E1CC 
sCDKey = 999859363809 
sName = 나광훈 
========================2024-12-18 17:29:01======================== 
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 = '999859363809' 
			AND r.app_code = '039'
			AND r.app_block = 0 
========================2024-12-18 17:29:01======================== 
SELECT CONCAT(Mcompany,'[', Mname,']')  FROM member WHERE MID = 'nkh10710'  
========================2024-12-18 17:29:01======================== 
SELECT idx FROM macs WHERE mac_addr = 'F4B5206BFD6E1786E1CC' AND app_code = '039' 
========================2024-12-18 17:29:01======================== 
UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414942' 
========================2024-12-18 17:29:01======================== 
SELECT mac_idx FROM mac_detail WHERE mac_idx = '414942' 
========================2024-12-18 17:29:01======================== 
INSERT INTO mac_detail (  mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey )
												VALUES	 ( '414942', 'F4B5206BFD6E1786E1CC', '039', '나광훈', '110', '1920', '1080', 'nkh10710', '벧엘콘테이너[나광훈]', '999859363809'  )