• Article

Sample Queries for Endpoint Protection in Configuration Manager

 

Updated: January 1, 2014

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

The following sample queries demonstrate how to join the most common Endpoint Protection views to other views.

Joining Endpoint Protection and Collection Views

The following query lists the deployment state of the Endpoint Protection client on all computers by using the v_GS_EPDeploymentState view. For each computer, it also adds the client name and site code by joining by ResourceID to the v_ClientCollectionMembers view.

SELECT   v_GS_EPDeploymentState_1.ResourceID, v_ClientCollectionMembers.Name, v_ClientCollectionMembers.SiteCode, 
                 v_GS_EPDeploymentState_1.LastMessageTime, v_GS_EPDeploymentState_1.DeploymentState, v_GS_EPDeploymentState_1.Error, 
                 v_GS_EPDeploymentState_1.ErrorCode
FROM    v_GS_EPDeploymentState AS v_GS_EPDeploymentState_1 INNER JOIN
        v_ClientCollectionMembers ON v_GS_EPDeploymentState_1.ResourceID = v_ClientCollectionMembers.ResourceID