How do I extract a list of machines which are being monitored from the AppManager Repository? (NETIQKB71742)

How do I extract a list of machines which are being monitored from the AppManager Repository?

In order to obtain a list of machines that are being monitored\managed by a AppManager Repository refer to the information below:

Execute the following query in SQL Query Analyzer against the QDB

select Name
from dbo.Object with (nolock)
where TypeID in (2, 16)
and Status &0x08000000 = 0
order by Name asc

This will display a list of both Windows and Unix agents.  To only display one or the other remove the corresponding TypeID

2= Windows Server

16 = Unix Server

Formerly known as NETIQKB71742