Last Agent Execution Date Info within the MDB

Products

• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Patch Manager

Issue/Introduction

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.

Environment

Client Automation - All versions

Resolution

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