The WMI class SMS_SupportedPlatforms is created and populated when you install SMS. It is “Read Only” in that you cannot add or remove from it.
The only way to add or remove from this class is when SMS itself modifies it. When a new Pdf is processed on the site systems and it contains a platform not found in the existing SMS_SupportedPlatforms table that information is added to the WMI class instance.
The query below can be executed from SQL 2000 or SQL 2005 with either SMS 2.0 or SMS 2003 installed.
SQL Query:
Select
OsPlatform Architecture,
OsName 'Operating System',
DisplayText Version,
'OsMinVersion' = Case
When OsMinVersion = '0.00.0000.0' Then 'All Previous Versions'
Else OsMinVersion
End,
'OsMaxVersion' = Case
When OsMaxVersion = '99.99.9999.9999' Then 'All Future Versions'
Else OsMaxVersion
End
From SupportedPlatforms
Where OsMinVersion <> '0'
No Comments