Splunk Search

How to modify my search to truncate time displayed on chart?

AKG1_old1
Builder

Hi,

I am tracking Splunk startup and stop through graph.

My search:

index=_audit action=splunkShuttingDown OR action=splunkStarting | timechart span=1s count by action

the time displayed in graph is bit long.
Currently displayed : 2017-02-22T00:00:08.000+01:00

I want it to truncate the part after minutes/seconds. some thing like this.
2017-02-22 00:00 or
2017-02-22 00:00:08

Thanks
Ankit

0 Karma
1 Solution

AKG1_old1
Builder

Solved by eval function

eval _time=strftime(_time, "%y-%m-%d %I:%M:%S")

View solution in original post

AKG1_old1
Builder

Solved by eval function

eval _time=strftime(_time, "%y-%m-%d %I:%M:%S")

Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...