Splunk Search

How do you count events in groups of matching eventtypes?

alekz78
New Member

Looking for the count of events matching every eventtype combination.
For instance:
Given 5 events (e1..e5) that match eventtypes A and B as follows:

  1. e1 matches: eventtypeA eventtypeB
  2. e2 matches: eventtypeA
  3. e3 matches: eventtypeB
  4. e4 matches: eventtypeA eventtypeB
  5. e5 matches: eventtypeA

The count I'm looking for is:
EventTypes combination / count:

  • eventtypeA eventtypeB 2
  • eventtypeA 2
  • eventtypeB 1
0 Karma

gkanapathy
Splunk Employee
Splunk Employee

Seems to me you need to create a field that represents every combination of eventtypes, so:

... | eval comboeventtypes=mvjoin(eventtypes,";") | stats count by comboeventtypes
0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...