Dashboards & Visualizations

evaluate custom result fields against earliest and latest search time

dominiquevocat
SplunkTrust
SplunkTrust

How can i evaluate values in a result table from a query against the searches timerange?

Example:

UserID, FirstDay, LastDay, ...
xyz, 20120901, , ...
abc, 20100101, 20121031, ...

I would like to compare the timestamp in FirstDay against "earliest" and LastDay against "latest" from the search parameters.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Add |addinfo to your search and use info_min_time and info_max_time.

0 Karma

dominiquevocat
SplunkTrust
SplunkTrust

thanks, with that i have the epoch times, i also use
eval myfieldepoch=strptime(myfield,"%Y%m%d") and have the epoch time, when i then use
| addinfo | search myfieldepoch>=info_min_time i get no results so i am making something wrong.

0 Karma
Get Updates on the Splunk Community!

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 ...

Splunk APM: New Product Features + Community Office Hours Recap!

Howdy Splunk Community! Over the past few months, we’ve had a lot going on in the world of Splunk Application ...

Index This | Forward, I’m heavy; backward, I’m not. What am I?

April 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...