SCEP Engine Version
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