Does Applications Manager store changes made to the backlog?

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Is it possible to query the Applications Manager database to find out what user deleted Conditions on a job that was in the backlog?  If so what table stores this information?

Environment

Applications Manager 9.4 and 9.5

Resolution

Backlog changes such as condition deletes are tracked and written to the aw_audit_reports_table when the “Enable auditing of backlog changes” option is checked on the master. If this option is not checked backlog changes are not stored.

This is noted in the following documentation link…

Enable auditing of backlog changes

Adds audit changes made in the Backlog to the aw_audit_reports_table database table. If you want to track changes to conditions or prompts for reset tasks in the Backlog, then you should enable Backlog auditing.

Audit data is purged by running the PURGE_AUDIT_HISTORY Job. For more, see Enabling Applications Manager Auditing.

Setting Explorer Automation Engine Options (broadcom.com)

To check if this option from the client gui navigate to Object Admin>Administration>Agents>Master’s Agent>Automation Engine Options>Explorer>a check box for Enable auditing of backlog changes can be found.

If this option is enabled highly recommend enable the “Purge_Aduit_History” job on a schedule to maintain the table. This is documented below.

Purging the Audit Tables

The PURGE_AUDIT_HISTORY Job purges the tables used for Applications Manager auditing. It includes a single prompt where you specify how long you keep audit changes. This purges both object and Backlog audit information. The default value is 60 days. If you are using Applications Manager auditing, you should set the prompt value and create a schedule for this Job.

Additional Information

Details on how to get additional information when trying to query a condition delete can be found below.

If the “Enable auditing of backlog changes” option is checked, the delete record is stored in the aw_audit_reports_table.

From the aw_audit_reports_table  the Key 1 column, stores the jobid which can be linked to the so_job_cond table's column so_object_seq to get the specific condition details.

The aw_audit_reports_table Key 1 column can also be linked to so_job_history table's  so_jobid column to get the job name.

Note the so_job_history and so_job_cond table are maintained by History_Purge job, the data in those tables will still need to be available to get the additional details.