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.
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