Splunk Search

Query to capture distinct source IP who triggered multiple signatures

sumit29
Path Finder

Dear Experts,

I require help to create the query.
I am creating the rule if single(unique) source triggered distinct signature(more than 2) . Than only we should get the result.

Fields involved src,signature,count

Thanks in advance

Tags (1)
0 Karma
1 Solution

dcarmack_splunk
Splunk Employee
Splunk Employee

Gotcha. Try this for your stats then.

... | stats values(signature) as signatures by src | eval sig_count=mvcount(signature) | where sig_count >= 2

View solution in original post

0 Karma

dcarmack_splunk
Splunk Employee
Splunk Employee

Gotcha. Try this for your stats then.

... | stats values(signature) as signatures by src | eval sig_count=mvcount(signature) | where sig_count >= 2

0 Karma

sumit29
Path Finder

Thanks :)....

0 Karma

dcarmack_splunk
Splunk Employee
Splunk Employee

no problem, glad to help!

0 Karma

dcarmack_splunk
Splunk Employee
Splunk Employee

index= sourcetype= | fields src signature | stats count by src signature | where count >= 2

0 Karma

sumit29
Path Finder

Thanks, But this query only gives signature count along with src , I require count of signature from single source.

Let say source 10.10.10.10 trigger signature name = x and another signature name =y . so this source triggered 2 distinct signature . This what i am looking

0 Karma
Get Updates on the Splunk Community!

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...

Splunk AppDynamics Agents Webinar Series

Mark your calendars! On June 24th at 12PM PST, we’re going live with the second session of our Splunk ...

SplunkTrust Application Period is Officially OPEN!

It's that time, folks! The application/nomination period for the 2025 SplunkTrust is officially open! If you ...