SLA per Assigned Group

[rafael_merces1]

Hello everybody,

I posted something similar on another thread (that was not answered), now what I am looking for is more a brainstorm regarding a question:

As I said, there are some requirements regarding Incident SLAs and the groups involved on the solution of a ticket. The requests are:

a) Identify which one was the group that took most time of the SLA and, consequently, was the mais responsible for the SLA breach.

b) Which was the group that ws working on the ticket by the time it breached.

c) Sum and average of time spent on ticket, per group, of the groups that SOLVED the ticket.

d) Sum and average of time spent on ticket, per group, of the groups that DID NOT SOLVED the ticket, but worked on it.

Discussing with some friends of mine, we could think in some things, but I would like to know from you if this is the best approach, or if anyone ele had a similar request:

a) Currently the SLAs are assigned per Incident item. We could stabilish OLAs per group and count them too on the incident.

b) To calculate these sums or averages, I could only think on a Custom table (where I would store this information) + a Business Rule that will run on the change of the incident state to "Resolved" (our SLAs stop condition) and that will perform some queries on the OLAs generated on this incident and insert on this custom table.

Not sure of how to proceed about request b.

Also, I am not thinking about metrics right now, as the metrics only account total time, not business time, and they do not consider, either, the amount of paused time.

What you guys think? Does this seems to be the best solution? Have you ever done something similar to this before?

[Jagadevi]

We are able to achieve this requirement using OLAs, you could try.