Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

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

woodssx

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

Find more posts tagged with

Accepted answers

mrxinu

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 QtyFROM Orion.NodesWHERE ObjectSubType = 'SNMP'GROUP BY SNMPVersion

All comments

mrxinu

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 QtyFROM Orion.NodesWHERE ObjectSubType = 'SNMP'GROUP BY SNMPVersion

ctlswadmin

Different way to slice the pie, same data:

Select SNMPVersion, COUNT(SNMPVersion) AS Total

From Nodes

Where ObjectSubType = 'SNMP'

Group by SNMPVersion,SNMPVersion

jrivera10

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