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

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

Different way to slice the pie, same data:

Select SNMPVersion, COUNT(SNMPVersion) AS Total

From Nodes

Where ObjectSubType = 'SNMP'

Group by SNMPVersion,SNMPVersion

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