What is dbo.AL_CMDB_AUDIT_SHARE?

book

Article ID: 5365

calendar_today

Updated On:

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? 

Cause

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

Environment

All-

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.