shineknox 3 Posted August 25, 2016 Report post Posted August 25, 2016 I need to be able to create a device collection that I can target with a Task sequence. I need the collection to populate with "active clients at risk". How would one accomplish this? Thanks, Sunshine Quote Share this post Link to post Share on other sites
Peter33 47 Posted September 1, 2016 Report post Posted September 1, 2016 That should do it ... select * from SMS_R_System inner join SMS_G_System_EndpointProtectionStatus on SMS_G_System_EndpointProtectionStatus.ResourceId = SMS_R_System.ResourceId where SMS_G_System_EndpointProtectionStatus.AtRisk = 1 Quote Share this post Link to post Share on other sites
