How do I verify if any Operator Consoles are open from within the Repository or SQL? (NETIQKB43332)

How do I verify if any Operator Consoles are open from within the Repository or SQL?

You can use a stored procedure from within SQL Query Analyzer to view the open Consoles connected to your AM Repository. 

Use the following steps to verify any open consoles:

1. Launch the SQL Query Analyzer.
2. Select your Repository from the database drop down selection.
3. Enter and Execute the following stored procedure into the Query Window: sp_who2
4. Scroll through the Results window to the column named ProgramName.
5. Look for the Program AppManager Console.
6. The HostName associated with the AppManager Console currently has a Console running on that machine.

Formerly known as NETIQKB43332