SNMPv3 Credential Report

Hey Sotherls,

Is it safe to assume that all of your passwords are the same based on username ? Or is this the reason for seeking this report to find password typos.

If your passwords always match the username, you could do a sql case statement around the username. I can write you up a query if you'd like, or if you just need the tables. This info is found on the credential and CredentialProperty table.

Found it using SDK.

I was able to create the report

I'm intrested in how you did this, can you share ?

Thanks,

David

There is a way to query the db with the SWQL.  http://<orionserver>/Orion/admin/swis.aspx   I messed with it for a while till I figured out what I needed then built a report using the the following SWQL:

SELECT SysName, AgentIP, SNMPUsername, SNMPLevel, SNMPEncryptType, SNMPAuthType, OSVersion, OSImage FROM Cirrus.Nodes

I ran the query, but the passwords are still encrypted. Any tricks on decryption  ?

I was speaking with a SW SE this week about similar topics, and I was lamenting the lack of the ability to discover credentials used by NCM after version 7.3.  He said he's heard that complaint a lot, but that SW government customers required it to be removed due to security concerns, so I won't be surprised if the GUI, SQL, or SWQL can't display them.

However, if someone DOES have the process, it would be worth learning if you'd be so kind as to share it.  Sometimes troubleshooting is nice to do knowing the exact phrases (password or snmp-v3) that things SHOULD be using, then comparing to what NCM is actually trying to use against them.

That explains why they moved away from plain text credential storage. I do think that higher tier organizations have the resources to manipulate their vendor products to fit their needs. We encrypted snmp credentials on 10.7 I believe, might have been an earlier version.

I run the query, it shows the info I need (node name, IP address, SNMPusername and SNMPversion).  good enough.

but how do I export it to excel or csv file.

thanks for your help again.

pp2

I ended up creating a report with the query.  the report will have an export to excel button.

Hi tbemus,

will you be able to share the SNMP query report with excel button?

this will be very helpful to all the operations team.

Thanks.

PP2