Re: [otrs] otrs Digest, Vol 3, Issue 12

Team, Has anyone integrate OTRS with Active Directory 1) where OTRS is installed on windows and 2) OTRS is installed in Linux environment. If yes share the experience, and issues faced with it. Regards Vinayak -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of otrs-request@otrs.org Sent: Thursday, December 04, 2008 10:12 PM To: otrs@otrs.org Subject: otrs Digest, Vol 3, Issue 12 Send otrs mailing list submissions to otrs@otrs.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.otrs.org/cgi-bin/listinfo/otrs or, via email, send a message with subject or body 'help' to otrs-request@otrs.org You can reach the person managing the list at otrs-owner@otrs.org When replying, please edit your Subject line so it is more specific than "Re: Contents of otrs digest..." Today's Topics: 1. Re: OTRS Reporting on WIndows 2003 with SQL (Simon Cusack) 2. Some follow-ups are not received (Boris Shirokov) 3. Re: Mailing issue (I believe) (Aaron Rabinowitz) 4. Re: Mailing issue (I believe) (Michiel Beijen) 5. Re: Question about Ticketnotification (Ugo Bellavance) 6. Undesired CC: (Ugo Bellavance) 7. Default subject value for customer follow up (Sebastien Bourgasser) ---------------------------------------------------------------------- Message: 1 Date: Thu, 4 Dec 2008 16:44:32 +0430 From: "Simon Cusack" Subject: Re: [otrs] OTRS Reporting on WIndows 2003 with SQL To: "User questions and discussions about OTRS." Message-ID: <4dc6790c0812040414xc214c17ofe40ca7d55d38766@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" 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