It sounds like something that could be done with the rt commandline tool or a perl script using the RT API.
Cheers, Ken On Thu, Feb 28, 2008 at 07:09:42PM -0000, Stef Morrell wrote: > Hi, > > I've been back over the lists and I can't find any reference to this, so > I'm probably asking a stupid question. > > I'm in the process of setting up RT as a replacement to an old (largely > broken) in-house ticketing system, coded by a long since gone employee, > but I've hit a stumbling block. > > I need to be able to produce a report each month which shows the full > history on any open tickets or any tickets closed in the month. > > I'm hoping there is something I can do in a query, but the more I fiddle > with it, the more my hope is fading and I'm wondering if I need to be > looking at a scrip, or perhaps a complex SQL query. > > I wonder if anyone on the list has already solved this or a similar > problem and can point me in the right direction? > > Regards > > Stef > Stefan Morrell | Operations Director > Tel: 0845 3452820 | Alpha Omega Computers Ltd > Fax: 0845 3452830 | Incorporating Level 5 Internet > [EMAIL PROTECTED] | [EMAIL PROTECTED] > > Alpha Omega Computers LTD computer network solution providers putting > the technology in place that makes your information work for you. Visit > our website for more information about how Alpha Omega can enhance your > business. IMPORTANT: This E-Mail is confidential and may also be > privileged. If you are not the intended recipient, please notify us > immediately by telephoning +44 (0) 845 345 2820. Internet communications > are not necessarily secure and may be intercepted or changed after they > are sent. Alpha Omega Computers LTD does not accept liability for any > such changes. If you wish to confirm the origin or content of this > communication, please contact the sender using an alternative means of > communication. In messages of a non-business nature, the views and > opinions of the author are their own and do not necessarily reflect the > views and opinions of the organisation. > > Alpha Omega Computers Ltd, Unit 57, BBTC, Grange Road, Batley, WF17 6ER. > Registered in England No. 3867142. VAT No. GB734421454 > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
