Time Spent reports

Time Spent reports

Apologies if this has been asked before, if it has, hopefully this is a quick answer!

I want to be able to produce this type of report.



What I would really like is to get a report that shows this along side the SLA name and the Response Time and Resolution Time and to show if the SLA has been broken.

Along with this I would like to see if the response due time and is la has been violated within the report, so basically the detail that's being displayed as the yellow coin and the red flag in the interface.

If at all possible I would also like to see (which I don't think is possible but hopefully you can help ;-) ) in the history along side the Status being changed if the timer was stopped or kept running.

Is there any way you could provide me with a query to get this at all please, or, at the very least where this data is in the database structure?

Cheers

rich


                New to ADSelfService Plus?