What table in the database stores form table data?

Products

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

Issue/Introduction

What table in the database stores form table data?

Environment

Service Catalog 17.x

Resolution

All form data is stored in usm_request_item_form table for forms that are associated to offerings. A query similar to the following can be leveraged to return form data for a specific request: 

select * from usm_request_item_form where subscription_detail_id in (select id from usm_subscription_detail where request_id=<request id>) 

Data entered into the 'Request Information' form is stored in usm_request_value table.