Select * from..... :) Now serious, you can get something like that within the utilities page (aka search) - put the customer email in the Fulltext search field, select only the
From checkbox and do a search.. You'll see something like: Results 1-15. Total hits: 400
It is not accurate, because it will count any followup from the customer as another hit. Hope it helps, (if not, do the select thingy) DC -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Henning Werner Sent: quarta-feira, 27 de Agosto de 2003 15:46 To: 'otrs@otrs.org' Subject: [otrs] Ticket Counter Hi all, i have a question regarding the handling of tickets and customers in OTRS. Is it possible to get the number of tickets belonging to a special customer (e.g. customer with ID: "example.com" has opened 314 tickets this year)? Any hints or ideas? Thanks, Henning Werner _______________________________________________ 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