7 Replies Latest reply on Jan 21, 2020 4:21 AM by Sinisa Mikor

    Incident report to capture time spent on each status

      Share This:

      What would be the best way to generate an incident report based on a time span

      The report should capture the below fields. There should be only 1 row per incident.


      incident numbersummarystatus - newtime spent on Newstatus - assignedtime spent on assignedstatus - in progesstime spent on in progressstatus - pendingtime spent on pendingstatus - resolvedtime spent on resolvedstatus - closed


      environment : ITSM 9.0.1

      db : ms sql