SQL for ResponseTemplate usage

[ShlomiBenAmi]

Hi there,

quite new to OTRS usage and completely new to this community forum - so "hello" first of all!

I need some help. I want to have an SQL to get the usage of response templates for tickets.
In detail I want to know which agent was using which response template how often in a given date range "x"

I even would like to filter it even more by specifying a list of 5 or 10 specific response template IDs that I am interested in.

I want to have the agent ID or name as a filter criteria to be able to run that SQL for a given agent and a given date range, e.g.: which response templates has agent "xyz" been using in the past 30 days.

I would not care in which tickets it was used actually.

Background: I want to know for month X if agent Y was using some very special response templates A, B and C.

Any idea? And help would be greatly appreciated....

[crythias]

In detail I want to know which agent was using which response template how often in a given date range "x"

It's not tracked in any form, but obviously you can search articles with keywords in your response template. You'll still get not what you want unless you query the article table directly.
Even then, this is a metric that has nothing to do with solving tickets.