Solved

SCCM Direct Membership Multiple Values

Posted on 2011-02-17
3
3,453 Views
Last Modified: 2012-05-11
Extremely new with SCCM 2007, attempting to run a driver update to multiple computers.  However we are using an inventory list (Excel sheet) to determine the exact model.  I am wondering if there is a way to add multiple system resource (Resource class) name (Attribute name) values using the Direct Membership Rule Wizard?  From my experience it only allows me to enter one name or a wild card (%) however I am unable to determine the model number this way.
0
Comment
Question by:Conexus_IT
  • 2
3 Comments
 

Accepted Solution

by:
Conexus_IT earned 0 total points
ID: 34922554
I think I may have figured this out, it involves a query similar to this.

select *
from   SMS_R_System
where  SMS_R_System.Name in (
                             "Client1",
                             "Client2",
                             "Client3",
                             "Client4"
                            )

I just put the workstation names in the "_",
0
 
LVL 8

Expert Comment

by:Toxacon
ID: 34940868
You can do a direct rule like you did or you can do a dynamic collection based on inventory. For example, the computer model will usually be found on hardware inventory and the old driver has name xxxxx.dll and a version n.nn.nnn. You combine these three pieces of information with AND and you propably will get the required dynamic collection of computers of spcific model and old driver.
0
 

Author Closing Comment

by:Conexus_IT
ID: 35145561
It solved the issue however given my lack of SCCM knowledge was sufficient.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Email signature management is something that is often overlooked in many organizations or is simply not implemented effectively. Let's take a look at what methods are available for managing this important piece of corporate branding.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question