Re: [otrs] Export name and email adresses to a CSV file

On Wed, 8 Feb 2012 15:46:03 +0100, Andy Wodfer wrote:

Hi, We're running OTRS 2.4.7 currently.

I need to export all names and email adresses from tickets (from senders) in 2 different OTRS folders/mailboxes.

The csv file needs to be in the following format: name, email

Are there any plugins for OTRS that can do this or can someone give me some input on how to do this the best way?

Hi, You have the possibility to gather this data by a SQL statement from the otrs database: SELECT DISTINCT(a_from) FROM article; hth, Roy -- Roy Kaldung e-mail: roy@kaldung.com