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-bar...@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-bar...@tamu.edu Yahoo IM: chrisnbarnes > Computer Systems Manager MSN IM: ch...@txbarnes.com > Department of Physics ph: 979-845-1379 > Texas A&M University fax: 979-845-2590 >
