Splunk Search

How to convert Unix format and compare it with _time for given values of `savedsearch_name` and have a clear visualization

mo_shahin
Engager

I am trying to visualize the deviation between a correlation rule's scheduled time and the time it was run.
went through the index=_internal sourcetype=scheduler
and found the scheduled time in Unix timestamp format.

How can I convert Unix format and compare it with _time for given values of savedsearch_name and have a clear visualization (to present it for management)

0 Karma

to4kawa
Ultra Champion
your search
|eval my_time= _time

Hi, @mo_shahin
try this, and check my_time. It is unnecessary to convert to Unix timestamp format.

and, Visualization....

index=_internal sourcetype=scheduler
| eval diff=_time - savedsearch_name
| table _time diff

try Line Chart

0 Karma
Get Updates on the Splunk Community!

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more with ITSI’s ...

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more! Faster Time to ValueManaging and ...

New Release | Splunk Enterprise 9.3

Admins and Analyst can benefit from:  Seamlessly route data to your local file system to save on storage ...

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...