Ray and Carey, We handle this kind of request with a form in Remedy that includes the information that we want reported. Then, every morning around 2am an escalation fires that collects the data SUBMITS a new record to that form. Finally, a filter action on submissions to that form sends the formatted results of the data collection to the appropriate addresses. The side benefit is that we've got a daily log of the reported data that we can then run reports against if we need to! :)
Gp George Payne Assistant Director, User Services Information Technology Services University of Texas at Austin 512.232.7513 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, May 25, 2007 6:46 AM To: arslist@ARSLIST.ORG Subject: Re: Doc on reporting Ray, At this time there is no "easy" way to schedule a report. You can do it. But you have to go a bit outside of the standard ARS to do it. ( I am not sure if the OOB applications offer any more advanced options in this area.) The basic idea of how it can be done.... You could use an Escalation (or any other time based triggering tool, like Cron, Scheduled Tasks, etc..) to run the command line tool "runmacro". ( You should find this program in the <ARS server install>/bin/runmacro directory.) This program will let you run a Remedy Macro from the command line and produce a local file on the file system. However it will not send it out in email. For that task you can either write a command line program to email the file directly, or you can build other workflow in ARS that will check the time stamp on the file and if it is "new enough" then pull the file into ARS (assuming the file is small enough for that to work) and send email from there. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 5/25/07, Ray M <[EMAIL PROTECTED]> wrote: > ** > Hi: is there a documentation on reporting? I want to schedule report > creation of all open tickets with their corresponding worklogs and forward > them to an email address. > > Thanks > > Ray ________________________________________________________________________ _______ 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"