Znuny Open Source Ticketsystem

Thanks for the help Crythias. I was able to figure out what I wanted. To help others along that may be looking for the same thing the code is:

select max(id),max(owner_id), ticket_id, max(queue_id) from ticket_history
where create_time between '2010-08-12' and '2010-08-13' group by ticket_id having ...

Yes, I've used those style for pretty much all of my other queueries. The actual query I'm working with now is:

Select count(distinct ticket_id) from otrs.ticket_history WHERE create_time < '2010-07-17' and create_time > '2010-07-16' and owner_id = 1 and queue_id = 2

I'm pulling in the dates from ...

Hi everybody,

This is my first post here so I apologize in advance if I don't provide as much information as needed.

What I'm looking to do is find out how many tickets were assigned to the root user on any given day in the past via a SQL Query. I've got everything else that I need figured out ...