Solved

SCCM 2007 collections

Posted on 2012-03-27
1
343 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
1 Comment
 
LVL 4

Accepted Solution

by:
Grasty86 earned 500 total points
Comment Utility
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

There are two basic ways to configure a static route for Cisco IOS devices. I've written this article to highlight a case study comparing the configuration of a static route using the next-hop IP and the configuration of a static route using an outg…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

763 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

13 Experts available now in Live!

Get 1:1 Help Now