This is purely a cosmetic annoyance. If you’re looking at your 8.1 \/ 2012 R2 machines in your WSUS console and they’re showing up as the Windows version number (6.x) instead of the branded name, there is a quick fix for this. It does involve a little command line work, and as always, you should take a snapshot\/backup of your environment before attempting.<\/p>\n
If you’ve installed WSUS using the Server Role option, it’ll most likely be installed using the Windows Internal Database (WID) rather than a full blown SQL instance. WID uses the sqlcmd.exe command for any manual database alterations.<\/p>\n
Default location is: <Local SQL installation path>\\<SQL instance>\\Tools\\Binn\\<\/p>\n
You will then need to write a small script to alter the version number to match the branded version of Windows.<\/p>\n
(For Windows 8.1)<\/p>\n
UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]\r\nSET [OSDescription] = 'Windows 8.1'\r\nWHERE [OSMajorVersion] = '6'\r\nAND [OSMinorVersion] = '3'\r\nAND [OldProductType] = '1'\r\nAND ([OSDescription] <> 'Windows 8.1' or [OSDescription] IS NULL)<\/pre>\n(For Windows 2012 R2)<\/p>\n
UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]\r\nSET [OSDescription] = 'Windows Server 2012 R2'\r\nWHERE [OSMajorVersion] = '6'\r\nAND [OSMinorVersion] = '3'\r\nAND [OldProductType] <> '1'\r\nAND ([OSDescription] <> 'Windows Server 2012 R2' or [OSDescription] IS NULL)<\/pre>\nSave these as separately named\u00a0.sql files. You’ll now need to execute the queries.<\/p>\n
Using the above default location, in a command prompt as an administrator:<\/p>\n
<Local SQL installation path>\\<SQL instance>\\Tools\\Binn\\sqlcmd -S \\\\.\\pipe\\MICROSOFT##WID\\tsql\\query -i c:\\temp\\verrename1.sql<\/pre>\nwhere c:\\temp is where I have placed the .sql files.<\/p>\n
You should see rows affected, that match the number of 8.1 \/ R2 machines you have.<\/p>\n
WSUS should now report the machines as Windows branded machines, rather than their OS version.<\/p>\n
Note: <\/strong>This will update the existing items. Any new machines that appear after this has been done will need to have the query re-run for them to appear as 8.1 \/ 2012R2<\/p>\n","protected":false},"excerpt":{"rendered":"
This is purely a cosmetic annoyance. If you’re looking at your 8.1 \/ 2012 R2 machines in your WSUS console and they’re showing up as the Windows version number (6.x) instead of the branded name, there is a quick fix for this. It does involve a little command line work,… Continue reading