This SWQL query will get you what you want:
CASE WHEN SNMPVersion = 1 THEN 'v1'
WHEN SNMPVersion = 2 THEN 'v2c'
WHEN SNMPVersion = 3 THEN 'v3'
END AS SNMPVersionUsed
,COUNT(1) AS Qty
WHERE ObjectSubType = 'SNMP'
GROUP BY SNMPVersion
Different way to slice the pie, same data:
Select SNMPVersion, COUNT(SNMPVersion) AS Total
Where ObjectSubType = 'SNMP'
Group by SNMPVersion,SNMPVersion
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.