counter customizable

SCEP Collection Query for clients with To be installed

This is a Query that list all clients that has SCEP status “To be installed”

 

select distinct vrs.ResourceId, vrs.ResourceType, vrs.Name, vrs.SMSUniqueIdentifier, vrs.ResourceDomainORWorkgroup, vrs.Client fromĀ  SMS_R_System as vrs inner join SMS_G_System_EPDeploymentState as EPDS on EPDS.ResourceID = vrs.ResourceId inner join SMS_G_System_EndpointProtectionStatus as EPS on EPS.ResourceID = vrs.ResourceId where EPDS.DeploymentState = 2 and EPS.NotYetInstalled = 1

 

Mikael Karlsson posted at 2018-2-8 Category: Querys, SCCM