Difference of OSs on DB-Level

[wehlingwsus]

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?

[WSUSUpdateAdmin]

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

[wehlingwsus]

But cant I find these information in the database?

[WSUSUpdateAdmin]

In which database?

[wehlingwsus]

SUSDB in SQL-Server

[WSUSUpdateAdmin]

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

[boco]

Correct OS can be retrieved using WMIC.

Code: Select all

wmic os get Name

Example Server 2012:

2014-06-27 20_59_22-Windows Server 2012 R2 x64 DC - VMware Player (Non-commercial use only).png

(5.99 KiB) Not downloaded yet

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