[rt-users] Searching for all tickets updated yesterday by a particular user

[Joe Harris]

I wrote a bash script to accomplish this exact task. The search queries within rt only support queries against the tickets table while transactions hold all relevant info on daily updates by a particular user. 

When I get a chance, I'll log into my office network, sanitize the script and post it. The one I wrote grabs all users in a group of my choosing and emails the entire list to all users in that group. 



Sent from my mobile device. 

On Mar 16, 2012, at 5:14 PM, 20/20 Lab <lab at pacbell.net> wrote:

> On 03/16/2012 9:35 AM, Thomas Smith wrote:
>> Hi,
>> 
>> I would like to search for all tickets updated yesterday by a particular user--I see the option to search "Last updated by", but this will only show if a given user was the last to touch a ticket.
>> 
>> Is there a way to search for all tickets that were updated by a given user on a given day?
>> 
>> ~ Tom
> 
> Click on new search.
> 
> You can select all your options on the left if your more comfy.
> ----------------
> LastUpdatedBy = 'user' AND Updated = '2012-03-15'
> ----------------
> However I dont think it will work once it has been updated by someone else.   ie, Ticket1:  Thing1 updated it yesterday because of an invoice received, Thing2 updated it today because of the items received.  Ticket one will then be excluded because it was updated today by a different user.
> 
> -Matt