Solved

SCCM Direct Membership Multiple Values

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Both MMF (multi-mode fiber) and SMF (single-mode fiber) are types of optical fiber that can aid in communication applications. These thin strands of silica or glass will allow communication to occur between devices. The transmission of light between…
You may have a outside contractor who comes in once a week or seasonal to do some work in your office but you only want to give him access to the programs and files he needs and keep privet all other documents and programs, can you do this on a loca…
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…
Viewers will learn the different options available in the Backstage view in Excel 2013.

828 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