lowering the servernames in a mysql database

lowering the servernames in a mysql database

avatar
charles.e.harris

This is purely a cosmetic thing for my group, but we would like to see if there is a sql script that we could run against our MySql backend databse that will lower case the name and computer entries so that they all appear as lower case?

Is there sql script out there for RDM to do this?

All Comments (1)

avatar
Maurice Côté

Hello,

Since the internal structure of the entries is a XML field, its a bit complex unless you are really comfortable with SQL.

I would think that PowerShell would be much easier.

We have a forum dedicated to Powershell : https://forum.devolutions.net/forum42-remote-desktop-manager--powershell-repository.aspx

So based on https://forum.devolutions.net/topic18904-how-to-programatically-change-group-fiolder-properties-and-session-properties.aspx#post72155, you remove the two lines that assign values and add this instead.

$session.Name = $session.Name.ToLower();
The example script is for RDP Sessions, what types do you want to handle?
This also would just handle the Name field, is this sufficient?

Best regards,

Maurice