Hello,
Is there any internal RSA Tables or views from where I can fetch the Agents details.
T_AV_AFX_SERVER_AGENT This table displays all the agents and other Information, Although I need the is_running Value.
This Table doesnt contain such a column.
Does anyone else know a table from where We can get Agents as well as whether they are Running or not details?
Unfortunately there isn't a view for that. As for the status, this is calculated dynamically from the columns POLLING_INTERVAL, FAIL_HEARTBEAT_THRESHOLD and LAST_POLLED_DATE.
So for example if polling interval is 5000 (5 seconds), failed heartbeat threshold is 6. Then last_polled_date should always be greater or equals sysdate - (5*6 seconds). Any last_polled_date lower than that would be considered not running.