Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 579
  • Last Modified:

SCCM 2007 Active Directory Collection

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
Emanuel
Asked:
Emanuel
  • 3
  • 3
1 Solution
 
Nagendra Pratap SinghCommented:
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
 
EmanuelAuthor Commented:
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
 
EmanuelAuthor Commented:
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Nagendra Pratap SinghCommented:
Are you using all discoveries?

Let me see the query in my lab.
0
 
EmanuelAuthor Commented:
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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now