In addition to using the last 1 or 2 digits of the Request Id you also have access to a random number generator in your RDBMS. In SQL Server: "SELECT RAND()" You could build a stored procedure that included any additional criteria (ie. CTI, RSD, Summary text, Assigned Group, etc.) in choosing tickets, and then populate a table with ## records that included the Request Id and a flag field (ie. "Processed"). Your workflow would then process the unprocessed records according to a schedule. HTH Stephen
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Fariss, Ron Sent: Monday, May 21, 2007 4:51 PM To: [email protected] Subject: Re: Random request selection ** Matthew, We randomly select tickets to use to send surveys. However, the process depends on how esoteric you want to be when selecting random tickets. We select all tickets that end with a specific character, i.e.6. That gives us an approximately 10% of all tickets generated. This is not really random. You want ten per week. That means that you would need to know the average number of tickets generated in a week, in order to insure that you didn't select too many or too few tickets. If you create/resolve 2000 tickets in a weeks time, then you only need to select 0.5% of the total. If you select every ticket that ends in 19, you should end up with approximately 20 tickets. Then you might want to choose only the tickets with even 100's, i.e. 019, 219, 419, 619, etc. Hope this helps, Ron Fariss ________________________________ From: "Action Request System discussion list(ARSList)" [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Wollman Sent: Monday, May 21, 2007 10:42 AM To: [email protected] Subject: Random request selection ** 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] 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 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
