How can I get CA Service Catalog files attachment of a request from query SQL?

book

Article ID: 75041

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

How can I get CA Service Catalog files attachment of a request using a SQL query?

Environment

Release:
Component: USVCT

Resolution

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.