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?
Hi Mostafa,
Thanks for the reply, Is POLLING_INTERVAL the same as HEART_BEAT_FREQUENCY?
Correction : I'm Using the T_AGENTS Table.
I can find the FAIL_HEARTBEAT_THRESHOLD and LAST_POLLED_DATE here.
I see T_AGENT contains the same three columns here (FAILED_HEARTBEAT_THRESHOLD, HEART_BEAT_FREQUENCY, LAST_POLLED_DATE). Can you double check the columns on your side … also which version are you on?
Hello Mostafa,
Can you provide me the calculation of is_running for T_AGENTS Table as well?
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.