?
Solved

SCCM 2007 collections

Posted on 2012-03-27
1
Medium Priority
?
378 Views
Last Modified: 2012-06-21
Hi,

I have been trying to create a new collection and have created a secruity group in AD and added a conmputer to it. I have also created a new collection and added a new query liek below:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.SystemGroupName = "domain\\Group Name"

I have truned on Active directory discovery methods but my collection still does not show my one computer in the collection. Any idea what i am missing?
0
Comment
Question by:monarchit
[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
1 Comment
 
LVL 4

Accepted Solution

by:
Grasty86 earned 1500 total points
ID: 37772420
I dont personally know the sql command to get it to work. But if you go to add a new Query ... Click the Edit Query button and switch to the Criteria Tab.

Click New (The yellow star)

Criterion Type: Simple Value

Click Select under Where

Attribute Class: System Resource
Allias as: <No Alias>
Attribute: System Group Name

Operator: is equal to

Click the Value button and choose the security group you are looking for.

That worked for me, but we dont have any Collections that we created using security groups. All of ours were created off of AD OUs
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

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

In the hope of saving someone else's sanity... About a year ago we bought a Cisco 1921 router with two ADSL/VDSL EHWIC cards to load balance local network traffic over the two broadband lines we have, but we couldn't get the routing to work consi…
Quality of Service (QoS) options are nearly endless when it comes to networks today. This article is merely one example of how it can be handled in a hub-n-spoke design using a 3-tier configuration.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

764 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