[rt-users] search by CommentedOnBy?

[Kenneth Crocker]

Chris,

We do something similar to Payam. We have an Oracle DataBase so we created a
"view" of the RT data to allow us to use COGNOS (or other reporting
software) to create reports from RT data. Works great.

Kenn
LBNL

On Fri, Feb 11, 2011 at 1:32 AM, Payam Poursaied <payam at 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 <hiro24 at gmail.com>
> To: rt-users at 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?
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110211/030ecba4/attachment.htm>