Identify which node is assigned to which Windows credentials

vinay.by

As of now under Windows credentials we can only view the count of nodes assigned to a Windows credentials, I couldn't find a easy way to extract the node details associated to each of these windows credentials from DB or reports. If a new functionality is added in Solarwinds to pick the same it would be of great help. It could be either through reports or a new column in DB or through any other means which is feasible enough, to view the nodes associated to each of these credentials.

sean.martinez

I have created a SQL and SWQL statements to determine the Credentials that are currently assigned to Nodes.

SQL:

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'

SWQL:

Select N.IP_Address, N.Caption, C.Name from Orion.Credential C

Inner Join Orion.NodeSettings NS on C.ID=NS.SettingValue

Inner Join Orion.Nodes N on NS.NodeID=N.NodeID

Where NS.SettingName='WMICredential'