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

  • 7771742
  • 21-Aug-2009
  • 09-Feb-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

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

Resolution

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

Additional Information

Formerly known as NETIQKB71742