Time reports for change management
Hi folks,
We are just newbies in Service Desk Plus and will deploy the tool in a few weeks. In order to establish a reporting we have customized the standard report functionalities for incident management. For change management we recognized, that there are not really useful standard reports for time spending (at least for us). I'm focussing on the automatically logged time entries by the system itself, not the manual time spent fields like in the worklog-entries threat in this forum.
Have anyone implemented reports or ideas for SQL statements for the following aspects [all of them on a monthly base]?
1) Total running time of closed changes (min, max, average) ordered by priority [based on the system time logs!]
Objective: Real time report we spent on changes
2) Total running time of closed changes (min, max, average) grouped by stages [based on the system time logs!]
Objective: In which stage of our change model we spent too much time for the current changes?
1a/2a: Maybe it makes sense to query this information including the changes which are currently open.
3) Amount/List of changes ordered by stages and expected completion time
Objective: So we have a to-Do-list, which changes we have to focus on in the next time as well as a statistcs for closed changes.
4) Amount/percentage of changes which were not closed in time (compared to the expected completion time)
Objective: Are we in time concerning change implementation?
It would be fine if we could get some SQL scripts for time reports handling the correct time format ;-).
Unfortunately I'm not that MySQL-Expert... Also a report with a similar message would help us.
Thanks a lot in advance,
Martin
We are just newbies in Service Desk Plus and will deploy the tool in a few weeks. In order to establish a reporting we have customized the standard report functionalities for incident management. For change management we recognized, that there are not really useful standard reports for time spending (at least for us). I'm focussing on the automatically logged time entries by the system itself, not the manual time spent fields like in the worklog-entries threat in this forum.
Have anyone implemented reports or ideas for SQL statements for the following aspects [all of them on a monthly base]?
1) Total running time of closed changes (min, max, average) ordered by priority [based on the system time logs!]
Objective: Real time report we spent on changes
2) Total running time of closed changes (min, max, average) grouped by stages [based on the system time logs!]
Objective: In which stage of our change model we spent too much time for the current changes?
1a/2a: Maybe it makes sense to query this information including the changes which are currently open.
3) Amount/List of changes ordered by stages and expected completion time
Objective: So we have a to-Do-list, which changes we have to focus on in the next time as well as a statistcs for closed changes.
4) Amount/percentage of changes which were not closed in time (compared to the expected completion time)
Objective: Are we in time concerning change implementation?
It would be fine if we could get some SQL scripts for time reports handling the correct time format ;-).
Unfortunately I'm not that MySQL-Expert... Also a report with a similar message would help us.
Thanks a lot in advance,
Martin