Service Catalog and CSDM tables

Service Catalog manages and uses CSDM tables. Several ServiceNow products benefit from and add value to Service Catalog.

CSDM tables managed by the Service Catalog

The Service Catalog primarily manages business services in the Sell/Consume domain. Technical Services are also viewed from the Operate domain of Event Management.

The Service Catalog manages the Catalog Item table [sc_cat_item]. The Catalog Item table creates requests in Request Management. The requests usually have an automated, semi-automated, or business workflow for fulfilling the request, which can consist of approvals and tasks. When part of Service Portfolio Management, the CIs are associated with service offerings. When you link a catalog item, you can track request activity for all catalog items associated with a service offering. An offering can have multiple catalog items.

The CIs can include:

• PC Hardware Item (pc_hardware_cat_item): Submits hardware asset requests included in Asset Management workflows.
• PC Software Item (pc_software_cat_item): Submits software asset requests included in Asset Management workflows.
• Record Producer (sc_cat_item_producer): Submits requests or generates records other than Request Management tables for services that aren't serviced by Request Management (for example, HR Cases, Facilities Requests, or Legal Requests).

그림 1. CSDM tables managed by the Service Catalog

CSDM tables used by the Service Catalog

1. Configuration Item tables [cmdb_ci*]
2. Service Offering table [sc_cat_item_subscribe]
3. Application Service table [cmdb_ci_service_discovered]
4. Product Model tables [cmdb_model]
   주:

   The following legacy CMDB relationships that once provided access to catalog items are no longer supported. To provide access, use the new relationships listed in the table.

   표 1. Relationship tables

   CMDB table	Catalog item relationship table	New relationship to use instead
   User (sys_user)	sc_cat_item_user_mtom, sc_cat_item_user_no_mtom	User criteria
   Group (sys_user_group)	sc_cat_item_group_mtom, sc_cat_item_group_no_mtom	User criteria
   Department (cmn_department)	sc_cat_item_dept_mtom, sc_cat_item_dept_no_mtom	User criteria
   Location (smn_location)	sc_cat_item_location_mtom, sc_cat_item_location_no_mtom	User criteria
   Company (core_company)	sc_cat_item_company_mtom, sc_cat_item_company_no_mtom	User criteria

그림 2. CSDM tables used by the Service Catalog

Products that benefit from the Service Catalog

Service Portfolio Management (Service Portfolio Management)

Ties catalog items to service offerings. Lets service owners create and maintain catalog items more easily, and gives more visibility into the service offerings.

Hardware Asset Management and Software Asset Management

Self-service catalog lets you order an asset and track service delivery.

Human Resources (HR)

Exposes the creator (Record Producer) of HR cases and displays the Record Producer in the relevant self-service catalogs (for example, Portal, Mobile, and Virtual Agent).

Customer Service Management (CSM)

Exposes the creator (Record Producer) of customer service cases and displays the Record Producer in the relevant self-service catalogs (for example, Self-service Portal, Mobile, and Virtual Agent).