Create a regular form with the following characteristics: - a 0 length character field, to hold the contents of the email - a table field that points to the ticket data - a filter loop that walks the table and writes the contents to the char field using the table field - a filter that sends a notification on modify - 1 record for each report you want to email out - an escalation that kicks the table walk/report generation
You will have to fill in the blanks, like reading the data from the ticket form using a set fields, how to trigger the filter to do the table walk Axton Grams On 12/12/06, Kohli, Himanshu <[EMAIL PROTECTED]> wrote:
Hello All Please share any design that you can think off or may have developed to meet a similar requirement ( reporting through notification ) of mine Requirement Specs : To generate a list of all cases which are in Status "Pending" for more than 4 days and send the same in an email notification as text details or HTML template or as an attachment (i.e. rpt or csv file ). Remedy Environment Details : AIX,ARS 6.3,ITSM 6.0,CMDB1.1,Mid-Tier 6.3,Oracle 9i Design A: Wrote a shell script to pull respective data from database, than used unix mail server to send an email with the list of respective cases and scheduled the same using Unix scheduler. Note : This design I have build but want to now develop the same using Remedy Server objects and do better alignment and presentation of my Report. Design B: This has to be Using REMEDY workflow so please advise.......... Thanks for your valuable suggestions and design concepts I will take them as my Christmas Present :) With Warm Regards Himanshu Kohli Remedy Consultant, Inetnation Monetary Fund, Washington DC www.imf.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
