Splunk Search

How to get result for device grouped by two different fields

hcastell
Path Finder

I have the following scenario:

x number of devices connected to 8 different nodes. The 8 nodes are connected to 3 switches. What I'm trying to do is generate a report that will show me the number of nodes that have device failures broken down by switch. I can generate a report that shows me the device failure by node but can't figure out how to get nodes with device failures broken down by switch.

The following search string allows me to get the device (STB) failure count by node (NodeName):

| eval foo=if(stb_fail==0, 0, 1)
| stats sum(foo) AS TotalBox by NodeName
| eval fooNode=case(TotalBox==1,"1", TotalBox==2,"2",TotalBox>2,">2")
| stats count by fooNode

I have a field called NodeName as well as another called SwitchName and have a table with values for both these fields. Hope my question is clear. Appreciate any assistance offered.

Tags (1)
0 Karma

MuS
SplunkTrust
SplunkTrust

Hi hcastell,

if I get this correct you should be able to use something like this run everywhere command:

index=_internal  source=*metrics.log | stats count(sourcetype) AS c_st by series

If you adapt it to your needs it would look like this:

your base search here
| eval foo=if(stb_fail==0, 0, 1)
| stats sum(foo) AS TotalBox by NodeName
| eval fooNode=case(TotalBox==1,"1", TotalBox==2,"2",TotalBox>2,">2")
| stats count(fooNode) by SwitchName

hope this helps ...

cheers, MuS

0 Karma
Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...