Service Catalog - Database table that contains the Approval user info for a Request

Products

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

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

Service Catalog - All releases

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:

Event Parameters