Re: Email Notifcation

2011-04-01 Thread Bala iLink
Subject: Re: Email Notifcation To: arslist@ARSLIST.ORG ** Hi, As Dwayne said one way to do it is through SQL. which i am already doing it to populate the number of open ticket against a consultants name. But not sure how to go with the Business hours. Yes we are using Business hours

Re: Email Notifcation

2011-04-01 Thread Nair, Rajesh SISPL
:18:03 +0200 From: nairraj...@siemens.com Subject: Re: Email Notifcation To: arslist@ARSLIST.ORG . ** Hi, As Dwayne said one way to do it is through SQL. which i am already doing it to populate the number of open ticket against a consultants name. But not sure how to go with the Business hours

Re: Email Notifcation

2011-04-01 Thread LJ LongWing
Of Nair, Rajesh SISPL Sent: Thursday, March 31, 2011 10:18 PM To: arslist@ARSLIST.ORG Subject: Re: Email Notifcation ** Hi, As Dwayne said one way to do it is through SQL. which i am already doing it to populate the number of open ticket against a consultants name. But not sure how to go

Re: Email Notifcation

2011-04-01 Thread Nair, Rajesh SISPL
Sounds good. Let me give it try. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Friday, April 01, 2011 7:13 PM To: arslist@arslist.org Subject: Re: Email Notifcation

Re: Email Notifcation

2011-04-01 Thread John Sundberg
way then SQL will be helpfull With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Bala iLink Sent: Friday, April 01, 2011 5:05 PM To: arslist@arslist.org Subject: Re: Email Notifcation ** Hi Rajesh I would suggest

Re: Email Notifcation

2011-04-01 Thread Shafqat Ayaz
tickets. Like i said a bit long winded, but should work. Shafqat Ayaz From: John Sundberg john.sundb...@kineticdata.com To: arslist@ARSLIST.ORG Sent: Fri, April 1, 2011 12:21:27 PM Subject: Re: Email Notifcation ** OK -- a totally

Re: Email Notifcation

2011-04-01 Thread Nair, Rajesh SISPL
discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of John Sundberg Sent: Saturday, April 02, 2011 12:51 AM To: arslist@arslist.org Subject: Re: Email Notifcation ** OK -- a totally different approach. (No SQL to do at all) (Something to this effect) In the email say: We look

Re: Email Notifcation

2011-03-31 Thread Martin, Dwayne - martinrd
Hi Rajesh, How about running an sql query, eg select count(*) from whatevertable where whateverconditions, then multiply that number by 20 or whatever. Dwayne Martin James Madison University From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nair,

Re: Email Notifcation

2011-03-31 Thread pritch
I've done a push field in a filter (that takes no action if no request matchesor any request matches) followed by an action that uses 'LASTCOUNT' * nn. On Thu, 31 Mar 2011 13:55:34 +, Martin, Dwayne - martinrd marti...@jmu.edu wrote: Hi Rajesh, How about running an sql query, eg select

Re: Email Notifcation

2011-03-31 Thread LJ LongWing
discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Martin, Dwayne - martinrd Sent: Thursday, March 31, 2011 7:56 AM To: arslist@ARSLIST.ORG Subject: Re: Email Notifcation ** Hi Rajesh, How about running an sql query, eg select count(*) from whatevertable where

Re: Email Notifcation

2011-03-31 Thread Nair, Rajesh SISPL
To: arslist@arslist.org Subject: Re: Email Notifcation ** Rajesh, If you have business hours setup, you could even take the count provided below and run it through a business time add function and take $TIMESTAMP$ as the start and add that many min's, that would give you a date/time that you would