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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] 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 [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> Subject: Re: [otrs] OTRS Reporting on WIndows 2003 with SQL To: "User questions and discussions about OTRS." <otrs@otrs.org> Message-ID: <[EMAIL PROTECTED]> 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 <[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: 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 > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.otrs.org/pipermail/otrs/attachments/20081204/f52d04c8/atta chment-0001.html> ------------------------------ Message: 2 Date: Thu, 04 Dec 2008 19:34:22 +0600 From: Boris Shirokov <[EMAIL PROTECTED]> Subject: [otrs] Some follow-ups are not received To: otrs@otrs.org Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=KOI8-R; format=flowed We have encountered the following problem. Some follow-ups do not reflect in OTRS - the system neither attach them to a correspondent ticket nor creates a new one. Nevertheless OTRS sends New ticket auto response with the wrong ticket number (like 2008120410000901, while our SystemID is 20). Of course no ticket in the system with this number. System Log has no info on the above action. OTRS ver.2.3.3. Is there any additional info I should provide? Boris ------------------------------ Message: 3 Date: Thu, 4 Dec 2008 09:13:50 -0500 From: "Aaron Rabinowitz" <[EMAIL PROTECTED]> Subject: Re: [otrs] Mailing issue (I believe) To: otrs@otrs.org Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1 any ideas? On Tue, Dec 2, 2008 at 3:53 PM, Aaron Rabinowitz <[EMAIL PROTECTED]> wrote: > Anytime I try to forward or mail anything from otrs it comes up with > the following error: > > __ > > Software error: > > Modification of a read-only value attempted at > /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Net/DNS/Que stion.pm > line 47. > > For help, please send mail to the webmaster ([EMAIL PROTECTED]), giving > this error message and the time and date of the error. > __ > > can anyone identify why this may be happening? could it by that I'm > missing some dependencies that didn't originally install? > > thanks in advance for your help! > > Aaron > ------------------------------ Message: 4 Date: Thu, 4 Dec 2008 16:11:25 +0100 From: "Michiel Beijen" <[EMAIL PROTECTED]> Subject: Re: [otrs] Mailing issue (I believe) To: "User questions and discussions about OTRS." <otrs@otrs.org> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=UTF-8 This seems to be a known error with Net::DNS version 0.60. You can use otrs.checkModules to see what version you have installed currently. The solution would be to upgrade Net::DNS to a version > 0.60. The current version of the module is 0.63. See also this OTRS bug: http://bugs.otrs.org/show_bug.cgi?id=2017 A workaround is to disable MX record checking. I wrote instructions for that in a post just yesterday: * log into OTRS with an administrator account * click on the Admin icon * navigate to SysConfig, under Misc * Search for MXRecord Now the Core group is displayed, which holds the setting for CheckMXRecord. If you select this you can adjust the configuration setting. -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Thu, Dec 4, 2008 at 3:13 PM, Aaron Rabinowitz <[EMAIL PROTECTED]> wrote: > any ideas? > > On Tue, Dec 2, 2008 at 3:53 PM, Aaron Rabinowitz <[EMAIL PROTECTED]> wrote: >> Anytime I try to forward or mail anything from otrs it comes up with >> the following error: >> >> __ >> >> Software error: >> >> Modification of a read-only value attempted at >> /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Net/DNS/Que stion.pm >> line 47. >> >> For help, please send mail to the webmaster ([EMAIL PROTECTED]), giving >> this error message and the time and date of the error. >> __ >> >> can anyone identify why this may be happening? could it by that I'm >> missing some dependencies that didn't originally install? >> >> thanks in advance for your help! >> >> Aaron >> > _______________________________________________ > 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 > ------------------------------ Message: 5 Date: Thu, 04 Dec 2008 10:56:30 -0500 From: Ugo Bellavance <[EMAIL PROTECTED]> Subject: Re: [otrs] Question about Ticketnotification To: otrs@otrs.org Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Glaab, Achim a ?crit : > Hi, > > is there a possibility to config the following feature? > > Out Users are getting informed about the status of their tickets, they > put into OTRS. > Is there a possibility to add an input item to the customer ticket form, > so that the customer can add an emailaddress, which is also informed > about any status changes of the ticket? I think this is already available. See the options in the Queue. Customer Move Notify: Customer State Notify: Customer Owner Notify: ------------------------------ Message: 6 Date: Thu, 04 Dec 2008 11:14:16 -0500 From: Ugo Bellavance <[EMAIL PROTECTED]> Subject: [otrs] Undesired CC: To: otrs@otrs.org Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hi, Here is the problem: Everytime I answer a ticket using "Compose Answer", the answer is sent to the requestor, but also to the e-mail address of our OTRS system. This has the benefit of informing everyone in the queue, but it has the very undesirable side-effect of re-opening a closed ticket. Is anyone else seeing the same thing? I've searched through all the configs and I couldn't find anything that would relate to these CC: Thanks, Ugo ------------------------------ Message: 7 Date: Thu, 4 Dec 2008 17:35:17 +0100 From: Sebastien Bourgasser <[EMAIL PROTECTED]> Subject: [otrs] Default subject value for customer follow up To: "otrs@otrs.org" <otrs@otrs.org> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="us-ascii" Hello the list, I'm trying to set a default value for the subject field of the CustomerTicketZoom form. The corresponding code is: <input type="text" name="Subject" value="$QData{"Subject"}" size="70"/> and $QData{"Subject"} is always empty. Is there a way to fill this variable with the content of the first article's subject to prevent the customer to set a new subject at each reply ? I tried to replace $QData{"Subject"} with $QData{"Article::Subject"} but it's always empty. Is there also a way to dump the content of $QData ? Thanks beforehand. -- Sebastien Bourgasser ------------------------------ _______________________________________________ otrs mailing list otrs@otrs.org http://lists.otrs.org/cgi-bin/listinfo/otrs End of otrs Digest, Vol 3, Issue 12 *********************************** _______________________________________________ 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