Open SQL management studio.
Start a new query from SUSDB database and paste the below.
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