Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Does the RTC DW stores the WI history information?

I want to track the time consumed in each status, in another word, how long the WI wait for the next action. 
I think I should get the wi history data to calculate the duration between each status change. But my first question is does the DW stores the WI history information?
I know I can go through the ODS in RRDI to check the data, I am now installing RRDI. So if anyone can provide the information, I can get the answer earlier.

0 votes



One answer

Permanent link
Yes, check RICALM.REQUEST.HISTORY (and the rest of the RICALM.REQUEST.HISTORY_* tables) and RIODS.REQUEST.STATE_HISTORY.

1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,014
× 403

Question asked: May 01 '15, 12:22 p.m.

Question was seen: 2,703 times

Last updated: May 01 '15, 1:34 p.m.

Confirmation Cancel Confirm