Jannes Alink - System Center Configuration Manager - Latest comments on Deploy ConfigMgr packages based on Active Directory Group Membership

In response to: Deploy ConfigMgr packages based on Active Directory Group Membership

Dan Ward [Visitor] — Fri, 29 Jan 2010 21:23:03 +0000

Excellent, well written, and a real boon to those like me who are SQL impaired.

Thank you for the assistance.

In response to: Deploy ConfigMgr packages based on Active Directory Group Membership

Jannes Alink [Member] — Wed, 03 Jun 2009 08:00:57 +0000

Post is updated with a query to select users from groups. Thanks Rayne.

In response to: Deploy ConfigMgr packages based on Active Directory Group Membership

sarah brightman [Visitor] — Sat, 23 May 2009 21:51:20 +0000

HI
looks very interesting!
bookmarked your blog.
good luck!
sarah brightman

In response to: Deploy ConfigMgr packages based on Active Directory Group Membership

Chris Weatherford [Visitor] — Tue, 06 Jan 2009 20:22:51 +0000

Quick question, I am having some issues with this. I setup an AD group inside of an OU. Now I'm trying to setup this collection but I can't pull in this group when I use these settings.

select SMS_R_SYSTEM.Name from SMS_R_System where SMS_R_System.SystemGroupName = "MyDomain\\MicrosoftOffice2007"

I looked under the 'All Active Directory Security Groups' collection and found the "MyDomain\MicrosoftOffice2007" security group. I looked at the properties of this group but it has a User Group Name not a System Group Name. I was able to query the User Group Name and then it shows up but it doesn't show all the systems in the group.

select * from SMS_R_UserGroup where SMS_R_UserGroup.UsergroupName = "MyDomain\\MicrosoftOffice2007"

Is there something I need to do in AD to make a security group as apposed to a user group?

In response to: Deploy ConfigMgr packages based on Active Directory Group Membership

Pete [Visitor] — Wed, 17 Dec 2008 01:02:56 +0000

Nice summary and just what I was looking for;)