Sometimes, when adding new hosts to SCVMM, for unknown reasons, they end up being a mix of upper and lower case.
Theres a couple of descriptions around, about how to fix it with SQL scripts. It seems they only change the names in tbl_ADHC_Hosts table, not those in tbl_ADHC_AgentServer.
This code changes it for both. If you want it to change them all to lower, replace “UPPER” with “LOWER” 😉
Make sure you take a backup of VirtualManagerDB first.
Restart SCVMMService afterwards (A refresh in the console should be enough).
SELECT [ComputerName], UPPER(LEFT([ComputerName], CHARINDEX('.', [ComputerName], 1) -1)) + RIGHT([ComputerName], LEN([ComputerName]) - CHARINDEX('.', [ComputerName], 1) + 1) FROM [VirtualManagerDB].[dbo].[tbl_ADHC_Host] SELECT [ComputerName], UPPER(LEFT([ComputerName], CHARINDEX('.', [ComputerName], 1) -1)) + RIGHT([ComputerName], LEN([ComputerName]) - CHARINDEX('.', [ComputerName], 1) + 1) FROM [VirtualManagerDB].[dbo].[tbl_ADHC_AgentServer] UPDATE [VirtualManagerDB].[dbo].[tbl_ADHC_Host] SET [ComputerName] = UPPER(LEFT([ComputerName], CHARINDEX('.', [ComputerName], 1) -1)) + RIGHT([ComputerName], LEN([ComputerName]) - CHARINDEX('.', [ComputerName], 1) + 1) UPDATE [VirtualManagerDB].[dbo].[tbl_ADHC_AgentServer] SET [ComputerName] = UPPER(LEFT([ComputerName], CHARINDEX('.', [ComputerName], 1) -1)) + RIGHT([ComputerName], LEN([ComputerName]) - CHARINDEX('.', [ComputerName], 1) + 1)
Result :
Nice, thanks!