MOM 2005: SQL Query return Managed Windows Server Cluster Computers
This SQL Script will enumerate all Managed Windows Server Cluster Computers in your Onepoint database.
-- Scott Moss
-- 01-02-2008
-- MOM 2005 Query to enumerate only managed Windows Server Cluster Computers
-- http://myitforum.com/cs2/blogs/smoss/default.aspx
Select [Name], [Domain], [LastHeartbeat]
From Computer
Where [Type]= 67108864 and [ManagedType] = 3 and [DesiredManagedType]= 3
Order by [Name]