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!
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


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:
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.
Answered 01/03/2012 by: dchristian
Red Belt

Please log in to comment
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.
Answered 01/03/2012 by: GillySpy
Seventh Degree Black Belt

Please log in to comment