Solved

SCCM Direct Membership Multiple Values

Posted on 2011-02-17
3
3,405 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

How can you create a game plan that lets you focus on special projects instead of running from cubicle to cubicle every day and feeling like you’ve accomplished nothing? Try these strategies for prioritizing your tasks, offloading what you can, and …
Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

914 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now