How to create a device collection for SCEP Active clients at risk

[shineknox]

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

[Peter33]

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