feedback requested on best method to insert sql query into existing collections (Full Version)

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003



Message

sswacus -> feedback requested on best method to insert sql query into existing collections (9/24/2008 11:17:23 AM)

I have a great many collections based on application names.  Right now they are populated with an AD user group for distribution.  We'd like to switch over eventually to doing machines in the ad group.  not a big deal except that you also need to add a query membership rule using the system.group property instead of user.group for SMS to find the machines.

I'd like to figure out an approach that is time efficient to figure out the name of the user group that is currently in the collection and add an additional query rule to look for the system.group property of that same group name.  So the end result would be a collection that searches for both users and machines in the same AD group.

Additionally, this would more than likely need to be run against a list of the collection node names instead of thier friendly name in order to avoid adding to the wrong collection.

I found a tool http://www.smsutils.com/CommunityDownloads/tabid/58/Default.aspx but couldn't figure out how to get it to work correctly.

Thank in advance.




rbennett806 -> RE: feedback requested on best method to insert sql query into existing collections (9/26/2008 10:22:45 AM)

Okay, so if I understood your post...Can't you just add a second membership query rule and use something like the following 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 SystemGroupName = 'DOMAIN\\DomainGroupName'

Assuming your first one gets you your users, then this second one will get the computers in the Active Directory domain group. Of course, I could have misunderstood your post...



sswacus -> RE: feedback requested on best method to insert sql query into existing collections (9/26/2008 10:33:11 AM)

that is the intent.  However with the large amount of collections that I need to update I was looking for some scripted way to figure out the name of the user group and add the system.group rule.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.40625