I've heard of many ways to do this, but one I've used in the past worked fairly well...

I created an Escalation that had a Run-If of 'Create Date' > $DATE$ + 32400 and another Escalation that had a Run-If of 'Create Date' > $DATE$ + 54000. They were run on a form that had a copy of all of the fields I wanted to report on. A set fields action of Request ID != $NULL$ worked with If Multiple Entries Match: Use First Matching Request.

Once a week a report was generated from that form and the records were set to inactive.

At least that's how I remember it working!

Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]


Matthew Wollman wrote:
**
Is there a way to select random requests from a form? For example, we want to start doning random checks on the quality of our tickets. So we want to pick 10 random resolved tickets each week from our support-groups. I figured I could create a macro or AL to query the from with a date range, group range, and select 10 random and print them to my default printer with a specified report. I looked trhogh DAB and DAA and could not find a function or process to do a Random selection. Any ideas? My fallback plan is to search for resolved tickets in a date range and group range and export the results to excel, use excel RAND function get the ticket num bers and search on those in Remedy and print those out.
Matthew L. Wollman

Supervisor of Faculty & Staff Help Desk Services
Faculty of Arts & Sciences Computer Services
Office (617) 496-8947
Cell (617) 285-6952
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

Harvard University
1 Oxford Street
Science Center B14E
Cambridge, MA 02138

Would you like to comment about the service you receive from FASCS?
Now you can! An online survey is available at:
http://www.fas.harvard.edu/~fascs/survey.html <http://www.fas.harvard.edu/%7Efascs/survey.html>

__20060125_______________________This posting was submitted with HTML in it___

--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Reply via email to