Request Information in a request

Document ID : KB000074252
Last Modified Date : 18/03/2018
Show Technical Document Details
Introduction:
Sometimes,  the customers  need  to  update the field named Comments on the system information form for a request via SQL .  They would like to know which db table actually stores  in "Request Information" 
Question:
Which db  table contains the data of  Request Information section in a request detail page in catalog GUI ? 
User-added image
Environment:
Service Catalog 12.9, 14.1 , 17.1 
Answer:
The information regarding the value in the fields ( including Comment field, Cost Center , etc  ) of the system information form are stored in usm_request_value table . 

you should be able to see ( or update via update sql statement ) each request's comments field , cost_center field ,etc  value at db level  by : 

select * from usm_request_value where request_id=<request id >