Splunk Cloud Platform

How to run two searches having two different indexes using join command at different time range

Splunkerninja
Path Finder

Hi , 

I have two searches joined using join command. The first search i need to run earliest=-60mins and the second search is using summary index here i need to fetch all the results in summary index so I need to check and run summary index for "all time" .

How can this be done? I am giving earliest=-60min in my first search and time range as "all time" while scheduling the report consisting of this two searches but it is not working.

I have not used any time in my summary index. Search to populate my summary index

index=testapp sourcetype=test_appresourceowners earliest=-24h latest=now
| table sys_id, dv_manager, dv_syncenabled, dv_resource, dv_recordactive
| collect addtime=false index=summaryindex source=testapp.

my scheduled report search 

index=index1 earlies=-60m
| join host
[| search index=summaryindex earliest="alltime"]

| tablehost field1 field2

Labels (1)
Tags (3)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

ITWhisperer
SplunkTrust
SplunkTrust

Try

earliest=0
Get Updates on the Splunk Community!

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...