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.
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
