The table called ticket. Hint: read the column/field names and make a somewhat educated guess that the fields hold ids that match to tables of similar names that hold columns that have values that represent the thing being sought. In other words: Read the tables and column names. Get hints from them. Try to make your own query. If you fail, THEN ask the next question, with the query you tried to use, what went wrong, etc. On Fri, Apr 12, 2013 at 2:59 AM, Darshak Modi wrote:

Hi, I want ticket details per queue and total. Like, total tickets per queue, open tickets per queue like that.

From which tables can I get that?

-- Darshak Modi | Elitecore Technologies Telecom Practices- India Office: 079-26405600 | +91-9909008245 Skype: darshakamodi

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs