Dashboards & Visualizations

Set subsearch at a different time range than main search

kkas
Path Finder

example: search sourcetype=A [search sourcetype=B|dedup derp|fields derp|rename derp as Network_ID]|dedup CLIENT_IP|fields CLIENT_IP|table CLIENT_IP

My inner subsearch needs a wide time range (30 days) to get all the events I'm looking for while the outer search only needs 1 day. If I set the search for last 30 days the outer search takes forever. Is there a way to have the inner search scan for last 30 days, and outer search scan for 1 day?

Tags (1)

woodcock
Esteemed Legend

Try this with your timepicker set to last 24 hours (or however you specify 1 day)

search sourcetype=A [search earliest=-30d@d latest=now sourcetype=B|dedup derp|fields derp|rename derp as Network_ID]|dedup CLIENT_IP|fields CLIENT_IP|table CLIENT_IP

zd00191
Communicator

Is it possible to do this and have the subsearch be an overlay to a column chart or line chart?

0 Karma

woodcock
Esteemed Legend

Yes, do it like this:

MyFirstSearchHere | chart STUFF | append [search earliest=-30d@d latest=now MySecondSearchHere | chart STUFF]
0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...