Hi all,
I'd like to remove attachments older than x months from the database
and thought probably rt-shredder is the tool for this (its not something
I've used before). Having googled this a bit and checked "rt-shredder
--plugin help-Attachments" for instructions it looks like it may not be
pos
you can shred based on sql query, such as
./rt-shredder --plugin "Tickets=query,Queue = 'Support' and Status =
'deleted';limit,5000" --sqldump /root/bup9.sql --force
...so you can change the query as you see fit.
On 19-Dec-16 2:38 PM, Andy Smith wrote:
>
> Hi all,
>
> I'd like to remove attac
Hi all,
I'm using the Activity Report function that Best practical was kind enough to
update for the 4.4.x release, however it has its short comings when other than
me need to create them and understand them + lack automation.
I'm curious on how you guys are extracting stats from your RT systems
Hi list,
Where do I put custom conditions for rt-crontool? I'm trying to get
UntouchedInHours to work. Its page says to place it in local/RT/bin/... But
I have no bin inside local/RT. I'm assuming that, like so many Wiki pages,
this is simply not updated for the newer RT versions? What's the right
Le 19/12/2016 à 17:07, Alex Hall a écrit :
> Hi list,
> Where do I put custom conditions for rt-crontool? I'm trying to get
> UntouchedInHours to work. Its page says to place it in
> local/RT/bin/... But I have no bin inside local/RT. I'm assuming that,
> like so many Wiki pages, this is simply not
Thanks, I now have a Condition folder alongside the Interface folder.
Sorry; in my previous message, I mistyped the directory quite badly. That's
what I get for going from memory.
On Mon, Dec 19, 2016 at 11:26 AM, Emmanuel Lacour
wrote:
> Le 19/12/2016 à 17:07, Alex Hall a écrit :
> > Hi list,
>
On 2016-12-19, JON 'BOLI' COPELAND wrote:
> you can shred based on sql query, such as
>
> ./rt-shredder --plugin "Tickets=query,Queue = 'Support' and Status =
> 'deleted';limit,5000" --sqldump /root/bup9.sql --force
>
> ...so you can change the query as you see fit.
Hi Jon,
thanks for your
Hi All,
I've searched long and hard, but to my surprise not found anything that
relates to external templates - maybe it's so trivially obvious that the
question is a non question, but i have to ask it.
i have externalised customfields, conditions, actions etc. but
templates, especially thos
I'm almost positive I ran that, and the page says I could end up with data
duplication if I run it again. Is there a query I could run in the database
to check, so I can know for sure? Thanks.
On Fri, Dec 16, 2016 at 8:53 PM, Todd Wade wrote:
> On 12/16/16 3:57 PM, Alex Hall wrote:
>
>> Ever sin
Hello all,
I'm trying to get stale ticket alerts working, so am using the
UntouchedInHours condition. I've also tried, in SQL:
LastUpdated <= '2 days ago'
and similar searches. Yet, I always get the same number of tickets as I get
when I leave the date restriction off completely, and UntouchedInHou
Hi Alex,
On Mon, Dec 19, 2016 at 12:54 PM, Alex Hall wrote:
> Hello all,
> I'm trying to get stale ticket alerts working, so am using the
> UntouchedInHours condition. I've also tried, in SQL:
> LastUpdated <= '2 days ago'
> and similar searches. Yet, I always get the same number of tickets as I
Hi Alex,
On Mon, Dec 19, 2016 at 12:07 PM, Alex Hall wrote:
> I'm almost positive I ran that, and the page says I could end up with data
> duplication if I run it again. Is there a query I could run in the database
> to check, so I can know for sure? Thanks.
Check the initialdata file for the ex
I'm using the Crontool, yes, but I've also been doing searches on the web
interface to see if I could get this to work. My Crontool syntax is
something like:
/opt/rt4/bin/rt-crontool --search RT::Search::FromSQL \
--search-arg "status != 'resolved' and LastUpdated <= '3 days ago'" \
--action RT::A
Well, I found something that works. It's not UntouchedInHours, but this
query seems to return what I want:
select id
from Tickets
where LastUpdated <= (now() - INTERVAL 10 DAYS);
I still have to work out how to email ticket owners, but at least I can get
the right tickets now. Odd that the other
On Dec 19, 2016, at 11:48 AM, Alex Hall
mailto:ah...@autodist.com>> wrote:
I'm using the Crontool, yes, but I've also been doing searches on the web
interface to see if I could get this to work. My Crontool syntax is something
like:
/opt/rt4/bin/rt-crontool --search RT::Search::FromSQL \
--se
Hey Woody,
I haven't encountered external templates. Obviously, anything is
possible - but I don't know the best solution for your problem.
-m
On Mon, Dec 19, 2016 at 11:14 AM, Woody - Wild Thing Safaris
wrote:
> Hi All,
>
> I've searched long and hard, but to my surprise not found anything tha
Hi all,
Now that I'm getting the tickets I want, I'm trying to email the owners of
those tickets. After my search and search-arg parameters for rt-crontool,
I'm doing this:
--action RT::Action::NotifyOwnerOrAdminCc \
--template "untouched ticket"
I'm missing --action-arg, but I don't know what to
Alex, could it be an accidental reversal of > and < ?
I think LastUpdated >= '3 days ago' is more of the intent because you were
surprised of seeing tickets which were updated within the past day.
Aaron
> On Dec 19, 2016, at 12:32 PM, Alex Hall wrote:
>
> Well, I found something that works
Nevermind, I tried this in testing on 4.2 and it didn't fix it. I was thinking
perhaps the human readable parsing was changing how the date was considered,
but it doesn't seem to be the case.
Aaron
> On Dec 19, 2016, at 3:16 PM, Aaron McCormack wrote:
>
> Alex, could it be an accidental reve
19 matches
Mail list logo
