How do I use a SQL query to show all AppManager Agents currently in maintenance mode? (NETIQKB4819)

  • Document ID:7704819
  • Creation Date:02-Feb-2007
  • Modified Date:14-Jan-2019
    • Micro Focus Products:
      AppManager

Environment

NetIQ AppManager 9.1.x
NetIQ AppManager 9.2.x
NetIQ AppManager 9.5.x

Situation

How do I use a SQL query to show all AppManager Agents currently in maintenance mode, whether from using the Maintenance Mode console option or AMAdmin_SchedMaint knowledge script?

Resolution

You can execute the following query in via NetIQ Repository Browser via Operator Console or Microsoft SSMS (SQL Server Management Studio).

SELECT Name
FROM Object
WHERE Status & 0x00002000 = 8192
OR Status & 0x00004000 = 16384
OR Status & 0x00008000 = 32768

To execute via NetIQ AppManager Operator Console:
  1. Open NetIQ AppManager Operator Console
  2. Click on the Extensions menu
  3. Choose Repository Browser
  4. Paste the above SQL statement in the bottom window
  5. Click the Execute button
To execute via Microsoft SSMS:
  1. Open Microsoft SQL Server Management Studio
  2. Connect to the appropriate Database and Instance for the AppManager Repository
  3. Select the AppManager Repository database from the drop-down box at the top-left
  4. Enter the above SQL statement
  5. Execute the SQL statement by clicking the '! Execute' button or pressing F5 on the keyboard.

Additional Information

Formerly known as NETIQKB4819