Windows server 2012 shows as Windows 6.3 in WSUS console

Open SQL management studio.

Start a new query from SUSDB database and paste the below.

UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = ‘Windows Server 2012 R2 Standard’
WHERE [OSMajorVersion] = ‘6’
AND [OSMinorVersion] = ‘3’
AND [OldProductType] <> ‘1’
AND ([OSDescription] <> ‘Windows Server 2012 R2 Standard’ or [OSDescription] IS NULL)

Execute the above query and check the WSUS console. The OS would now show as Windows Server 2012 R2 Standard.

Extra Information :

Open SQL Management Studio – Expand SUSDB – Expand Tables – Right click ” dbo.tbcomputertargetdetail” and select edit top 200 rows to see the details of the table which we are going to update. In that check for OSMajorVersion=6 and OSMinorVersion=3 and build=9600. ie, that is windows server 2012 R2. If you go the end, you will find that the description is NULL. By executing the script, we are updating the OS description in the SQL table.

Execute the above query and check the wsus

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s