Skip to content

Instantly share code, notes, and snippets.

@danjpadgett

danjpadgett/getTPMVersionStatus.sql

Created April 12, 2018 10:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danjpadgett/97070f764f4412064dcc6202dc8c3d4b to your computer and use it in GitHub Desktop.
Save danjpadgett/97070f764f4412064dcc6202dc8c3d4b to your computer and use it in GitHub Desktop.
Download ZIP
getTPMVersionStatus.sql
Raw
getTPMVersionStatus.sql
SELECT distinct CS.Manufacturer0 as 'Manufacturer',
CS.Model0 AS 'Model', CS.Name0 as 'Name', TPM.SpecVersion0 as 'SpecVersion',
TPM.IsActivated_InitialValue0 as 'IsActivated_InitialValue',
TPM.IsEnabled_InitialValue0 as 'IsEnabled_InitialValue',
TPM.IsOwned_InitialValue0 as 'IsOwned_InitialValue',
TPM.ResourceID,
OPSYS.Caption0 as 'OS',
OPSYS.CSDVersion0 as 'ServicePack',
GSBIOS.SMBIOSBIOSVersion0 as 'BIOS',
GSBIOS.SerialNumber0 as 'Serial No.'
FROM v_GS_COMPUTER_SYSTEM CS
left join v_R_System S on S.ResourceID=CS.ResourceID
left join v_GS_OPERATING_SYSTEM OPSYS on CS.ResourceID = OPSYS.ResourceID
left join v_GS_PC_BIOS GSBIOS on CS.ResourceID = GSBIOS.ResourceID
left join v_GS_TPM TPM on TPM.ResourceID=CS.ResourceID
Order by CS.Manufacturer0, Model, CS.Name0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment