Approval user info for a Request made in Service Catalog

Products

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

Issue/Introduction

During Request submission in Service Catalog, if an Approval Process is configured, user approval may be needed to progress the submitted request.

Service Catalog admins may wish 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