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!

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 ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...