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