Are ACTIVITIES available in archive?
After work items that have ACTIVITIES associated with them are archived. Is ACTIVITY information available anywhere? We have Review Activities that we get audited on 'years' after the request is completed and need a way to provide Review Activity approval information.
Answers
I would suggest starting by taking a look at the ReviewActivityDimvw view in the SCSM Data Warehouse or the SM_WorkItem_ReviewActivity table in Cireson's Analytics to see what would work best for you.
Note that there is a lot of related data in the other Review* views in the DW that you might wish to JOIN with- especially if you need to get to who reviewed which RA, who voted, how they voted, etc.