Distributing software to select users

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Distributing software to select users

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Distributing software to select users

Page: [1]

Message

<< Older Topic Newer Topic >>

Distributing software to select users - 8/14/2008 11:09:51 AM

jfarber

Posts: 1
Score: 0
Joined: 8/14/2008
Status: offline

We are planning on rolling out Office 2007 Standard and Professional soon by department (finance, HR, IT, etc). We have over 50 SMS sites and users in the groups could be anywhere. I want to use AD group membership to determine when that group will be Office 2007. That's easy, what's not is determining was group the user is in and whether the user should get Standard or Professional. I have tried by creating a collection called "Office 2007 upgade" with 2 sub-collections called "Standard" and "Pro". "Office 2007 upgrade" membership is based on AD group membership and I have "Standard" and "Pro" limit their search to just "Office 2007 Upgrade". They then look whether Office Pro or Standard is installed with a query. The problem is one query is a system resource and the other is a user and I can't seem to tie them together. I figure I can't be the only one to try this.

Any ideas?
Thanks for the help in advance.

Post #: 1

RE: Distributing software to select users - 8/14/2008 11:48:36 AM

skissinger

Posts: 2114
Score: 134
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

I do something similar, but I use SLAT. I haven't ever tried to create the queries using ConsoleUser data. But if it interests you, here's a collection query to target 'resourceids where the highest ranked user according to SLAT is in the group "whatever" in ActiveDirectory'

select SMS_R_SYSTEM.ResourceID
from SMS_R_System
inner join SMS_G_System_MCS_USERLOGONINFO_1_0 on SMS_G_System_MCS_USERLOGONINFO_1_0.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_MCS_USERLOGONINFO_1_0.UserName in (select UserName from SMS_R_User where UserGroupName = "MYDOMAIN\\whatever") and SMS_G_System_MCS_USERLOGONINFO_1_0.UserRank = 1

SLAT = Security Login Audit Tool. What we had before Console User in SMS2003 SP3. systemcentertools.com

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to jfarber)

Post #: 2

RE: Distributing software to select users - 8/14/2008 11:51:19 AM

pwstrain

Posts: 121
Score: 9
Joined: 3/11/2007
From: Danville, Illinois
Status: offline

We have "standing collections' for major AD groups (One for HR, one for IT, etc). These map userid's to machine names. In your situation I would just create two sub-collections from an AD collection and limit thier scope to that parent collection (one for Pro, one for Standard).

_____________________________

My Personal Blog
My Technical Blog

(in reply to jfarber)

Post #: 3