-
Re: Trying to remove a windows credential from NPM
petrf Apr 25, 2012 2:36 AM (in response to craig.forrest)I'm not sure if you can get this information via web console but you can use SQL script bellow which gives you ordered list of windows credentials and their nodes. It works for NPM 10.2.
SELECT c.[Name] CredentialName
,cp.[Value] WindowsUserName
,n.[NodeID]
,n.[IP_Address]
,n.[Caption]
FROM [SolarWindsOrion].[dbo].[Credential] c
JOIN [SolarWindsOrion].[dbo].[CredentialProperty] cp ON cp.[CredentialID] = c.[ID]
JOIN [SolarWindsOrion].[dbo].[NodeSettings] ns ON ns.[SettingValue] = c.[ID]
JOIN [SolarWindsOrion].[dbo].[Nodes] n ON n.[NodeID] = ns.[NodeID]
WHERE [CredentialOwner] = 'Orion'
AND [CredentialType] = 'SolarWinds.Orion.Core.SharedCredentials.Credentials.UsernamePasswordCredential'
AND cp.[NAME] = 'UserName'
AND ns.[SettingName] = 'WMICredential'
ORDER BY cp.[Value], n.[Caption]