Incidents/Tasks/Requests etc etc closed by an Assignment group

[simonfurnish]

Hi,

I'm looking to create a report every month of all forms of tickets that have been resolved by my Team. Does anyone have such a report that they can share or advise what Table I would need to use to get my report.

Many Thanks

[Ivano B]

Hi Simon

I think you can report against the 'task' table and group by 'task type' and condition WHERE 'assignment group' = yourGroup AND closed this month AND state IN list of closure state.

Of course we suppose that

- the last group assigned is also the one who resolved the tasks.

- the tickets you are talking about are all extension of task table (usually you expect something like this)

Plus you have also bare in mind that not all the classes (problem change incident etc etc) are using exactly the same final statuses.

Cheers

Rob0

[ghsrikanth]

If your team as a specific assignment group, then you can create a report like this

You can schedule this report to run every month

'

Hope it helps

[simonfurnish]

Hi,

Thanks, An initial report I created seems to capture the tasks but the Incidents that are closed or resolved seem quite low.

[simonfurnish]

I have "Closed Complete" and "Resolved" only in one of my conditions. However the Incident Volume seems a lot lower compared to another report I have.

In my other report I needed to dot walk under "Incident.Incident State" and this gave me a higher Incident volume ?