Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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