WitFoo-WinLogBeat ::: {"@metadata":{"beat":"winlogbeat","type":"_doc","version":"8.2.2"},"@timestamp":"2024-07-26T20:45:03.108Z","agent":{"ephemeral_id":"1d408618-0732-4715-8ce4-dd6a92b7ba01","id":"5056f6ce-0c8e-42be-8faf-9c226572874d","name":"NCAPROCPRDSQL01","type":"winlogbeat","version":"8.2.2"},"ecs":{"version":"8.0.0"},"event":{"action":"Backup","code":"18268","created":"2024-07-26T20:45:03.848Z","kind":"event","provider":"MSSQL$PAYGSQL01"},"host":{"name":"NCAPROCPRDSQL01.prdnca.starkint.com"},"log":{"level":"information"},"message":"Log was restored. Database: PRD_Processing_Client_000001, creation date(time): 2022/05/18(08:08:01), first LSN: 54586:31611:1, last LSN: 54587:4682:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'U:\\MSSQL\\BACKUP\\LOG\\NVIPROCPRDVCL01\\NVIPROCPRDVCL01$PRD_Processing_Client_000001\\PRD_Processing_Client_000001\\NVIPROCPRDVCL01$PRD_Processing_Client_000001_PRD_Processing_Client_000001_LOG_20240726_163208.trn'}). This is an informational message. No user action is required.","organization":"stark","senderHost":"10.168.22.7","sensitivity":"normal","winlog":{"api":"wineventlog","channel":"Application","computer_name":"NCAPROCPRDSQL01.prdnca.starkint.com","event_data":{"Binary":"5C4700000A0000001A0000004E0043004100500052004F004300500052004400530051004C00300031005C005000410059004700530051004C00300031000000070000006D00610073007400650072000000","param1":"PRD_Processing_Client_000001","param2":"2022/05/18","param3":"08:08:01","param4":"54586:31611:1","param5":"54587:4682:1","param6":"1","param7":"FILE=1, TYPE=DISK: {'U:\\MSSQL\\BACKUP\\LOG\\NVIPROCPRDVCL01\\NVIPROCPRDVCL01$PRD_Processing_Client_000001\\PRD_Processing_Client_000001\\NVIPROCPRDVCL01$PRD_Processing_Client_000001_PRD_Processing_Client_000001_LOG_20240726_163208.trn'}"},"event_id":"18268","keywords":["Classic"],"provider_name":"MSSQL$PAYGSQL01","record_id":1237403,"task":"Backup","user":{"domain":"prdnca","identifier":"S-1-5-21-1039153840-3272993233-2871880688-1634","name":"procprd-sqlagent","type":"User"}}}
This is a syslog message from a product called mssql$paygsql01 by mssql$paygsql01. The following fields were extracted from the message:
action: Backup
fieldExtractorName: winlogbeat
messageType: 18268
senderHost: 10.168.22.7
sensitivity: normal
sourceInfo: unknown
streamName: mssql$paygsql01
tags: ['v8', 'eventId:18268', 'mssql$paygsql01', '18268']
vendorCode: 1237403