Mark Minasi's Reader Forum
Mark Minasi's Reader Forum
Home | Profile | Register | Active Topics | Active Polls | Members | Search | FAQ | Minasi Forum RSS Feed
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Email, Databases, Sharepoint and more
 System Center
 SQL Query - Workstation OUs		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JSCLMEDAVE
Administrator

USA
6115 Posts
Status: online
Posted - 10/15/2010 :  12:30:30 PM  Show Profile  Visit JSCLMEDAVE's Homepage  Click to see JSCLMEDAVE's MSN Messenger address  Reply with Quote
Can anyone point us in the right direction to create a SQL query in SCCM to pull the OU information on workstations that do not have the SCCM Client Agent installed..?

We are deailing with nested OUs and a large number of workstations that "appear" to have GPs applied that prevent access to WMI, this is causing the SCCM Client Agent to fail during install.

We are trying to determine if the affected workstations are in a single nested OU or not.


Thanks!!
Tim-

“This too shall pass"

JSCLMEDAVE
Administrator

USA
6115 Posts
Status: online
Posted - 10/15/2010 :  1:44:28 PM  Show Profile  Visit JSCLMEDAVE's Homepage  Click to see JSCLMEDAVE's MSN Messenger address  Reply with Quote
This worked for what we needed.

select distinct OU.system_OU_name0 as 'Organizational Unit', count(sys.name0) as 'Number of Machines in OU', count(sys.client0) as 'Number of SCCM Clients' from v_R_System SYS JOIN  v_ra_system_systemouname OU on SYS.resourceid = OU.resourceid WHERE OU.system_ou_name0 like '%computer%'  GROUP BY OU.system_ou_name0
Tim-

“This too shall pass"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Mark Minasi's Reader Forum © 2002-2011 Mark Minasi Go To Top Of Page
This page was generated in 0.08 seconds. Snitz Forums 2000