Getting Data In

Recursive query based upon current result set

catsmeowor
Explorer

Having some trouble figuring this out, and fishing for an example as well.

Have an index that contains URL traffic logs. The category of these logs is dynamically updated each day.

index=url_logs category=malware | table user category url --> i get my results if there's any hits

But i what I'd like to do is to search for anything that currently matches malware on today's date with a search going back at least a week. That way I could tell if there was a lot of allowed traffic to a site that is now malicious and investigate from there.

Any suggestions? Thank you!

Tags (1)
0 Karma

valiquet
Contributor

index=url_logs url=* | stats values(user), values(url) by category | where category=malware

0 Karma
Get Updates on the Splunk Community!

Index This | When is October more than just the tenth month?

October 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What’s New & Next in Splunk SOAR

 Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us for an ...