getTPMVersionStatus.sql

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