Splunk Search

How to format _time field and get rid of miliseconds?

lutel
Explorer

Hi,

In the search results, I'd like to have _time displayed without ms at the end (06/11/2013 23:13:22.000 -> 06/11/2013 23:13:22) - is there any way to do it other than | _time .... ?

Also, this field in list and table layouts, always brakes into two lines, making the output ugly, can it be changed somehow?

0 Karma

lutel
Explorer

Thanks but as I said I'm looking for a way to make it permament in view, I guess some template modification is needed...

0 Karma

somesoni2
Revered Legend

For your ms removal requirement, your can use following eval command:

|eval _time=strftime(_time,"%m/%d/%Y %H:%M:%S")

0 Karma

lutel
Explorer

Thanks but as I said I'm looking for a way to make it permament in view, I guess some template modification is needed...

0 Karma
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...