report to show which business service has highest incident ticket duration

[karan15]

HI 

Need help in configuring report which shows business services for which incidents were raised and which of these incidents took longest to resolve 

For E.g - Business Service  = Active DIRECTORY , duration of incidents where AD was business service = 2-5 days 

              Business Service =   WEBSITE , Duration of incidents where website was business service = 5 days 

Thanks 

[Punit S]

Karan, 

Attached screenshot of incident table, and duration is an OOB field on it. 

Thanks,

Punit

[Punit S]

I hope this helps you to configure the report you need! Mark this correct/helpful if solves your issue.

thanks,

Punit

[karan15]

hi , 

am not able to find duration column in cmdb_ci_service table as that is selected  as the source table.