List MOM2005 agents with IP-adress
A small SQL-script to list all agents on a MOM2005 installation.
USE OnePoint
SELECT Computer.Name AS ComputerName, ComputerAttribute.[Value] AS IP
FROM ComputerAttribute
INNER JOIN Computer ON ComputerAttribute.idComputer = Computer.idComputer
WHERE ComputerAttribute.idComputerAttributeDefinition = (
SELECT ClassAttributeID as idComputerAttributeDefinition
FROM ClassAttribute
WHERE ClassAttributeName = 'IPAddress')
ORDER BY Computer.Name
