Devolutions ForumDevolutions Forum

RDM Database: where are the credentials stored?

RDM Database: where are the credentials stored?

avatar
(user deleted)
Disabled

Hi. I need to compare credentials between different systems and an Oracle DB. I've been looking for a bit where these are hidden in the (in our case) MSSQL Express DB used by RDM. I can find pretty much all data in there but not credentials. They must be encoded in there or it wouldn't be possible to see them plain-text inside the app. The only thing I find is a dbo.Credential but that only has an ID column and seems empty. Now, I'm a sysadmin and not a real DBA, so I might be missing something here.


Devolutions Password Server uses the same DB structure I saw so I guess an answer to this question would be valid for the other product too.

All Comments (3)

avatar
David Hervieux

Hi,
It's encrypted in the raw data. You should try to use the PowerShell SDK instead. I don't think it's a good idea or even easy to access the database directly.

https://help.remotedesktopmanager.com/index.html?tools_consoles_powershell.htm

Regards

David Hervieux

avatar













Merci David. I wrote a PoSh script that does exactly what I want. Here's the relevant part:


$arrCredential = @()
$arrSession = @(get-rdmsession | where-object {$_.ConnectionType -eq 'credential'})
foreach ($objSession in $arrSession){
$objCredential = new-object -typename psobject
$objCredential | add-member -membertype noteproperty -name Group -value $objSession.Group
$objCredential | add-member -membertype noteproperty -name Name -value $objSession.Name
$objCredential | add-member -membertype noteproperty -name Domain -value $objSession.HostDomain
$objCredential | add-member -membertype noteproperty -name Username -value $($objSession | get-rdmsessionusername)
$objCredential | add-member -membertype noteproperty -name Password -value $($objSession | get-rdmsessionpassword -asplaintext)
$arrCredential += $objCredential
}
$arrCredential
Even though it's a different product: we are considering to buy Devolutions Password Server. The DB looks the same, but does it also have Powershell support so I can do the same? It's an important requirement for us to be able to export the data.

avatar
David Hervieux

DPS and SQL Server data source share the same database structure but DPS has more security features.

Regards

David Hervieux