SCEP Engine Version

  • 9 May 2017
  • Sean Huggans

This query will return a list of your workstations and the version of the SCEP engine last reported for each. It does not show workstations that have never reported SCEP data.

SELECT DISTINCT CInfo.Name0, SCEP.EngineVersion 
FROM [v_GS_AntimalwareHealthStatus] SCEP, [v_R_System] CInfo
WHERE CInfo.ResourceID = SCEP.ResourceID AND SCEP.EngineVersion<>''
Query Type: 
SQL Query