Report of template used for ticket logging
Hi Experts,
We have several service request templates that staff can use to log their ticket. We are trying to build a report using the Query Report to find out how many times the templates are used when logging a ticket.
The report output should be similar to below
We have several service request templates that staff can use to log their ticket. We are trying to build a report using the Query Report to find out how many times the templates are used when logging a ticket.
The report output should be similar to below
TemplateName Jan Feb .....
Template A 5 8 ...
Template B 3 0 ....
I found an old discussion https://forums.manageengine.com/topic/report-used-service-request-templates using a MSSQL that suit my need.
Does anyone know how can I convert the query to PostgreSQL?
Thanks.
Template A 5 8 ...
Template B 3 0 ....
I found an old discussion https://forums.manageengine.com/topic/report-used-service-request-templates using a MSSQL that suit my need.
Does anyone know how can I convert the query to PostgreSQL?
Thanks.