We are in the process of cleaning up our otrs database what I would like to do is find all tickets that are (say) Older then 1 year state == new |\ state == open and bulk-action close them. Is there an easy way to do this ? I guess I can generate a search query export the csv file and then extract the ticket numbers out of that then use a mysql query 9which one ?) to close all tickets that match the numbers generated but I have the feeling there must be an easier way. unfortunetely, the result of a search query miss the [ ] select this ticket for bulk action tick box. Im using otrs 2.2.5 Kind regards, Fugro-Jason Netherlands BV Gerhard den Hollander Senior ICT Engineer Telephone: +31 (0)70 3170 539 / Fax: +31 (0)70 3170 511 E-mail: gdenhollander@fugro-jason.com / Website: www.fugro-jason.com http://www.fugro-jason.com/ Address: Veurse Achterweg 10, 2264 SG Leidschendam, The Netherlands / P.O. Box 35, 2260 AA Leidschendam, The Netherlands Trade Register Nr: 24294747 / VAT: NL 00807174798 B01