counter customizable

Archive for the ‘Querys’ Category

SCEP Collection Query for clients with To be installed (2018-2-8)

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