Which information is stored in usm_system_change* tables?

Products

• CA Service Catalog
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

We were running low on space in the MDB, and we have found that there is a lot of space in the MDB taken up by the  usm_system_change* tables. What information is stored in these tables and how can we reduce the amount of space this takes up?

Environment

Release: CASVCT99000-14.1-Service Catalog
Component:

Resolution

The usm_system_change* tables contain information about all of the actions/transactions which take place in Service Catalog, you'll find some of this information in the "Audit Trail" tab of a request.

You can archive/purge this data using Service Catalog stored procedures. Information about how to do this is in the Service Management documentation:

https://docops.ca.com/ca-service-management/14-1/en/administering/administering-ca-service-catalog/archive-and-purge-historical-data