Reporting

Adjusting earliest/latest for both main search and sub-search

yyossef
Explorer

Hi,

I am encountering difficulty running different time range for main search and sub-search at the same time, while the time string is been received (ltime) from a savesearch.

attached are the savesearch i am running, and also the report wich is run by the savesearch.

savedsearch:
| savedsearch ltime="09/09/2017 22:00:00"

reportname:
index=GroupA latest=$ltime$ earliest=$ltime$-30m [ search index=GroupB earliest=$ltime$-7d latest=$ltime$ | table IP ] | stats latest(STATE) by IP

I would like to receive the latest time from a savedsearch and base on that, calculate the earliest/last parameter for both main search and sub-search.

I would appreciate Any advice , thanks!

aholzer
Motivator

Modifying time tokens is a little tricky, here's a link to another Splunk answers question that has a working solution to your problem.

Hope this helps

Get Updates on the Splunk Community!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...