PRUEBA AHORA

Trusted Platform Modules Audit

Hardware Hardware Components Security

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. Trusted Platform Modules

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

Show

Hide