Report for response first time

[tripti_rai2005]

I am looking forward to a report showing me the first response time for agents.It could be a static report as well.I need to generate a report in otrs for periodic view by my customer.I would appreciate if someone could help me.
I can write a sql query , but i need a report.

[tripti_rai2005]

Can some one please respond to my query

[alexus]

If you can build SQL-request you can create own static report. It's not a big deal. If you are interesting feel free to contact us!

[tripti_rai2005]

I have queried the database to get the data..but i want it to be generated dynamically in otrs like the statistic module works..My query looks like this
select
queue.name queue,
service.name service,
ticket.tn ticket,
ticket.create_time,
min(ticket_history.create_time) as resp_time,
timestampdiff(second, ticket.create_time, ticket_history.create_time)/60 resp_delay_min,
queue.first_response_time
from
queue,
ticket,
service,
ticket_history,
ticket_history_type
where
ticket.queue_id = queue.id and
ticket.service_id = service.id and
ticket_history.ticket_id = ticket.id and
history_type_id = ticket_history_type.id and
ticket_history_type.name = 'SendAnswer'
group by queue.name, service.name, ticket.tn, ticket.create_time, queue.first_response_time

[reneeb]

Then you should have a look at the existing stats modules (<OTRS_HOME>/Kernel/System/Stats/...)

[jfberni]

how can you call the existing static state through otrs.GenerateStats.pl ???

i don't see my object in Report only dynamic