Which information is stored in usm_system_change* tables?

Document ID : KB000015079
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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?

Answer:

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