MOM 2005 Computer Group membership counter
The following SQL Script will return a count of the number of computers that belong to each computer group in your OnePoint Database.
This count includes all computers that is in the OnePoint Database, which includes Discovered, Unmanaged and Managed computers. This query can help you identify possible problems with a group or when troubleshooting why Computer group modifications in the Management console take a long time.
-- Scott Moss
-- 09/02/07
-- http://myitforum.com/cs2/blogs/smoss/default.aspx
-- Computer Group member ship counter
-- returns a count of discovered/managed/unmanaged computers
SELECT [Rule], COUNT(*) AS [Members]
FROM computertocomputerruleview
group by [Rule]
order by [Members] desc