Thanks! That looks like it's giving me what I'm looking for.. now I just need to find a way to integrate it into RT.
On Fri, Feb 11, 2011 at 4:32 AM, Payam Poursaied <pa...@rasana.net> wrote: > You could start by database > > select > > Transactions.id,ObjectType,ObjectId,Type,Transactions.Created,Name,EmailAddr > ess from Transactions > inner join Users on Users.id=Transactions.Creator > where ObjectType='RT::Ticket' and Type='Comment' and > Transactins.Created>='YYYY-MM-DD HH:MM:SS' and > Transactions.Created<='YYYY-MM-DD HH:MM:SS'; > > But be aware of 2 things: > First: the time is not your localtime, it is GMT0 > second: if someone rather than your support team is allowed to comment on > tickets, you would have them in the report > > > > > Date: Thu, 10 Feb 2011 16:25:10 -0500 > From: Chris Hall <hir...@gmail.com> > To: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] search by CommentedOnBy? > > I hate to necro an old, dead thread but.. this seems to have come up > again.. > from two separate people. I did figure out if I edited the advanced > section > and added __CommentedOnBy__ I could at least see who the last person was to > comment on a ticket, but here's my current problem: > > Helpdesk manager person has some software that spits out how many calls a > given worker does, and wants to compare this with the RT records. For > example, Worker A takes 54 calls in a night. Helpdesk manager person wants > to check the RT records to see if he has made 54 comments for that given > night. Kind of a making sure ppl are doing what they're supposed to be > doing. > > So sometime before the end of the month, I need to figure out a way to form > a query to show all comments in a given month. Maybe not "show" them, but > just a list to say... Worker A commented on the following tickets this > month. > > Does anybody have any suggestions where I could start with something like > this? > >
