Windows 10 on WSUS Shows as Windows Vista

Update: 15/10/2015
Please see below comment from Michael regarding Hotfix 3095113 which resolves this issue.
I noticed a thread on a forum regarding Windows 10 reporting to WSUS as Windows Vista. This was a problem if you recall for Windows 8 and Server 2012 simply reporting as Windows 6.3 or similar.

Since WSUS received no updates that i was aware of to fix that issue at the time, i found a SQL Command here that updated the WSUS DB to reflect the correct OS name.

Revisiting that now, It was easy enough to modify this to have WSUS report a Windows 10 machine, as Windows 10!

Granted, at this point it only appears that this is a useful workaround – not a permanent fix! (updated 05/08/2015)


The changes you need to add to the SQL cmd file are:

Windows 10 WSUS SQL Cmd

UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 10'
WHERE [OSMajorVersion] = '10'
AND [OSMinorVersion] = '0'
AND [OldProductType] = '1'
AND ([OSDescription] <> 'Windows 10' or [OSDescription] IS NULL)

Save this as part of your WSUS Maintenance Script, and run it.

Just a note on that, if you are running WSUS on Server 2012 or newer you will find your WSUS Database is at..




that you may have used before.

When you go back into your WSUS Console you will see your machine now reflects the correct OS.

windows 10 WSUS

This has worked for me on the current build my Windows 10 lab machine is running on (Pro Insider Preview 1062) but i reserve the right to look silly if this does not work as expected on the full release version due in an excitingly imminent 7 days!

Whilst we are on the subject of WSUS maintenance, you did know about Invoke-WSUSServerCleanup didn’t you?

This allows you to run the Clean up wizard from PowerShell and better, means you can schedule it to run!

About Robert Pearman
Robert Pearman is a UK based Small Business Server enthusiast. He has been working within the SMB IT Industry for what feels like forever. Robert likes Piña colada and taking walks in the rain, on occasion he also enjoys writing about Small Business Technology like Windows Server Essentials or more recently writing PowerShell Scripts. If you're in trouble, and you can find him, maybe you can ask him a question.

47 Responses to Windows 10 on WSUS Shows as Windows Vista

  1. Simon Weel says:

    Script won’t run – there’s no database instance called MICROSOFT##SSEE?

  2. Simon Weel says:

    Figured it out – the SUSDB is stored under . Just specify and the script runs fine.
    Now for ‘Invoke-WSUSServerCleanup’, didn’t know about that so I dug into it. But it seems the cmdlets are not available on Windows Server 2008 r2?

  3. John Murdoch says:

    Hi Rob

    There’s a typo in the script – the second last line should read

    AND [OldProductType] = ‘1’

    so that it picks up the desktop OS


  4. Pascal says:

    How to start/use the script?! sqlcmd?

  5. akismet-5ff276dd0d46accd74f84a6d1606d4a7 says:

    Can’t get this to work with my WSUS 3.0 SP2 install. The original script for 8.1 coming from 6.3 works, but when I copy the command I get an error stating

    ALTER INDEX failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’. Verify that SET options are correct for use with index views and/or indexindex on computed columns and/or query notifcations and/or xml data typemethods.
    MSG 102, Level 15, State 1, Server SERVERNAME, Line 13 Incorrect syntax near ‘OSDescription’.

    any ideas?

  6. What about when using WID for WSUS???

  7. What about servers running WID? I’m running a stand alone for just WSUS and WDS, and all my Windows 10 Machines show as Windows Vista on Server 2012r2. Any fix for that, as I don’t want to migrate to SQL due to not wanting to add other resources to the system

  8. Chris says:

    Script worked first (Client appeared as “Windows 10” in WSUS), but never gets updates. WSUS Cleanup Wizard started and rebootet after finishing. Client rebootet. Appears now again as “Windows Vista” :(
    Server OS is 2012R2.
    Seems there have to be done more…

  9. Chris says:

    Thanks for your work!

  10. Adam says:

    While this is a good workaround, I wouldn’t dare acknowledge this as a “fix”. Any time frame to address this issue in WSUS?

  11. Chris says:

    Microsoft released KB3075853 today. Has something to do with WU-Agent, see
    Approved it to my WSUS and rebootet…Client still appears as Vista :(
    Kicked the Client from the WSUS Computergroup. Did wuauclt.exe /detectnow and wuauclt.exe /reportnow until my fingers bleed to force the client to re-appear in WSUS. It does not :(
    I think there is nothing to be done until MS pulls the brown ring from the finger…what a shame…

  12. Chris says:

    Update: Client re-appaered in WSUS after rebooting client. Take a *very* long time. Again, its called Vista :(

  13. Chris says:

    Update: Client got really Updates for W10 today from WSUS, despite it´s shown as Vista. So it´s really only a cosmetic bug…sit back, stretch your sack and wait for a fix from MS…

    • Hey Chris,

      Interesting news!

      On my WSUS system I am seeing new registered Windows 10 clients show as Vista, until I run the ‘fix’, they then retain Windows 10 status. I am starting to wonder if it is actually something in the configuration for Windows Vista Clients that is making 10 show this way.

      In any case, I suspect you are correct – waiting for MS is always the better idea… we just never know when they may get around to it.

  14. bitzie says:

    There won’t be a fix from MS as they never fixed how 8.1 showed up in the console either.

    • Simon says:

      They did. Did you try KB2938066 to install on the console system?

      • Chris says:

        Is/was already installed on my WSUS. W10 Client still seen as Vista :(

      • Quintin says:

        That update only refers to the issue with Windows 8/8/1 (I guess MS will address 10 in the same fashion eventually). Also, needs to be installed on the SERVER, and any machines that have the CONSOLE installed.

  15. Nic says:

    I am still not receiving any KBs related to Windows 10 on my WSUSes. Is there anything specific I need to do? Many thanks.

  16. Michael says:

    Microsoft has released a hotfix for Windows 2012 and 2012 R2 that will enable support for Windows 10 Feature upgrades. This hotfix also corrects the Windows 10/Vista issue as well as the Windows 8.1 as Windows 6.3 display.

    • Hassan Nasir says:


      I have Windows 2008 R2 (WSUS server downstream server), Windows 10 client shows as Vista. Is there any update to display Windows 10 correctly?

      Patches already installed;

  17. Diane Burns says:

    Thanks Rob & Michael, I’ve just installed the hotfix Fix4511610 from Michael’s link above on my new WSUS server (2012 R2) and the Windows 10 clients are now showing as Windows (version 10.0)

  18. Mark Blinkhorn says:

    Rob, Michael; Hotfix4511610 is for Server 2012 R2. Does anyone want to venture an opinion on whether it *might* work for 2008 R2?
    (long shot, I know…)

    • I’ll venture, never.

    • Michael says:

      No, it does not work for WSUS 3.2 running on Windows 2008 R2 and unfortunately, I am not able to find any information indicating that Microsoft will put out a hotfix. However, I will say that Windows 10 updates are available and Windows 10 workstations do get the updates successfully… so it appears to be mostly a cosmetic issue with how the OS is displayed.

  19. Tom says:

    what´s about the Hotfix for Win Server 2008R2 ? Any News ?

  20. victor says:

    worked like a charm on my windows 2008 standard, thank you! Was weird to see windows 10 beeing shown as win vista lol

  21. yggdrasil42 says:

    Great! Thanks.

  22. Just a suggestion…. Updating the Query to use the SuiteMask allows you to more consistently address how Microsoft displayed older OSes Like XP, Vista, 7, etc.. It’s totally cosmetic, but, here it is.

    UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
    SET [OSDescription] = ‘Windows 10 Professional’
    WHERE [OSMajorVersion] = ’10’
    AND [OSMinorVersion] = ‘0’
    AND [OldProductType] = ‘1’
    AND [SuiteMask] = 256
    AND ([OSDescription] ‘Windows 10 Professional’ or [OSDescription] IS NULL)

    –not 100% tested for Win10 Home as I only own Professional.. It’s possible there’s a Basic, Starter, etc Editions as well

    UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
    SET [OSDescription] = ‘Windows 10 Home’
    WHERE [OSMajorVersion] = ’10’
    AND [OSMinorVersion] = ‘0’
    AND [OldProductType] = ‘1’
    AND [SuiteMask] = 512
    AND ([OSDescription] ‘Windows 10 Home’ or [OSDescription] IS NULL)

    And, as noted by other comments, Microsoft is suggesting you move to Server 2012 or higher since they are deprecating WSUS 3, and not adding full Win10 support to WSUS 3. :(

    It’s kind of stupid since they have an OSMap table that they didn’t just use that for the OS mappings, but there are other changes in WSUS that pretty much force you to upgrade to Server2012+ for WSUS. Oh Well.


Leave a reply

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

You are commenting using your 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

%d bloggers like this: