Good morning folks.
I have approx. 1300 entries in my current SQLite DB.
I use A/D Sync to import all the entries. Some are UPPERCASE, and some are lowercase.
In RDM, as you know, pulls in the information "as-is" from the A/D Domain Controller.
I have ran the following command in and external SQLite Editor:
UPDATE Connections SET name = UPPER( name ) WHERE 1=1;
I see in the actual SQLite DB that it made the changes as requested, but within RDM, the Entries still show as they were.
I have deleted and re-setup the DataSource I was using and still no change.
Is there a different way to achieve what I am looking for?
Thanks!
--- Chuck
Overgaard, AZ (-7 MST / Zulu Year-Round)
RDM Version: 2025.3.11.0 64-Bit - MSSQL - Daily Usage
RDM Version: 2025.2.28.0 64-Bit - MSSQL - VM
Hello,
Thank you for reaching out to us regarding this,
There would be no way to perform this within RDM directly,
I will need to discuss this with my colleagues to see if it could be done using PowerShell,
I will keep you updated with any news I receive,
Best regards,
Samuel Dery
Hello Chuck,
Thank you for your patience,
I'm not sure if you're familiar with the PowerShell Module in RDM?
https://docs.devolutions.net/rdm/powershell-scripting/powershell-module/
I've made the following script which will perform the change on all RDP entries:
$session = Get-RDMSession -Type RDPConfigured
foreach ($sess in $session) {
$sess.Name = $sess.Name.Substring(0,1).ToUpper() + $sess.Name.Substring(1)
Set-RDMSession $sess -Refresh
}
I would recommend you create a backup of your entries just in case but from testing on my end, it worked as expected.
Let me know if you need additional guidances regarding this,
Best regards,
Samuel Dery
Hello Chuck,
Thank you for your patience,
I'm not sure if you're familiar with the PowerShell Module in RDM?
https://docs.devolutions.net/rdm/powershell-scripting/powershell-module/
I've made the following script which will perform the change on all RDP entries:
$session = Get-RDMSession -Type RDPConfigured
foreach ($sess in $session) {
$sess.Name = $sess.Name.Substring(0,1).ToUpper() + $sess.Name.Substring(1)
Set-RDMSession $sess -Refresh
}
I would recommend you create a backup of your entries just in case but from testing on my end, it worked as expected.
Let me know if you need additional guidances regarding this,
Best regards,
I have tried running this within RDM, as well as within VS Code.
I don't see any errors that appear, as the command takes about 30 seconds to run, then just goes back to a command prompt.
In both, I see no changes, so I apologize for my stupidity.
--- Chuck
Overgaard, AZ (-7 MST / Zulu Year-Round)
RDM Version: 2025.3.11.0 64-Bit - MSSQL - Daily Usage
RDM Version: 2025.2.28.0 64-Bit - MSSQL - VM
Hello Chuck,
Thank you for your reply,
No problem at all, If I remember correctly, we have a session together next week for another issue, would it be okay with you if we address this also during the session?
Let me know,
Best regards,
Samuel Dery
Hello Chuck,
Thank you for your reply,
No problem at all, If I remember correctly, we have a session together next week for another issue, would it be okay with you if we address this also during the session?
Let me know,
Best regards,
That would be awesome, sir if you do not mind and it doesn't take long.
I will chat with you Wednesday during our call.
--- Chuck
Overgaard, AZ (-7 MST / Zulu Year-Round)
RDM Version: 2025.3.11.0 64-Bit - MSSQL - Daily Usage
RDM Version: 2025.2.28.0 64-Bit - MSSQL - VM
Hello Chuck,
Thank you for your reply,
Perfect, we will discuss this then!
Best regards,
Samuel Dery
Hello Chuck,
Thank you for your patience,
As we discussed I've made some changes to the script so that it changes the full name to capital letters.
$session = Get-RDMSession -Type RDPConfigured
foreach ($sess in $session) {
$sess.Name = $sess.Name.ToUpper()
Set-RDMSession $sess -Refresh
}
Here is a screenshot in PowerShell for the formating:
I would recommend you create a backup of your data just in case but it seems to work without issues on my end.
Best regards,
Samuel Dery
e57c46de-01ad-406b-a695-8b7902b11e65.png
Worked like a champ, sir!
Did exactly what I was looking for.
Feel free to mark this topic resolved!
Thank you for the continuous quick support!
--- Chuck
Overgaard, AZ (-7 MST / Zulu Year-Round)
RDM Version: 2025.3.11.0 64-Bit - MSSQL - Daily Usage
RDM Version: 2025.2.28.0 64-Bit - MSSQL - VM
Hello Chuck,
Thank you for your reply,
Perfect, glad to hear this works!
Best regards,
Samuel Dery