Reporting

How to add search timeframe to a report results?

kearaspoor
SplunkTrust
SplunkTrust

I have a search that is correctly generating a report that contains just a table, no charts, and no event timestamps.

I need to be able to add the search timeframe parameter somewhere in the results. Either as part of the report name, or as a comment/legend/footnote.

So, if the search spans the previous month, I need something like:

ReportName - mm/dd/yy to mm/dd/yy.

Any suggestions?

Tags (3)
0 Karma
1 Solution

HiroshiSatoh
Champion

I can be set in this period if the search time range picker.
However, it is added to all the results.

(your search)|addinfo | eval ReportName =strftime(info_min_time,"%y/%m/%d")."To".strftime(info_max_time,"%y/%m/%d")

If you want to add only one line
(your search)|append [| stats count |addinfo | eval ReportName =strftime(info_min_time,"%y/%m/%d")."To".strftime(info_max_time,"%y/%m/%d") ]

View solution in original post

HiroshiSatoh
Champion

I can be set in this period if the search time range picker.
However, it is added to all the results.

(your search)|addinfo | eval ReportName =strftime(info_min_time,"%y/%m/%d")."To".strftime(info_max_time,"%y/%m/%d")

If you want to add only one line
(your search)|append [| stats count |addinfo | eval ReportName =strftime(info_min_time,"%y/%m/%d")."To".strftime(info_max_time,"%y/%m/%d") ]

kearaspoor
SplunkTrust
SplunkTrust

Thank you! That worked wonderfully!

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...