Hi Roger,
In case you don't have enough options yet, I too
have done something similar. My
escalation executes a notify action. The text field something like this:
Schema: mySchema
Server: $SERVER$
User: myMailUser
Key: myKey
Action: Query
Result Template: myResultTemplate
Qualification: '('7' = "Unassigned" OR
'7' = "Open" OR '7' = "Re-Opened" )
At 08:50 AM 3/17/2008, you wrote:
**
I have done something similar,
Form A
When your condition is true Push
a record to Form B. (Creating only record a day)
Pushing Form Name, Case Number, Name, Location, Account, etc
This is pushed to a temp field,
which then is appended to the body of the email (Field)
Controlling the format how you wish
Once a night, an escalation runs
and emails the record (with all the entries
listed and formatted within the Body
This is one approach I have used
Doug
----------
From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger
Sent: Monday, March 17, 2008 10:12 AM
To: arslist@ARSLIST.ORG
Subject: Email Multiple Records
I have a request to email multiple records once
a day. Basically, I will be inactivating
accounts and I need to send one email with a
list of all affected accounts. The email will
include name and location. I am wondering if
anyone has ever done anything like this before.
ARS 6.03 patch 16
WIN2003
SQL2K
Thanks in advance for any suggestions.
Regards,
Roger A. Nall
Manager, OSSNMS Remedy
T-Mobile, USA
Desk: 813-348-2556
Cell: 973-652-6723
FAX: 813-348-2565
sf49fanv AIM IM
RogerNall Yahoo IM
DISCLAIMER Important! This message is intended
for the above named person(s) only and is
CONFIDENTIAL AND PROPRIETARY. If you are not the
intended recipient of this e-mail and have
received it in error, please immediately notify
the sender by return email and then delete it
from your mailbox. This message may be protected
by the attorney-client privilege and/or work
product doctrine. Accessing, copying,
disseminating or re-using any of the information
contained in this e-mail by anyone other than
the intended recipient is strictly prohibited.
Finally, you should check this email and any
attachments for the presence of viruses, as the
sender accepts no liability for any damage
caused by any virus transmitted by this email.
Thank you. __Platinum Sponsor: www.rmsportal.com
ARSlist: "Where the Answers Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
-------------------------------------------------------
Julie Rockwood
Los Alamos National Laboratory
IST-APPS3
(505) 667-9846
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"