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?
smime.p7s
Description: S/MIME cryptographic signature