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 |
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 <obee@myhammer.de> 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