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

Need Help Reporting on Hash/Encryption Types Used in SNMPv3

I am trying to report on the polling methods on nodes in a network.

I already have node identifying information, whether the node is external, the polling method (ICMP or SNMP), and the SNMP version. I have yet to find a way to include, for nodes being polled via SNMPv3, the hash method on the Auth (MD5 or SHA) or the encryption method on the Priv (DES56, AES128, etc.). I am not interested in reporting the passwords themselves. If any of you have found a way to report a node's configuration for these values, I would appreciate a hand.

Find more posts tagged with

snmpv3

report_writer

Accepted answers

All comments

mesverrum

For whatever reason this table doesnt show up in SWQL, but you can get the info using regular SQL

Try a custom table and see if this gets you started

SELECT TOP 1000 * FROM [dbo].[CredentialProperty]

join dbo.credential on credential.id=credentialproperty.credentialid

where credentialtype='SolarWinds.Orion.Core.Models.Credentials.SnmpCredentialsV3'

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

mjperkins

Thanks for the reply, mesverrum. The tables you found had information of the right type, but not for each node in the network. While that did not provide the answer, it did steer me toward it. I actually found what I needed in the NodesData table:

SELECT Caption, IP_Address, Vendor, MachineType, ObjectSubType, SNMPVersion, SNMPV3AuthMethod, SNMPV3PrivMethod

FROM [dbo].[NodesData]