In Configuration Manager 2007, we were querying WIN32_TPM in hardware inventory for laptop security report. After the 2012 migration, the report was returning no value on this specific class. The usage of Bitlocker rely on TPM (Trusted Platform Module).
We found by looking in the SQL query of the report that IsActivated, IsEnabled and IsOwner were selected but missing from 2012 inventory. This is collected throught hardware inventory so I decided to take a look at the default client settings.
As you can see the screenshot below, WIN32_TPM class in hardware inventory is configured by default in Configuration Manager 2012 with missing information of the WMI class.
To remediate at this situation, delete and recreate the class with the same name or a new one in the default client settings by importing the following TPM MOF file.
class Win32_Tpm : SMS_Class_Template
[SMS_Report(TRUE), key] string SpecVersion;
[SMS_Report(TRUE)] string ManufacturerVersion;
[SMS_Report(TRUE)] string ManufacturerVersionInfo;
[SMS_Report(TRUE)] uint32 ManufacturerId;
[SMS_Report(TRUE)] string PhysicalPresenceVersionInfo;
[SMS_Report(TRUE)] string IsActivated_InitialValue;
[SMS_Report(TRUE)] string IsEnabled_InitialValue;
[SMS_Report(TRUE)] string IsOwned_InitialValue;
- Copy and paste the text above and save with .mof extension
- Go in your Configuration Manager 2012 console in the Administration panel
- Select Client Settings section and double click on Default Client Settings
- Choose Hardware Inventory in the left panel then click Set Classes
- Select the (TPM) Win32_TPM and delete
- Click on Import and select the MOF file you just created then Import
- Select all boxes and click OK and again OK
Wait for machine policy and hardware inventory cycle on each computers, then the data will reintegrate the database with the new methods.
You can verify if the data is part of the database with this SQL query.
SELECT ResourceID, IsActivated_InitialValue0, IsEnabled_InitialValue0, IsOwned_InitialValue0 FROM v_GS_TPM
Founder of System Center Dudes. Nick has been awarded in 2016 to 2019 as a Microsoft MVP in Enterprise Mobility category.
Working as a senior SCCM and Intune advisor as well as a specialist Microsoft Cloud solutions specialist.