Can somebody tell me in which table the details of Status Change History is stored, that is the content we see when we click the Status of the request.
In CA Service Catalog version 12.7.
usm_request_status table captures the status change for all request. It includes column for old status and new status value. This should help you.
tonsh03 This table has the status change values, What I am referring is the table where the action taken, say Approval Done , Implementation in Progress all those gets captured.
In simple the contents we see when we click the Current Status of the request.
Following is the query executed when the request status link is selected:
select user_id as modified_by, status_date as timestamp, status
where request_id = <request id> and subscription_detail_id is NULL
order by request_status_id asc
The status value correlates to the associated string within %USM_HOME%\view\webapps\usm\locale\icusen\request\requestshared.xml which is displayed in the UI (i.e. Approval Done).
We added a table to map the status codes to the status text and use this in joined queries.
This helps Jason.. Thank you..