Have you tried otrs-manager ? version 0.5.1 generates a agent/ticket
table stat in word, there should be easy applying a vbmacro to create
a grafical stat one, this could just an option with it.
the link to that tool: otrs-manager.sourceforge.net/index.php?page=homepage_en
On Thu, Aug 14, 2008 at 9:08 AM, John (yt) Hogenmiller
Ok,
So if I go into the SQL box and run a query, I can pull up how many "work units" each agent accumulated in the current month:
SELECT t.create_by, u.first_name, u.last_name, Sum(t.time_unit) FROM time_accounting AS t Left Join system_user AS u ON t.create_by = u.id WHERE month(t.create_time) = '08' AND year(t.create_time) = '2008' GROUP BY t.create_by
However, for the life of me, I don't see how to create a report showing the same.
So I'm looking for any report gurus out there or some good documentation/howtos on the subject.
Also, has anyone gone into using an outside program to pull reports from OTRS (like Crystal Reports or DataVision)?
-John
-- John Hogenmiller - ytjohn@gmail.com Used for mailing lists - sporadic response _______________________________________________ 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/
-- Marco Vannini home: +39 02 900091454 mobile: +39 335 5340819 msn: marco69v@hotmail.com talk: marco.vannini@gmail.com icq: 58389316 skype: marco69v