forums.wsusoffline.net

Hello,

I just wondered, how WSUS makes a difference between Windows 8 and Windows 2012.

On DB-Level, there is tbOSMap. But there is no record of Win 8 or similar.

In tbComputerTargetDetail I can see the os-Version in columns OSMajorVersion, OSMinorVersion, OSBuildNumber, etc. But these are all the same for the mentioned systems.

Only hints I could find were the colums Suitmask, OldProductType, NewProductType.


I want to build my own SQL-Statements for reports.

Can anyone help?

Hi.

You can do this by

Code: Select all

cscript %SystemRoot%\System32\slmgr.vbs -dli


and by evaluating Win32_ComputerSystem.DomainRole, of course.

Regards
T. Wittrock

But cant I find these information in the database?

In which database?

SUSDB in SQL-Server

Oh, Microsoft WSUS Server is not the same as this project.

But anyway, there's no need to differ between Windows 8 and Server 2012, for example, because both have the same kernel (v. 6.2).
If necessarry, the client will report the correct OS Version to the WSUS Server, of course.

RTW

Correct OS can be retrieved using WMIC.

Code: Select all

wmic os get Name

Example Server 2012:

Klick on it as embedding doesn't seem to work.