[rt-users] monthly reports?

[Kenneth Crocker]

Chris,

Yes, we have one like that called our "Open Tasks List".

Have you used RT Query before? The criteria should be relatively easy;

   - No Queue selection unless a CF is needed as a display field
   - Status "isn't" resolved and "isn't "rejected"

That's it for criteria. Then just run it.

To get it to run monthly, set up a dashboard and set the "Subscription"
frequency to monthly on the first or last day, your preference.

Hope this helps.

Kenn
LBNL

On Thu, Feb 3, 2011 at 9:57 AM, Chris Barnes <chris-barnes at tamu.edu> wrote:

> I am trying to figure out how to do a monthly report for the activity we
> had go through RT, and I am having a devil of a time trying to figure out
> how to build my query.
>
> Basically I want any ticket included which was open, stalled, or new at ANY
> point during the month of January.   Said another way, I do NOT want it to
> include tickets which were open then resolved prior to January 1, nor new
> tickets since the beginning of Feb.
>
>
> Surely this is the kind of report that other folks are running on a routine
> basis, right?
>
> --
> Chris Barnes                           AOL IM: CNBarnes
> chris-barnes at tamu.edu                Yahoo IM: chrisnbarnes
> Computer Systems Manager               MSN IM: chris at txbarnes.com
> Department of Physics                      ph: 979-845-1379
> Texas A&M University                      fax: 979-845-2590
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110203/7daaf64f/attachment.htm>