by kevin kaminski | Oct 19, 2015 | Blog, Forefront, SCCM
The status of the endpoint protection agent is stored in SMS_G_System_EPDeploymentState view but the key to the query is filtering on the DeploymentState field. The query below will return any machine that is not fully managed via Configuration Manager.select... 