Is there a way to create a custom date field in Splunk?
Sow lets say I have multiple events, all of these events have a date field CREATIONDATE. Now I want to create a new date field for events that have the action called "Validation" in them. And I would like to call this new date field VALIDATIONDATE.
I'm thinking this should be possible with the 'where' command, but I'm not certain how to use it.
What should the new date field's contents be? A copy of CREATIONDATE?
... | eval VALIDATIONDATE=CREATIONDATE
The current time?
... | eval VALIDATIONDATE=now()
Some other date relative to CREATIONDATE?
... | eval VALIDATIONDATE=relative_time(CREATIONDATE, "-1w")
If instead you are trying to create a new extraction to create this date out of some "validation date" that's inside an event, please post one of the events in question and we can totally help you with this!
The validation date is indeed a copy of the creationdate, but as I mentioned above it should only be created when its combined with the event action "Validation"
you can try like this:
index=indexname action="Validation"|eval VALIDATIONDATE=now()|eval VALIDATIONDATE=strftime(VALIDATIONDATE,"%d/%m/%Y %H:%M:%S")
here search for action="Validation" then create new field VALIDATIONDATE using eval function and assign it the value like here it will assign current time .