What is dbo.AL_CMDB_AUDIT_SHARE?

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

On the Primary MDB, there is program named “CA ITAM”, from xxxx-xxxxx server and using “sb” user running a procedure “dbo.AL_CMDB_AUDIT_SHARE”; every few minutes (5 to 10) and running this procedure very long and it is an INSERT transaction mostly.

 

Do we know what dbo.AL_CMDB_AUDIT_SHARE is and why it's running all the time? 

Environment

All-

Cause

This is either On/Off - True/False option within the Administration tab ->Event Service, Show Advanced options:  *Is CMDB Audit Share Required:

Resolution

The indicator that enables audit sharing with the CMDB. 
The CMDB common database tables can be used by multiple applications.

 

For example, the ca_contact table is used by CA APM, CA Service Catalog, and CA Service Desk Manager when they are integrated. An audit table maintains the changes that are made to these common tables. 
When there is a change to any of the CMDB objects in CA APM and this value is set to true, the 
change audit is posted to the CMDB audit table.