Status Change History Table

[Legacy User]

Dear All,

 

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.

 

Thank you

[Anon Anon]

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.

[Legacy User]

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.

[Jason_Wolfe]

Hi!

 

Following is the query executed when the request status link is selected:

 

select user_id as modified_by, status_date as timestamp, status
from usm_request_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).

 

Thanks,
Jason

[Legacy User]

We added a table to map the status codes to the status text and use this in joined queries.

[Legacy User]

This helps Jason.. Thank you..