Scott, I built a daily report for change management. Here's what it took:
- Create a staging form with a table, a large text field and some temp fields - table uses an external qualification that is set when the escalation fires (in my case date = ...) - created filters to extract data from the table and concatenate in a single field - created filter guide to loop the table - created filter to perform a notify action once the table loop was complete Since you want to run the report by manager you might want two tables. One for managers that would loop and set the external qualification of the second table...you'd then want to notify after each line of table one and set fields to null before you jump to the next record...etc. Hope that helps...let me know if you want more detail. -Eli -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SCOTT PHILBEN Sent: Wednesday, February 25, 2009 9:35 AM To: arslist@ARSLIST.ORG Subject: Creating and Emailing a Multi-Record Report ARS - 7.1 patch 006 ITSM 7.0.3 I have an escalation that runs in the morning to notify Incident Assignees that their tickets have not been modified in the last 7 days if the Modified Date is older than 7 days and the Status < Resolved. This works fine. A separate email gets sent to each assignee for each ticket. Now the bosses want to be notified as well. What is the best way to create and send a compilation report of all the users to one person. I have looked at making templates or pushing data to the email messages form but all of the examples (4-24 on page 100) seem to show how to send out a single record email. Will the Qualification field in the Variable Replacement tab accept a qualification that returns more than one record? I assume at that point I need to feed it into a Content template. Will the template have a problem? Of course, with the email gateway down at the moment I am having a hard time testing this. But if anyone knows it works and can let me know, I won't be wasting my time when email comes back up. Thanks. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
