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!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...