information stored in the usm_offering table

Products

• CA Service Catalog

Issue/Introduction

What information is stored in the usm_offering table of MDB database for Service Management application?

Environment

Release : 17.x

Component : CA SERVICE CATALOG

Resolution

usm_offering table present as part of mdb database captures all the service offerings and folders created as part of Service Catalog. It will store information like status, code, name, data available, description, etc.

status column is an integer field and values present as part of this field correspond to the following:
0 = Service offering/folder is deleted
1 = Service offering/folder available
2 = Service offering/folder unavailable
3 = Service offering/folder is created
4 = Service offering/folder is canceled
6 = Is similar to 1