How can I build a report that can list only nodes that are configured for snmpv3 and their snmp details for each node?
The ObjectSubType field only has SNMP/ICMP/WMI; what you're looking for is the SNMPVersion field. Valid entries are 0 (ICMP/WMI), 1, 2, and 3
Try this:
SELECT NodeID ,Caption ,IP_Address ,Vendor ,MachineType ,SNMPVersion ,SNMPV3Username ,SNMPV3Context ,SNMPV3PrivMethod ,SNMPV3PrivKey ,SNMPV3PrivKeyIsPwd ,SNMPV3AuthMethod ,SNMPV3AuthKey ,SNMPV3AuthKeyIsPwd ,RWSNMPV3Username ,RWSNMPV3Context ,RWSNMPV3PrivMethod ,RWSNMPV3PrivKey ,RWSNMPV3PrivKeyIsPwd ,RWSNMPV3AuthMethod ,RWSNMPV3AuthKey ,RWSNMPV3AuthKeyIsPwdFROM NodesWHERE SNMPVersion = 3
-ZackM
Loop1 Systems: SolarWinds Training and Professional Services
off the top of my head ObjectSubType was the field which calls out ICMP, snmpv2 or 3. Use this as your where clause and The remaining snmpv3 fields are clearly identified in the nodes table.
Excellent I'll try it out thanks!
