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.

Query: 
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