TPM Version

[delders]

Does anyone have a report or how do I make a report to show me the version of TPM on a workstation?

Thanks in advance for any help.

[Nick_VDB · Accepted solution]

You can use the report below to get back the TPM information that is scanned by Lansweeper. TPM information is stored in the tblTPM table.

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblTPM.SpecVersion As [TPM Spec Version],
  tblTPM.ManufacturerVersion As [TPM Manufacturer Version],
  tblTPM.ManufacturerVersionInfo As [TPM Manufacturer Version Information],
  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,
  tblTPM.LastChanged
From tblTPM
  Inner Join tblAssets On tblTPM.AssetId = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType