I have what I call a diagnostic form where I create a record for the form / query I want to check the number of records on. An escalation runs periodically to do the query needed and then I move the $LASTCOUNT$ keyword into a field on that form. The count can then be emailed or acted on by filters if it's over a threshold (another field on the diagnostic form).
Just my way of doing it without needing additional software. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Tuesday, September 9, 2014 8:28 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation qualification : DSO I'm not sure what sort of problem you are having at the DB level, but have you tried putting this escalation into its own escalation pool? I'd give that a try and change it to run every 24 hours instead of every 30 minutes. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of MalviyaSaurabh Sent: Tuesday, September 09, 2014 12:49 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation qualification : DSO Thanks for all your reply. One more clarification which I am seeking out is that my escalation runs on every 30 mins, and I can see records coming into the DSO pending queue in the DSO Pending form, I would want to know from where i can get to how many records are qualified in each execution of this escalation. From my manual analysis of Pending form, after an execution the number of records in DSO Pending form reaches a maximum and then the records goes down to zero as it gets services by DSO. Also if I have to get the same functionality via rrrchive tool (i.e. automate restricted qualification to new 500 records in ( 'Ticket Closed Date' <= "2/28/2009 11:59:59 PM") AND ( 'Status' = "Closed") AND ( 'Ticket Closed Date' >= "1/1/2009 12:00:00 AM") qualification) what parameter I would be using. qual = ( 'Ticket Closed Date' <= "2/28/2009 11:59:59 PM") AND ( 'Status' = "Closed") AND ( 'Ticket Closed Date' >= "1/1/2009 12:00:00 AM") transfertype = MOVE Will using below help in my case or do I have to chose any other parameter. Please help. multientrychunksize = 500 Regards, Saurabh -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Escalation-qualification-DS O-tp118847p118864.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4765 / Virus Database: 4015/8175 - Release Date: 09/08/14 ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"