Knowledge Management

Multiple time frame search with one of the time frames not utilizing brackets within a macro

Lucas_K
Motivator

I have a solution that uses api called macros that prefix the time frame to the search.

ie. earliest="03/14/2019:00:00:00" latest="03/14/2019:23:59:59" my_report(sample)

I need to modify this macro to search two different datasets for two different time spans (one summary, the other near realtime raw).

The idea being that I can stitch the summary and raw together to create an up to the minute report.

Contents of my_report macro
index=old_summary_data $token1$ OR (index=new_raw_data earliest=@d latest=now $sample$)

My expanded macro becomes this

earliest="03/14/2019:00:00:00" latest="03/14/2019:23:59:59" index=old_summary_data $token1$ OR (index=new_raw_data earliest=@d latest=now $sample$)

This will fail

Error in 'litsearch' command: Unable to parse the search: Invalid time bounds in search: start=1568869200 > end=1568865600.

This is due to not having a bracket preceeding the first "earliest" as per splunk docs :
(https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/SearchTimeModifiers)

example.(earliest="1/22/2018:17:00:00" latest="1/22/2018:18:00:00") OR (earliest="1/22/2018:19:00:00" latest="1/22/2018:20:00:00")

Is there any way I can make a non-bracketed time frame and query honor the

earliest="03/14/2019:00:00:00" latest="03/14/2019:23:59:59" index=old_summary_data $token1$ OR (index=new_raw_data earliest=@d latest=now $sample$)

Tags (2)
0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...