Re: [otrs] OTRS Reporting on WIndows 2003 with SQL

What Ive done is basically gone to search and look at open tickets, closed tickets and do a search for what I need. I then export as a csv and throw it into Excel. It will display the following information by default: TicketNumber Age Created State Priority Queue Lock Owner UserFirstname UserLastname From Subject On Thu, Dec 4, 2008 at 2:05 PM, Marco Vannini wrote:

Either for this issue I've found otrs-manager usefull.

www dot tokaware dot com

On Wed, Dec 3, 2008 at 6:01 PM, Obee, Daniel wrote:

...

There's no ready-made reports of reason as far as I can see.

I use a couple of reports did with Toad and then exported them to excel with the ODBC connection. Thus it just takes me a couple of clicks to get the actual data. With Toad the export of SQLs including Pivot tables is a non-brainer, so I really can recommend the (Freeware) program for such matters.

Greez Daniel

-----Ursprüngliche Nachricht----- Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von scusack Gesendet: Mittwoch, 3. Dezember 2008 17:46 An: otrs@otrs.org Betreff: [otrs] OTRS Reporting on WIndows 2003 with SQL

Has anyone created any type of reporting for OTRS? Is their a package you can install or anything out there at the moment. I see most people are just running reports by exporting information from the SQl database. If anyone has setup anything that would save me time that would be great.

Thanks _______________________________________________ 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 _______________________________________________ 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

_______________________________________________ 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