On Wed, 27 Oct 2004 00:16:26 -0400, Tyler wrote: <snip> Here is an SQL statement that will poll this information. Change the date/time to reflect the time period you want. If you don't want all the way to current date, then add AND t.change_time <= 'YYYY-MM-DD HH:MM:SS' SELECT s.login, count( * ) FROM system_user s, ticket t WHERE s.id = t.user_id AND t.ticket_state_id = '2' AND t.change_time >= 'YYYY-MM-DD HH:MM:SS' GROUP BY s.login </snip> I also would like to get a report of closed tickets by user - however, our network admins lock down the database so that I can't access it via sql directly, so this statement, although it makes perfect sense, doesn't help me at all. Is there a way to achieve this using the "stats" functionality in OTRS itself? That would enable our end users to self-service this type of information. Perhaps there's a way to embed the sql somewhere in the stats page that I'm missing? Thanks in advance... Pags
_______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
