We are looking for a MSSQL report which reports on how many times the Default Template is change to another template name.
For example, on the 9th of May we received 10 tickets via email which used the default template to log the ticket. The technician opens this ticket and changes it to a more appropriate template. So what we need is a report showing how many times this happens on a daily basis for a date period of start date to end date. We need the ticket number, a column showing it was registered under the default template, a column showing the new template name, and the technician who change the template.