Getting Data In

How to assign timestamp for an event from two different fields

ankithreddy777
Contributor

I have an event like

"abcabcabc....abc..timestamp:-2017-05-05T*08:08:08.987.....abc...abc.....date:-2017-05-03*......""

I need to assign _time where date should be extracted from date field and time value should be extracted from timestamp field.
Is there any possibility.

If I need to use datatime_renamed.xml , where I should place this new resulting file. Does this effect existing settings on other indexes.

Tags (1)
0 Karma

jkat54
SplunkTrust
SplunkTrust
| rex "(?<time>\d{2}:\d{2}:\d{2}\.\d{3})" 
| rex "date:-(?<date>\d{4}-\d{2}-\d{2})"
| eval datetime=strftime(date."T".time, "%FT%T.%3N")
| table datetime

adonio
Ultra Champion

Beautiful,
regarding the second part of the question, @jkat54 used the erx command to extract the timeestamp which means its at search time. it will not affect other settings

0 Karma
Get Updates on the Splunk Community!

Pro Tips for First-Time .conf Attendees: Advice from SplunkTrust

Heading to your first .Conf? You’re in for an unforgettable ride — learning, networking, swag collecting, ...

Raise Your Skills at the .conf25 Builder Bar: Your Splunk Developer Destination

Calling all Splunk developers, custom SPL builders, dashboarders, and Splunkbase app creators – the Builder ...

Hunt Smarter, Not Harder: Discover New SPL “Recipes” in Our Threat Hunting Webinar

Are you ready to take your threat hunting skills to the next level? As Splunk community members, you know the ...