SQL Query to list all MOM 2005 managed machines

Run the following query against your OnePoint database, and it will output all the managed computer names

--SQL QUERY 

select Name from Computer
WHERE [IsConfigManager]=0 AND ManagedType = '2' AND (idConfigManager IS NULL OR idComputer <> idConfigManager) AND  IsAddedByServiceDiscovery = 0 AND [Type] <> 67108864

 -- END

Enjoy!

 

Comments

# myITforum Daily Newsletter; May 23, 2007

Wednesday, May 23, 2007 7:28 AM by myITforum Newsletters

myITforum Daily Newsletter Daily Newsletter May 23, 2007 The myITforum.com newsletter is delivered Monday