I am trying to find out where I can report on info stored in OTRS. I have found the subject heading of a ticket in the MySql DB. (this is in the `title` field in the `ticket` table.) Where can i find the actual e-mail text - the body of the e-mail pls. I have looked at a few ways of getting this info out but cannot find a suitable way of doing it. Anyone please help as I need to have the reporting sorted ASAP. Tks Andrew Arnold IT Support Analyst mailto:andrew.arnold@hammondsdirect.com This message is confidential and may be legally privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Copyright in documents created by or on behalf of this firm remains vested in the firm, and we assert our moral rights, unless the terms of our relevant client's engagement provide otherwise. HammondsDirect is regulated in the United Kingdom by the Law Society. The partners in the firm are either solicitors or registered foreign lawyers and a list of their names and professional qualifications can be inspected at Pennine House, Well Street, Bradford, BD1 5NU. This e-mail has been scanned for all viruses on behalf of HammondsDirect by Integralis e:scan.