Device Collection for Group Membership
Today you can easily create a user collection based on AD Group where the collection has a direct membership for the group. However, this is not true for computers where you cannot add a group to a device collection.
This should be possible as many organizations also create group for computers and having to look for each membership causes a performance issue when you have many groups/group membership
Jose Espitia commented
Second this. It would be helpful if we could create device collections with direct memberships to AD groups. This would get around having to create a query which can take some time to replicate.
Jimmy Butcher commented
This is already possible for AD Groups populated with Computers as members.
Try this query:
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 = "<YourDomain>\\<YourGroupName>"