Hi,
Can anyone help me with best configurations for timestamp parsing (where "DateTime" is the actual time) for following JSON format :
{ [-]
AccessKey: ----------------------
Account: some-value
AccountId: somevalue
Action: GetInstances
Class: ----------------------------------------------------------
**DateTime: 2007-10-27T00:51:57.91Z**
ElapsedTime: 00:00:00
File: null
Level: Trace
Line: null
LogId: ID-347t58734534-6565ghmhmm
Message: Vapor URL - https://www.randomURL.com,ImageId)
Header - {
"Signature": "$^%$#@)(#4t4r65gvjhloojk",
"AccessKey": "123854y3957349534-0fdjvbkjds90234u02394-23940=dsffsvbkdjadsvfnk0923480",
"RequestType": 0,
"SkipOwnerLookup": false,
"UserAgent": "456934",
"UserAgentVersion": null,
"Timestamp": "2007-10-27T00:51:57Z",
"User": "3254832564873`12",
"TestMode": false,
"ScheduledAction": false
}
What I have already tried in props.conf is:
[API]
TIMESTAMP_FIELDS=DateTime
INDEXED_EXTRACTIONS=json
NO_BINARY_CHECK=true
KV_MODE=none
And also:
[API]
TIME_PREFIX = "\"DateTime\":\"
INDEXED_EXTRACTIONS=json
Also, I have been through the link:
https://answers.splunk.com/answers/104500/transforming-timestamps.html
None of the two seem to be working. Any comments/ suggestions will be highly appreciated.
... View more