script to update the notes field in DPS

Hello Ross,

We never recommend you go directly to the SQL for this type of modification. You can use the following RDM PowerShell script instead (RDM needs to be installed on the computer, with the Devolutions Server instance added as a data source):

Import-Module "${env:ProgramFiles(x86)}\Devolutions\Remote Desktop Manager\RemoteDesktopManager.PowerShellModule.psd1"

#set the current data source if you have more than one
Set-RDMCurrentDataSource $(Get-RDMDataSource -Name "Name of data source").ID

#Set the vault to the correct one
Set-RDMCurrentRepository $(Get-RDMRepository -Name "Name of vault").ID

$session = Get-RDMSession -Name "Session Name"
$session.Description = "Your note"
Set-RDMSession -Session $session

To retrieve all the properties of an entry, you can refer to https://help.remotedesktopmanager.com/pstipsandtricks.html

From RDM, you can also do an Edit > Custom Action > Custom PowerShell Command: https://help.remotedesktopmanager.com/powershell_batchactionssamples.html

As a side note, our team is currently working on a REST API using PowerShell, more features will be added soon. You can view it here: https://www.powershellgallery.com/packages/Devolutions.Server/

Best regards,

thanks Rickard, works great. any trick to adding credentials to the script so that I am not prompted every time the script is launched. I did not see a -credential parm on any of the commands.

Thanks
Ross

Hello Ross,

Great to hear.

For the credentials, you have to use this cmdlet: Set-RDMSessionCredentials

Set-RDMSessionCredentials -CredentialEntryID $(Get-RDMSession -Name "Credential Name").ID  -PSConnection $session

Best regards,