Hey,

Does any know of the sql query used to generate the Helpdesk Admin report? I am after a query that I can create a report for all workers with the number(count) of incidents open, closed, resolved which is based on department.

Any help would be appreciated.

Cheers,

Mark