Are ACTIVITIES available in archive?

Jason_MeyerJason_Meyer Customer Adept IT Monkey ✭✭

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

  • Chris_Chekaluk1Chris_Chekaluk1 Customer Adept IT Monkey ✭✭

    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.

Sign In or Register to comment.