6 Replies Latest reply on Dec 3, 2019 10:19 AM by Sinisa Mikor

    Incident report to capture time spent on each status

    Saurabh Malviya
      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

       

      Regards,

      Saurabh