?
Solved

SCCM Direct Membership Multiple Values

Posted on 2011-02-17
3
Medium Priority
?
3,698 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Recovering from what the press called "the largest-ever cyber-attack", IT departments worldwide are discussing ways to defend against this in the future. In this process, many people are looking for immediate actions while, instead, they need to tho…
Multi-threading long-running processes can have a significant increase in overall performance and drastically decrease over time it takes for a process to complete. Unfortunately, not all applications support native multi-threading, some by design a…
Viewers will learn the different options available in the Backstage view in Excel 2013.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

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