Thanks Peter and others, I tried modifying the macro with $TIMESTAMP$, but when the report was produced it had report$TIMESTAMP$ as the name.
I will try the other suggestion. Again, thanks to all. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of P Romain ARSlist Sent: Tuesday, September 02, 2008 4:29 PM To: arslist@ARSLIST.ORG Subject: Re: Automated Reports If you can alter the macros then try adding the timestamp to the 'to-file' parameter, eg to-file: x:\remedy\filename$TIMESTAMP$.csv If you don't like the timestamp format you could build the path and filename in a separate field and pass it to the macro as a parameter. Then the to-file parameter would be, eg to-file: $Filename$ where the Filename variable is set to, for example, x:\remedy\filename 20080902.csv Cheers Peter ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: 02 September 2008 20:29 To: arslist@ARSLIST.ORG Subject: Re: Automated Reports Another way would be to rename the file after generating. This way you would not have to change any of your macros. You can generate date info using Set Fields and the MONTH, DAY, and YEAR functions and pass them into a routine that renames the output file. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Tuesday, September 02, 2008 2:21 PM To: arslist@ARSLIST.ORG Subject: Re: Automated Reports I have done this type of thing via perl scripting...create your 'template' macro and have it contain a unique value for the report name...then have perl generate the timestamp that you are looking for...make a copy of the template macro, edit the copy to have a different report name, then execute runmacro with the new macro instead of the template...then you can delete today's macro file. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Randy Simon Sent: Tuesday, September 02, 2008 1:11 PM To: arslist@ARSLIST.ORG Subject: Automated Reports I run a report each day via macros and escalations. The report has a name and it overwrites the previous report every day. Is there a way to have the name of the report end in something like TIMESTAMP so it does not overwrite the older report? CSS 5.0 ARS 6.0 SQL 2005 Randy Simon Remedy Admin Online Resources Corporation ________________________________________________________________________ STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________________________________________________ STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
