Solved

SCCM 2007 Active Directory Collection

Posted on 2013-06-17
6
551 Views
Last Modified: 2013-06-18
Hi,
Just looking at SCCM 2007 for a client and stuggling to get my head around Active Directory collection deployment.  Is there a straight forward way of creating an OU group and getting it to collect an advertisement?

Many thanks,

Kerj
0
Comment
Question by:Emanuel
  • 3
  • 3
6 Comments
 
LVL 23

Expert Comment

by:Nagendra Pratap Singh
ID: 39254036
Sure

=============
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 inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.UserName in (select UniqueUserName from SMS_R_User where UserOUName = "xxxx /SECURITY USERS & GROUPS” )


http://www.sccm-tools.com/tools/WQLQueries/WQLQueries-CompCollectionofusrs.html

================
0
 

Author Comment

by:Emanuel
ID: 39255550
OK  I modified your script but it is declared as having an error in syntax;

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 inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.UserName in (select UniqueUserName from SMS_R_User where UserOUName = "test/notepad” )

Is there something else I have missed for modification?
0
 

Author Comment

by:Emanuel
ID: 39255554
My current syntax is

select SMS_R_USERGROUP.ResourceID,SMS_R_USERGROUP.ResourceType,SMS_R_USERGROUP.Name,SMS_R_USERGROUP.UniqueUsergroupName,SMS_R_USERGROUP.WindowsNTDomain from SMS_R_UserGroup where SMS_R_UserGroup.ActiveDirectoryOrganizationalUnit = "test/notepad"

However this isn't seeing my computers in the notepad group?
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 23

Expert Comment

by:Nagendra Pratap Singh
ID: 39255845
Are you using all discoveries?

Let me see the query in my lab.
0
 
LVL 23

Accepted Solution

by:
Nagendra Pratap Singh earned 500 total points
ID: 39255884
0
 

Author Closing Comment

by:Emanuel
ID: 39255960
Noob website helped.  I think I was looking for a user container not a computer one.  Once I tweaked it to look for computers it is working.

Thanks for your help!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

679 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