Solved

SCCM Direct Membership Multiple Values

Posted on 2011-02-17
3
3,618 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

This article was originally published on Monitis Blog, you can check it here .   Some years back, I worked as the CTO.  During my tenure, I had a head of IT support reporting to me.  He did his job quite well and had a commendable sense of duty …
We asked our MSP customer base what their favorite tools were and how they help them serve clients. We focused our questions on favorite tools in the following categories: >PSA tools >RMM tools >Alert management tools >Communication tools and Mo…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.

729 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