Monitor Appqorx Agent Down status

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Which table from appworx database can be used to capture the status of agent and to monitor if the agent is down?

Environment

Release : 9.x.x

Component :CA Automic Applications Manager

Resolution

Pulling  the value from the view AW_AGENT_VIEW might help:

select so_operator, so_status_name from aw_agent_view where so_master != 'G';
SQL> select so_operator, so_status_name from aw_agent_view where so_master != 'G';

SO_OPERATOR         SO_STATUS_NA
------------------------------ -----------------------
AGENT1                        Running
AGENT2                        Running
AGENT3                        Running
AGENT4                        Running
BANNER                       Running
RAFTP                          Running
WSREST                      Running
WSSOAP                      Running