usslindstrom
asked on
WSUS SQL Tables - OS txt Version?
Experts,
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_vComputerTarg et, 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.
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_vComputerTarg
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Much appreciated.