cancel
Showing results for 
Search instead for 
Did you mean: 
woodssx
Level 7

How to create a report for snmp version detail and the total count.

Jump to solution

I need assistance with creating a report for snmp version detail which gives a total number.

0 Kudos
3 Replies
mrxinu
Level 16

Re: How to create a report for snmp version detail and the total count.

Jump to solution

This SWQL query will get you what you want:

SELECT

    CASE WHEN SNMPVersion = 1 THEN 'v1'

         WHEN SNMPVersion = 2 THEN 'v2c'

         WHEN SNMPVersion = 3 THEN 'v3'

    END AS SNMPVersionUsed

    ,COUNT(1) AS Qty

FROM Orion.Nodes

WHERE ObjectSubType = 'SNMP'

GROUP BY SNMPVersion

Highlighted
ctlswadmin
Level 12

Re: How to create a report for snmp version detail and the total count.

Jump to solution

Different way to slice the pie, same data:

Select SNMPVersion, COUNT(SNMPVersion) AS Total

From Nodes

Where ObjectSubType = 'SNMP'

Group by SNMPVersion,SNMPVersion

jrivera10
Level 7

Re: How to create a report for snmp version detail and the total count.

Jump to solution

This worked perfectly now if could figure out how to make a custom chart with this data.

0 Kudos