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!

Splunk Search APIを使えば調査過程が残せます

   このゲストブログは、JCOM株式会社の情報セキュリティ本部・専任部長である渡辺慎太郎氏によって執筆されました。 Note: This article is published in both Japanese ...

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

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...