WSUS SQL Tables - OS txt Version?
Posted on 2011-04-21
I'm peering into our WSUS 3.0 SQL tables to get some information. In this information, I need to separate the units that are reporting into WSUS by Operating System.
I see that in the PUBLIC_VIEWS_vComputerTarget, it has the following fields:
OSMajorVersion (2 Digit)
OSMinorVersion (2 Digit)
OSBuildNumber (4 Digit)
OSServicePackMajorNumber (2 Digit)
If possible, I need to join those values with their text based counterparts. (ie OS Build "2195" = Windows Server 2000).
Would somebody know which table I can link up to, in order to grab that info?
Thanks for any assistance that can be provided.