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.
|
One answer
Yes, check RICALM.REQUEST.HISTORY (and the rest of the RICALM.REQUEST.HISTORY_* tables) and RIODS.REQUEST.STATE_HISTORY.
|