How to get result for device grouped by two different fields

hcastell — Fri, 05 Sep 2014 04:16:54 GMT

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.

Re: How to get result for device grouped by two different fields

MuS — Fri, 05 Sep 2014 05:40:26 GMT

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

topic How to get result for device grouped by two different fields in Splunk Search

How to get result for device grouped by two different fields

Re: How to get result for device grouped by two different fields