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
stef@aoc-uk.com | stef@l5net.net
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
It sounds like something that could be done with the rt
commandline tool or a perl script using the RT API.
Cheers,
KenOn 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
stef@aoc-uk.com | stef@l5net.net
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
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com