Skip to Main Content
Status Already exists
Product Area Right Click Tools
Categories Insights
Created by Gregory Burton
Created on Mar 24, 2026

Application Insights report request: TPM manufacturer version

We want to find the TPM Manufacturer ID & Version for every computer, because a security program we're deploying requires a minimum version number.

Recast Application Insights almost does this. It gets the TPM version, which is generally "2.0". It does not get the TPM Manufacturer Version, which is wildly different and the numbering varies by Manufacturer ID.

PowerShell command "Get-TPM" tells you this and I'm working on a script that we could run at scale, outputting into a shared csv, but it's tricky.

I have attached a spreadsheet with some example date, written by hand, showing what we want to report on. It would be better if we could report on this out of REI reports in SSRS.

  • Attach files
  • Gregory Burton
    Mar 30, 2026

    Got a reply from Garth in Recast. MCM is collecting this in our Client Settings > Hardware Inventory. We should be able to get ManufacturerVersion in a report, I don't see where yet, but Garth has a SQL query suitable to run against the MCM database as a workaround:

    Select

    RV.Netbios_Name0,

    TPM.ManufacturerId0,

    TPM.ManufacturerVersion0,

    TPM.ManufacturerVersionInfo0,

    TPM.IsActivated_InitialValue0,

    TPM.IsEnabled_InitialValue0,

    TPM.IsOwned_InitialValue0,

    TPM.PhysicalPresenceVersionInfo0,

    TPM.SpecVersion0

    from

    dbo.v_R_System_Valid RV

    join dbo.v_GS_TPM TPM on RV.ResourceID = TPM.ResourceID