Table that shows SDM Call_Req ticket link to catalog request

Products

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

Issue/Introduction

When a catalog request opens an SDM ticket, this writes the link to the SDM ticket back to the catalog request as "Related Ticket".  Example shown below.

Where is this stored in the DB?

Environment

Release:  17.1 or higher
Component: CA Service Catalog/Service Desk

Resolution

While most request form data is in USM_REQUEST_ITEM_FORM The link between the SDM ticket and the request should be in USM_LINK_TICKET_REQUEST_ITEM

Additional Information

The following is a sample query that demonstrates the fields contained in this table if one queries against the above request_id value in the screenshot depicted.