Find Trusted Platform Details from Computers in Your Network
Check which computers have hardware-based encryption capabilities. This report provides detailed information about the trusted platform module on computers in your environment like version and status. Check which devices support the hardware-based, security-related functions that the TPM chip provides. Find which devices might require an update in order to support hardware-based encryption.
Click to Open - Computer Trusted Platform Modules Query
Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon, tblAssets.AssetID, tblAssets.AssetName, tblTPM.SpecVersion, tblTPM.ManufacturerVersion, tblTPM.ManufacturerVersionInfo, Case When tblTPM.IsActivated_InitialValue = 1 Then 'Yes' Else 'No' End As Activated, Case When tblTPM.IsEnabled_InitialValue = 1 Then 'Yes' Else 'No' End As Enabled, Case When tblTPM.IsOwned_InitialValue = 1 Then 'Yes' Else 'No' End As Owned, tblTPM.PhysicalPresenceVersionInfo, tblAssets.Domain, tblAssets.Username, tblAssets.Userdomain, tblAssets.IPAddress, tblAssets.Description, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Location, tsysIPLocations.IPLocation, tsysOS.OSname As OS, tblAssets.SP As SP, tblAssets.Firstseen, tblAssets.Lastseen From tblTPM Inner Join tblAssets On tblTPM.AssetId = tblAssets.AssetID Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode