Splunk Search

New rule in detecting multiple requests for a known Malicious destination from a single source could use help with the way the rule is written

ahmar74
Explorer

index=app_proxy sourcetype=bcoat_proxysg_app OR sourcetype=bcoat_proxyclient_app categories="Malicous Sources" OR "Botnets" | stats count by username,host,referrer | count> 1 | table _time username,host,referrer filter_results

Tags (1)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Additionally, after the stats there are no _time and filter_results columns, so listing them in table doesn't seem to make sense to me.

0 Karma

alacercogitatus
SplunkTrust
SplunkTrust

Sure - this looks like a search that returns information. However, it probably won't get the categories you are looking for. The below splits out the categories into the cim field "category". If this works for what you are looking for, then it makes sense.

index=app_proxy sourcetype=bcoat_proxysg_app OR sourcetype=bcoat_proxyclient_app category="Malicous Sources" OR category="Botnets" | stats count by username,host,referrer | where count> 1 | table _time username,host,referrer filter_results

martin_mueller
SplunkTrust
SplunkTrust

There's likely a syntax error in | count > 1 | due to lack of a search command such as search or where - both will achieve what you wanted and throw out events with count=1.

0 Karma

ahmar74
Explorer

does the rule make sense to you as is?

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Do elaborate on what you actually need help with.

Get Updates on the Splunk Community!

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...