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