Deploy ConfigMgr packages based on Active Directory Group Membership

When your group contains computer / system objects, use the following query for the collection:
select SMS_R_SYSTEM.Name from SMS_R_System where SMS_R_System.SystemGroupName = "yourdomain\\Microsoft Office 2007"

When your group contains user objects, use the following query for the collection:
“select * from sms_r_user where sms_r_user.usergroupname = "yourdomain\\Microsoft Office 2007"