Hi ,
Is there any way to see the saved credentials for Windows , UCS or VM saved in database?.
Under Settings, you will find a link for 'Manage Windows Credentials'. Under Settings > Virtualization Settings , you will find a link to manage all the VMware credentials. I don't believe there is a central place to see all UCS credentials.
That's a good question,
This question is Not Answered.
That is a great question, ">aqeel73
I ran the query shown below against the SolarWinds database looking for columns with the name credential:
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%credential%'
ORDER BY schema_name, table_name;
I did the same thing, using the word password instead. So far, none of the columns found contained the Windows credentials. Since SolarWinds does not publish schema for their database, it seems that we'll need to wait for someone very knowledgeable in the SolarWinds database to jump in. Of course, you can also open a ticket w/SolarWinds customer support instead. I wish I could have been more helpful. Best wishes.
I believe querying the dbo.Credential and dbo.CredentialProperty tables in the database will give you what you want but of course you won't be able to see the passwords as they will be encrypted if that's what you are trying to achieve.
Yes, the passwords are encrypted. But it will be reversible however Solarwinds won't tell you how or share the encryption keys.
Quite so. The passwords are encrypted for a reason: to stop exactly what we're trying to achieve in this discussion. My recommendation is to use a 3rd party tool, like KeePass, to store your passwords and have your IT manager put a policy in place stipulating that all passwords must be recorded in said tool.
"FB180071" is a feature request that has been raised in the system to programmatically update/change credentials in SAM's Credentials Library as per Component Monitor Credentialsdiscussion.
