List of all SQL/Oracle Tables Used by CA Service Catalog

[Scott Stineman]

Hello ... Does anyone have the full list of SQL/Oracle tables used by the CA Service Catalog application?  We periodically synchronize table data from our production environment (MDBADMIN schema) down to our development environment.  Without realizing it, we wiped out all of the CA Service Catalog offerings, data objects, forms, and so forth that we had under development.

I suspect all the tables with the prefix USM_ are the CA Service Catalog specific tables.  Please confirm and if there are others we need to know about, please enlighten me.  Thank you.

[Brian Mathato]

Hi Scott,

Perhaps this old item I came across from this forum might help as a base to work from. 

https://community.broadcom.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=fd936229-beb0-4f25-a807-68d4b21a388a&forceDialog=0

https://community.broadcom.com/enterprisesoftware/communities/community-home/librarydocuments/viewdocument?DocumentKey=7ccd37f1-2980-4667-b96d-2f395471dd90&CommunityKey=e2cd3188-49bc-4f38-88f1-74260f56fa66&tab=librarydocuments



All lot has changed since then. So, good luck friend...