Re: Email Notifcation
Hi Rajesh I would suggest to configure the minutes required for resolving an incident in a field and either use sql query or a hidden table to count the no of records and then multiply with value in the field Thanks Bala Date: Fri, 1 Apr 2011 06: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. Yes we are using Business hours and Holidays for SLA's LJ, can you please eloborate a little about this. I am not able to get the concept right. May be i not thinking the the way you are. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 7:57 PM 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 expect to get to it… From: Action Request System 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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Email Notifcation
As is said SQL is one way. Using table count, i am not that comfortable and does not sound to me a good solution as i need to run a refresh each time a request is raised. This will lead to unnecessary slowing down of the system. In a day total of approx 2k tickets are raised. If any one can think of better and easy 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 to configure the minutes required for resolving an incident in a field and either use sql query or a hidden table to count the no of records and then multiply with value in the field Thanks Bala Date: Fri, 1 Apr 2011 06: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. Yes we are using Business hours and Holidays for SLA's LJ, can you please eloborate a little about this. I am not able to get the concept right. May be i not thinking the the way you are. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 7:57 PM 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 expect to get to it... From: Action Request System 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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Email Notifcation
Rajesh, Here is the basics of it.. 1 - perform a look up to calculate how many orders you currently have 2 - perform the multiplication of how many hours you think each will take 3 - perform a Business Time add..below is a snipit from the workflow guide Application-Bus-Time-Add startTime [ amount [ amountUnits [ holidayScheduleName [ workdayScheduleName ] ] ] ] Returns a new time that is the requested offset into the future, taking availability and business hours and holidays into account. Offset is a value of 0 or greater than 0. The default is 1 hour. Offset unit values are: 1-Seconds 2-Minutes 3-Hours 4-Days For more information, see the Configuration Guide. So what you would be looking for is to take 'now', and add the # of hours calculated in #2 above..so your end process would be something like below Application-Bus-Time-Add $TIMESTAMP value calculated in #2 above 3 holidayScheduleName workdayScheduleName This command would be a setfield process command and the output would be the date/time you expect you would be able to get to the ticket. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf 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 with the Business hours. Yes we are using Business hours and Holidays for SLA's LJ, can you please eloborate a little about this. I am not able to get the concept right. May be i not thinking the the way you are. With Best Regards Rajesh _ From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 7:57 PM 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 expect to get to it. From: Action Request System 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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Email Notifcation
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 ** Rajesh, Here is the basics of it 1 - perform a look up to calculate how many orders you currently have 2 - perform the multiplication of how many hours you think each will take 3 - perform a Business Time addbelow is a snipit from the workflow guide Application-Bus-Time-Add startTime [ amount [ amountUnits [ holidayScheduleName [ workdayScheduleName ] ] ] ] Returns a new time that is the requested offset into the future, taking availability and business hours and holidays into account. Offset is a value of 0 or greater than 0. The default is 1 hour. Offset unit values are: 1-Seconds 2-Minutes 3-Hours 4-Days For more information, see the Configuration Guide. So what you would be looking for is to take 'now', and add the # of hours calculated in #2 aboveso your end process would be something like below Application-Bus-Time-Add $TIMESTAMP value calculated in #2 above 3 holidayScheduleName workdayScheduleName This command would be a setfield process command and the output would be the date/time you expect you would be able to get to the ticket. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf 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 with the Business hours. Yes we are using Business hours and Holidays for SLA's LJ, can you please eloborate a little about this. I am not able to get the concept right. May be i not thinking the the way you are. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 7:57 PM 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 expect to get to it... From: Action Request System 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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Email Notifcation
OK -- a totally different approach. (No SQL to do at all) (Something to this effect) In the email say: We look forward to helping you out shortly. Typically - these calls average about 20 minutes to help somebody get back on their feet with their issue. However - sometimes we have a couple calls stacked up - but that is fairly rare. Our stats show 95% of the time we help people with 30 minutes of reporting the problem. We look forward to resolving your issue. Thanks, -Your lovely support team On Apr 1, 2011, at 7:41 AM, Nair, Rajesh SISPL wrote: ** As is said SQL is one way. Using table count, i am not that comfortable and does not sound to me a good solution as i need to run a refresh each time a request is raised. This will lead to unnecessary slowing down of the system. In a day total of approx 2k tickets are raised. If any one can think of better and easy 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 to configure the minutes required for resolving an incident in a field and either use sql query or a hidden table to count the no of records and then multiply with value in the field Thanks Bala Date: Fri, 1 Apr 2011 06: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. Yes we are using Business hours and Holidays for SLA's LJ, can you please eloborate a little about this. I am not able to get the concept right. May be i not thinking the the way you are. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 7:57 PM 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 expect to get to it… From: Action Request System 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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Email Notifcation
Another approach. Maybe slightly long winded and may even not be practical. Depends on how badly you need this solution. Create a form. Every time a ticket is assigned to a group, create an entry in this form. when sending out the email, you can they query this form to see how many current tickets are assigned to a group, multiply the number of tickets by 20 and use the Business time functions to get a date and time when the ticket will be attended to. You will of course have to make sure that you update the form with the status of the ticket. Run a weekly escalation to delete closed 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 different approach. (No SQL to do at all) (Something to this effect) In the email say: We look forward to helping you out shortly. Typically - these calls average about 20 minutes to help somebody get back on their feet with their issue. However - sometimes we have a couple calls stacked up - but that is fairly rare. Our stats show 95% of the time we help people with 30 minutes of reporting the problem. We look forward to resolving your issue. Thanks, -Your lovely support team On Apr 1, 2011, at 7:41 AM, Nair, Rajesh SISPL wrote: ** As is said SQL is one way. Using table count, i am not that comfortable and does not sound to me a good solution as i need to run a refresh each time a request is raised. This will lead to unnecessary slowing down of the system. In a day total of approx 2k tickets are raised. If any one can think of better and easy 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 to configure the minutes required for resolving an incident in a field and either use sql query or a hidden table to count the no of records and then multiply with value in the field Thanks Bala Date: Fri, 1 Apr 2011 06: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. Yes we are using Business hours and Holidays for SLA's LJ, can you please eloborate a little about this. I am not able to get the concept right. May be i not thinking the the way you are. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 7:57 PM 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 expect to get to it… From:Action Request System 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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh
Re: Email Notifcation
Hey John, Thats what we already have in over email format. NOw the question is what if call is not attended to in 30 min. What happen the end user either call back or send a mail to the service desk saying no on has attended the call. For end user all calls are Urgent Priority call With Best Regards Rajesh Nair Siemens IT Solutions and Services GmbH SIS GO GAA GPC IN HCC 247 Park, Hincon House, Tower-A, 8-10th floor, LBS Road, Vikhroli (West), Mumbai 400 083, INDIA Desk : +91 22 3937 2027 mailto:nairraj...@siemens.com From: Action Request System 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 forward to helping you out shortly. Typically - these calls average about 20 minutes to help somebody get back on their feet with their issue. However - sometimes we have a couple calls stacked up - but that is fairly rare. Our stats show 95% of the time we help people with 30 minutes of reporting the problem. We look forward to resolving your issue. Thanks, -Your lovely support team On Apr 1, 2011, at 7:41 AM, Nair, Rajesh SISPL wrote: ** As is said SQL is one way. Using table count, i am not that comfortable and does not sound to me a good solution as i need to run a refresh each time a request is raised. This will lead to unnecessary slowing down of the system. In a day total of approx 2k tickets are raised. If any one can think of better and easy 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.orgmailto:arslist@arslist.org Subject: Re: Email Notifcation ** Hi Rajesh I would suggest to configure the minutes required for resolving an incident in a field and either use sql query or a hidden table to count the no of records and then multiply with value in the field Thanks Bala Date: Fri, 1 Apr 2011 06:18:03 +0200 From: nairraj...@siemens.commailto:nairraj...@siemens.com Subject: Re: Email Notifcation To: arslist@ARSLIST.ORGmailto: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 and Holidays for SLA's LJ, can you please eloborate a little about this. I am not able to get the concept right. May be i not thinking the the way you are. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 7:57 PM To: arslist@arslist.orgmailto: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 expect to get to it... From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Martin, Dwayne - martinrd Sent: Thursday, March 31, 2011 7:56 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Email Notifcation ** 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11
Re: Email Notifcation
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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Email Notifcation
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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
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 expect to get to it. From: Action Request System 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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
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 with the Business hours. Yes we are using Business hours and Holidays for SLA's LJ, can you please eloborate a little about this. I am not able to get the concept right. May be i not thinking the the way you are. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, March 31, 2011 7:57 PM 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 expect to get to it... From: Action Request System 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 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, Rajesh SISPL Sent: Thursday, March 31, 2011 9:23 AM To: arslist@ARSLIST.ORG Subject: Email Notifcation ** Dear List, Am working on a older version 6.3 patch 24 on Oracle 9i Just got a requirement, so thought of listing out to the experts out here We have a HTML formatted mail which are being send to the end user. Now the requirement is :- Say Service Desk assings the ticket to the Group A and this Group A already have a list of ticket which are being worked upon say 10 open tickets. When a new ticket comes in to this group a mail should trigger to the user saying the ticket will be attended to in so and so time. The scenario is if one ticket takes approx say 20 minutes to work upon the 11th ticket should send in a time say 11*20 i.e 220 minutes so the end user should get a mail saying your call will be attended in 220 minutes.(20 minutes is not a realtime figure but taking 20 minutes a becnhmark time for resolution) Any idea how can this be done With Best Regards Rajesh _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are