What Service Catalog database table contains the approval user information for a request

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

I'd like to review the database to determine which approval users are assigned to requests. What database table contains this information?

Environment

Release:
Component: SVCMGT

Resolution

This information is stored in the following table:

usm_request_pending_action

The request information is located in the "request_id" table, and the user assigned is in the "user_id" field.

Additional Information

Further information on the database table is located here:

https://docops.ca.com/ca-service-management/14-1/en/using/service-catalog-management/manage-events-rules-actions/event-parameters

https://support.ca.com/phpdocs/0/common/impcd/r11/MDBMain/Schema152/Tables/usm_request_pending_action.html