myITforum.com Community Forum 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:


  


feedback requested on best method to insert sql query into existing collections

 
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 >> feedback requested on best method to insert sql query into existing collections Page: [1]
Login
Message << Older Topic   Newer Topic >>
feedback requested on best method to insert sql query i... - 9/24/2008 11:17:23 AM   
sswacus

 

Posts: 103
Score: 0
Joined: 6/14/2002
From: Chicago IL
Status: offline 		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.

Post #: 1
RE: feedback requested on best method to insert sql que... - 9/26/2008 10:22:45 AM   
rbennett806


Posts: 827
Score: 13
Joined: 6/14/2006
Status: offline 		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...

(in reply to sswacus)
Post #: 2
RE: feedback requested on best method to insert sql que... - 9/26/2008 10:33:11 AM   
sswacus

 

Posts: 103
Score: 0
Joined: 6/14/2002
From: Chicago IL
Status: offline 		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.

(in reply to rbennett806)
Post #: 3
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> feedback requested on best method to insert sql query into existing collections Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.203