Last Agent Execution Date Info within the MDB

Document ID : KB000054402
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Where is the "Last Agent Execution Date" stored in the MDB and how can I view it?
I would like to ensure data consistency between the MDB and console agent info.

Solution:

The last run date info is stored in the ca_agent.last_run_date field.
The date is stored in seconds from day 1/1/1970.

To convert the value to a readable format use the following SQL query:
select agent_name, dateadd(second, last_run_date,'1970-01-01') from ca_agent