Something like this? :

SELECT

ticket.tn,

queue.id,

queue.name,

groups.id,

groups.name,

ticket_state.id,

ticket_state.name,

ticket.change_time

FROM

ticket

Inner Join ticket_state ON ticket.ticket_state_id = ticket_state.id

Inner Join queue ON ticket.queue_id = queue.id

Inner Join groups ON groups.id = queue.group_id

WHERE

year(ticket.change_time) =  2008 AND

month(ticket.change_time) =  2

ORDER BY

ticket_state.id ASC

regards,

Peter van Beugen

Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens ???????? ?????????
Verzonden: woensdag 13 februari 2008 12:08
Aan: 'User questions and discussions about OTRS.org'
Onderwerp: [otrs] Monthly overview

Hi, I’m trying to make a monthly overview statistics template. What I need, is a list of all tickets available in a specific month sorted by their status, no matter when they were created. E.g. on the last day of a month I have 30 total tickets open(available for work) and during the month I closed… lets say another 30. All of them were created in different queues, and most of them were created in the month before, or even earlier. How can I generate a list of (open, closed, new) tickets in THIS month, no matter when they were created?

I tried different things, like opened date, closed date in the stat module… but they only work for tickets in the month that they were created. SO if a ticket was created in January, but closed in February, it will be shown as a January closed ticket… so it doesn’t work for me.

Any help will be appreciated.

Best regards,

Alexander