Hello, My rt users have hit me with a rather.. unusual request. I'm not exactly sure how to get RT to do what they're asking.
Basically they want to generate a monthly report of times a comment was made on tickets in a queue. This alone I'm almost able to achieve through a mysql query. But they've thrown me a curve ball in that they also want listed the value of a custom field. Basically what they're looking for is something like this... -------------------------------------------------------------- | Queue 1 | datetime | value of custom field | | Queue 1 | datetime | value of custom field | | Queue 1 | datetime | value of custom field | | Queue 2 | datetime | value of custom field | | Queue 3 | datetime | value of custom field | | Queue 3 | datetime | value of custom field | -------------------------------------------------------------- Could anybody give me any type of direction as to how I could get this information from the database in the form of a mysql query?
-- RT Training - Boston, September 9-10 http://bestpractical.com/training