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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von > scusack > > Gesendet: Mittwoch, 3. Dezember 2008 17:46 > > An: [email protected] > > 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 >
_______________________________________________ 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
