Report to find nodes associated with Windows Crendential

, I am looking for the same

With the NCM credentials, when you delete the credential, it tells you which devices it is still associated with and won't delete the credential.

I don't monitor Windows boxes so I can't test this theory. It may work for you. Just try and delete the credential, and it should come back and tell you what it is associated with. To test it, create a new credential, assign it to a windows device and then delete it. See if it lets you and tells you which device it is associated with.

Good tip. I'll try that!

Doug

Unfortunately, this doesn't work.  The Delete option is grayed out, so you can't even try to delete it to see what it comes back with, at least in our environment.

Orion Platform 2014.1.0

SAM 6.1.0

NPM 10.7

IVIM 1.9.0

yep. I got lucky on a hunch and opened one category of devices and found

the creds simply associated with those handful of devices in that

category.

Doug

Here's the answer  : Create a Advanced SQL Report using the below query or to test it run the below query on your Solarwinds DB

Select Nodes.IP_Address, Nodes.Caption, Credential.Name from Credential

inner join NodeSettings on Credential.ID=NodeSettings.SettingValue

inner join Nodes on NodeSettings.NodeID=Nodes.NodeID

where NodeSettings.SettingName='WMICredential'

If all you are looking to do is identify which nodes they are and you only have the one WMI credential, you could simply just navigate to 'Manage Nodes' and change the 'Group by:' drop down menu to 'Polling Method':

If you want it in a report format or need to differentiate between credentials, then you will need to do a custom query/advanced SQL report.

great thanks!

thanks!

Hi, mark the answer as helpful or correct if they did help you