Good morning,

We have a security group that contains computers & users. I want to build a 
collection of computers based on this group. I set up the query below, but the 
collection does not show all the computers in the security group (4 out of 24). 
All the computers have clients and are active. Any ideas?

select 
SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client
 from SMS_R_System where SMS_R_System.SecurityGroupName = "DOMAIN\\Security 
Group"


Best Regards,

Mike Murray
Desktop Management Coordinator - IT Support Services
California State University, Chico
530.898.4357
[email protected]<mailto:[email protected]>




Reply via email to