Automate Reports by Email?

Quick question. Is there a way / a module / a something - to generate a
textual report of RT tickets on an regular basis and have them emailed? I
know I can create a cron job to call something, even have that job packup
the data and email it… but getting specific data out of RT is the portion
I’m unaware of. Basically my boss would like to me make something that
will, in effect, run a saved search every day and email them the results (So
they can tell if I’ve been slacking off).

Thanks in advance
-Jon

You want Dashboards, which first appeared in RT 3.8.0. They can email
out reports based on ticket searches, graphs, etc.

See: http://wiki.bestpractical.com/view/ManualDashboards

ThomasOn 26 Oct 2010 14:25, Jon Davis wrote:

Quick question. Is there a way / a module / a something - to generate a
textual report of RT tickets on an regular basis and have them emailed?
I know I can create a cron job to call something, even have that job
packup the data and email it… but getting specific data out of RT is
the portion I’m unaware of. Basically my boss would like to me make
something that will, in effect, run a saved search every day and email
them the results (So they can tell if I’ve been slacking off).

Thanks in advance
-Jon

Hey guys,

So, I defined PreferRichText to allow HTML messages through RT when
customers email from their Outlook clients or similar which use
recursive HTML formatting unless otherwise specified.

Unfortunately, RT is pretty vague on how certain flags are set so I’m
just blindly stumbling around the config right now…

When I send a test email which is formatted with a ridiculous amount of
HTML, I get this:

[Tue Oct 26 18:25:06 2010] [info]:
rt-3.8.8-3015-1288117506-538.4053-2-0@domain.ca #4053/62589 - Scrip 2
On Owner Change Notify Owner (/opt/rt3/lib/RT/Action/SendEmail.pm:300)
[Tue Oct 26 18:25:06 2010] [info]:
rt-3.8.8-3015-1288117506-538.4053-2-0@domain.ca sent To:
kris_germann@295.ca (/opt/rt3/lib/RT/Action/SendEmail.pm:331)
[Tue Oct 26 18:25:07 2010] [warning]: Resolver RT::URI::freeside could
not parse freeside://freeside/cust_main/ (/opt/rt3/lib/RT/URI.pm:147)

Anyone have any insight?

Kris
Fibernetics Corp

Hey guys,

So, I defined PreferRichText to allow HTML messages through RT when
customers email from their Outlook clients or similar which use
recursive HTML formatting unless otherwise specified.

Unfortunately, RT is pretty vague on how certain flags are set so I’m
just blindly stumbling around the config right now…

When I send a test email which is formatted with a ridiculous amount of
HTML, I get this:

[Tue Oct 26 18:25:06 2010] [info]:
rt-3.8.8-3015-1288117506-538.4053-2-0@domain.ca #4053/62589 - Scrip 2
On Owner Change Notify Owner (/opt/rt3/lib/RT/Action/SendEmail.pm:300)
[Tue Oct 26 18:25:06 2010] [info]:
rt-3.8.8-3015-1288117506-538.4053-2-0@domain.ca sent To:
kris_germann@295.ca (/opt/rt3/lib/RT/Action/SendEmail.pm:331)
[Tue Oct 26 18:25:07 2010] [warning]: Resolver RT::URI::freeside could
not parse freeside://freeside/cust_main/ (/opt/rt3/lib/RT/URI.pm:147)

Anyone have any insight?

Kris
Fibernetics Corp

Actually, you can ignore that… The line originally defined as
’Set($PreferRichText, undef);’ got me thinking, I had seen some other
lines without the ‘, undef’ while digging through another issue here, so
that is what I did first. I guess it broke it. After a little more
looking, I decided to change undef to 1 and voila, now HTML works on
incoming correspondence!..

No size formatting though, guess I can live without it.

Kris
Mentor, Sales & Technical Support
Fibernetics Corp
605 Boxwood Drive
Cambridge, ON N3E1A5On 10/26/2010 03:07 PM, Kris Germann wrote:

Hey guys,

So, I defined PreferRichText to allow HTML messages through RT when
customers email from their Outlook clients or similar which use
recursive HTML formatting unless otherwise specified.

Unfortunately, RT is pretty vague on how certain flags are set so I’m
just blindly stumbling around the config right now…

When I send a test email which is formatted with a ridiculous amount
of HTML, I get this:

[Tue Oct 26 18:25:06 2010] [info]:
rt-3.8.8-3015-1288117506-538.4053-2-0@domain.ca #4053/62589 - Scrip
2 On Owner Change Notify Owner (/opt/rt3/lib/RT/Action/SendEmail.pm:300)
[Tue Oct 26 18:25:06 2010] [info]:
rt-3.8.8-3015-1288117506-538.4053-2-0@domain.ca sent To:
kris_germann@295.ca (/opt/rt3/lib/RT/Action/SendEmail.pm:331)
[Tue Oct 26 18:25:07 2010] [warning]: Resolver RT::URI::freeside could
not parse freeside://freeside/cust_main/ (/opt/rt3/lib/RT/URI.pm:147)

Anyone have any insight?

Kris
Fibernetics Corp