How can I get CA Service Catalog files attachment of a request from query SQL?
Article ID: 75041
SUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceKNOWLEDGE TOOLSCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
How can I get CA Service Catalog files attachment of a request using a SQL query?
Release: Component: USVCT
You can get the information from usm_asset table and cross the information with the usm_request to find the request using the object_id column. Additionally, in usm_asset table you can find the user_id which is the user who added the attachment.