Email Alerts to Dynamic Recipients
Hey Everyone,
I tried looking for a few variants of this question but I wasn't able to find much information.
The basic scenario is this:
I have inputted a few different types of assets that could be loaned out. These loaner assets have a 'due back by' date. I wanted to have an alert run that picks up any assets that haven't been returned (IE the current date > the due back by date) and have the email alert fire off an email to the specific user associated with the item that was borrowed.
I'm not so much having a problem with getting results if the current date > the due back by date, but I was wondering how to configure the email alert to send to dynamic recipients, IE any person that doesn't return an item. The email alerts just have a field for Email Recipients but obviously I would want to send individual emails to each person returned by the query and say hey you need to return x item to the IT department.
Thanks in advance for any insight!
I tried looking for a few variants of this question but I wasn't able to find much information.
The basic scenario is this:
I have inputted a few different types of assets that could be loaned out. These loaner assets have a 'due back by' date. I wanted to have an alert run that picks up any assets that haven't been returned (IE the current date > the due back by date) and have the email alert fire off an email to the specific user associated with the item that was borrowed.
I'm not so much having a problem with getting results if the current date > the due back by date, but I was wondering how to configure the email alert to send to dynamic recipients, IE any person that doesn't return an item. The email alerts just have a field for Email Recipients but obviously I would want to send individual emails to each person returned by the query and say hey you need to return x item to the IT department.
Thanks in advance for any insight!
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
dchristian
12 years ago
You could do this with a custom helpdesk rule.
Take a look at the send an email for each result row.
Here's the help:
You could write a custom sql statement that checks your assets then shoots the email.
Take a look at the send an email for each result row.
Here's the help:
This rule assumes that the Select Query will return a column that will contain an email address, and that you want to send a mail to that address. Basically, for each resulting row from the 'Select Query' statement, the text in the 'Email Body' will be sent to the recipients from the field 'Email Column'.
Variables will be replaced in the subject and body of the email. Strings like $title and $due_date will be replaced by the values in the columns names TITLE and DUE_DATE respectively. Lowercase with a dollar sign on the front. Any column returned by the select statement can be replaced in that way.
The SQL generated by the Ticket Rule Wizard will supply OWNER_EMAIL and SUBMITTER_EMAIL as well as CC_LIST as possible values.You could write a custom sql statement that checks your assets then shoots the email.
Posted by:
GillySpy
12 years ago
How do you associate a user with an item: Are they a user record tied to an asset record? Is the loan process managed in a servicedesk queue so each borrowing instance is tracked by a ticket?
In both cases you'll probably have a ticket rule. That latter (with a queue) is probably a mechanism easier to manage the whole process. Tickets can be associated with an asset for example.
In both cases you'll probably have a ticket rule. That latter (with a queue) is probably a mechanism easier to manage the whole process. Tickets can be associated with an asset for example.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
