Hello,
I'm using Splunk Cloud.
I have date with this format and i want splunk to identify date as the timestamp(_time value).
{
"date": "2022-03-08T13:00:46.3204337+01:00",
"Delay Time": "0 Sec",
"OrderNumber": "6285071",
"Key / CLE": "622203040258800100A",
"Name": "ZM400_FINCON9P"
}
I have a source type defined like this but it's not working.
Did someone have a solution please ?
Thank you all
Try these Sourcetype definition properties (in the Advanced tab):
TIME_PREFIX = \"date\"\:\s*\"
TIME_FORMAT = %Y-%m-%dT%H:%M:%S.%7N%z
MAX_TIMESTAMP_LOOKAHEAD = 33
The Search Reference manual says %7Q is not a valid value (See https://docs.splunk.com/Documentation/Splunk/8.2.5/SearchReference/Commontimeformatvariables#:~:text...) Try %7N, instead.