book
Article ID: 110088
calendar_today
Updated On:
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.