Home Analyst Portal

Activities data available in archive?

Jason_MeyerJason_Meyer Customer Advanced IT Monkey ✭✭✭
edited August 1 in Analyst Portal

We just had an internal audit and realized that we don't have date attributes on our Activities in our SSRS reports.


Does anyone know if the following attributes are available in Archive for Manual Activities?

Scheduled Start Date

Scheduled End Date

Actual Start Date

Actual End date


The only date fields I see on "Manual Activity Detail" are:

Report Generated

Created Date


We need to prove with documentation the date an Activity was completed.


Any thoughts/ideas?


Thanks!

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

    @Jason_Meyer - All properties on MAs are archived including these date properties you're looking for. The challenge you will face is reporting from the archive as each object (activity in this case) is stored in JSON in its record. The archiver was meant to serve as a source of viewing individual records rather than reporting on trends etc. Having said that, the Scheduled and Actual start and end dates should also be in the existing Analytics db in the SM_WorkItem_ManualActivity table.

  • Jason_MeyerJason_Meyer Customer Advanced IT Monkey ✭✭✭
    edited August 2

    Thanks Justin, I'll share this with our dev. staff.


    I'm not trying to look at trends, just need to know the completed dates on Activities that have been archived.


    Is this information available from within Service Portal on Cireson's new 'everything is saved' version?

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

    Yes. Once the work item is groomed out of SCSM, it is still available in the portal because of the archiver.

  • Jason_MeyerJason_Meyer Customer Advanced IT Monkey ✭✭✭

    Awesome, thanks.

Sign In or Register to comment.