MOM 2005: SQL Query return Unmanaged Windows Server Cluster Computers
The following SQL Query will list the unmanaged Windows Server Cluster Computers in the 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] = 0 and [DesiredManagedType] = 0
Order by [Name]