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]

 

Comments

No Comments