Sample Queries for Endpoint Protection in Configuration Manager

Oppdatert: januar 2014

Gjelder for: 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.

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, 
FROM    v_GS_EPDeploymentState AS v_GS_EPDeploymentState_1 INNER JOIN
        v_ClientCollectionMembers ON v_GS_EPDeploymentState_1.ResourceID = v_ClientCollectionMembers.ResourceID

Se også

For additional resources, see Information and Support for Configuration Manager.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012 Configuration Manager. For instructions and examples, see Search the Configuration Manager Documentation Library.