Getting Data In

How get _time vaules same format?

Sekhar
Explorer

My query index= nonjVs source = nonjavs | stats vaules(_time ) as start time values(_time) as endtime by empid 

Displayed below formate but I want to see my stat time  and end time "%m-%d-%y %H:%M:@%S"

Starttime 165575758474.67768 

End time 16777894894.67788

 

Labels (1)
Tags (1)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @Sekhar,

you have to use the eval command, with the strftime funtion, after the stats command:

index=nonjVs source=nonjavs 
| stats earliest(_time) AS starttime latest(_time) AS endtime BY empid 
| eval starttime=strftime(starttime,"%m-%d-%y %H:%M:%S"), endtime=strftime(endtime,"%m-%d-%y %H:%M:%S")

 Ciao.

Giuseppe

View solution in original post

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Sekhar,

you have to use the eval command, with the strftime funtion, after the stats command:

index=nonjVs source=nonjavs 
| stats earliest(_time) AS starttime latest(_time) AS endtime BY empid 
| eval starttime=strftime(starttime,"%m-%d-%y %H:%M:%S"), endtime=strftime(endtime,"%m-%d-%y %H:%M:%S")

 Ciao.

Giuseppe

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Sekhar ,

good for you, see next time!

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated 😉

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Using the Splunk Threat Research Team’s Latest Security Content

REGISTER HERE Tech Talk | Security Edition Did you know the Splunk Threat Research Team regularly releases ...

SplunkTrust | 2024 SplunkTrust Application Period is Open!

It's that time again, folks! That's right, the application/nomination period for the 2024 SplunkTrust is ...