Re: [otrs] Finding the Ticket#

Hi, Varsani, Rajendrakumar (PSD) schrieb:

Hi folks,

We're trying to work out what kind of calls and how many calls we get before 9am as management is considering moving our HelpDesk time from a 9am start to an 8:30am start(!)

We've created some SQL along the lines of:

SELECT id, create_time, FROM ticket WHERE HOUR(create_time) < 9;

Which gives us 155 or so rows of data. However, how do I find out the Ticket Number for each of the ID and CREATE_TIME pairs returned? We've looked at the E-R diagram but are baffled!

Ticket# is stored in ticket.tn

Rajendrakumar Varsani

Bye, Alex