For more detail about this query, please see http://www.windows-noob.com/forums/index.php?/topic/9069-report-count-of-computers-in-certain-organizational-units/ select ou.ou, count(*) as ‘total’ from (SELECT sys.ResourceID, max(OU.System_OU_Name0) AS ‘OU’ FROM dbo.v_R_System AS sys INNER JOIN dbo.v_RA_System_SystemOUName AS ou ON sys.ResourceID = ou.ResourceID GROUP BY sys.ResourceID) ou group by ou.ou Order by ou.ou
Recent Posts
Archives
- December 2017 (1)
- January 2014 (1)
- September 2013 (1)
- August 2013 (1)
- July 2013 (3)
- June 2013 (1)
- April 2013 (1)
- March 2013 (1)
- February 2013 (1)
- January 2013 (2)
- December 2012 (3)
- November 2012 (1)
- October 2012 (5)
- September 2012 (1)
- July 2012 (4)
- June 2012 (2)
- May 2012 (7)
- April 2012 (2)
- March 2012 (15)
- February 2012 (7)
- January 2012 (7)
- December 2011 (2)
- November 2011 (5)
- October 2011 (4)
- September 2011 (4)
- August 2011 (5)
- July 2011 (7)
- June 2011 (1)
- May 2011 (2)
- April 2011 (3)
- March 2011 (8)
- February 2011 (7)
- January 2011 (8)
- December 2010 (3)
- November 2010 (5)
- October 2010 (7)
- September 2010 (7)
- August 2010 (2)
- July 2010 (8)
- June 2010 (12)
- May 2010 (4)
- April 2010 (1)
- March 2010 (13)
- February 2010 (6)
- January 2010 (3)
- December 2009 (11)
- November 2009 (10)
- October 2009 (8)
- September 2009 (11)
- August 2009 (8)
- July 2009 (12)
- June 2009 (16)
- May 2009 (11)
- April 2009 (6)
- March 2009 (6)
- February 2009 (27)
- January 2009 (11)
- December 2008 (13)
- November 2008 (17)
- October 2008 (31)
- September 2008 (60)
- August 2008 (72)
- July 2008 (56)
- June 2008 (47)
- May 2008 (38)
- April 2008 (20)
- March 2008 (8)
- February 2008 (10)
- January 2008 (17)
- December 2007 (42)
- November 2007 (29)
- October 2007 (34)
- September 2007 (31)
- August 2007 (32)
- July 2007 (33)
- June 2007 (38)
- May 2007 (34)
- April 2007 (35)
- March 2007 (35)
- February 2007 (29)
- January 2007 (29)
- May 201 (1)
Recent Comments