Sugan, If you are on MS-SQL, I think it would be possible to schedule a job to SELECT the rows you want to WHERE Status = Resolved to a CSV file. I know its possible to do it via the SQL GUI, but I'm not quite sure how you would redirect the results to be a comma separated output from the SQL command line while defining an SQL job.. worth mucking around to find out though..
If you are on Oracle or any other database there must be an equivalent way of achieving the same. Cheers Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mayfield, Andy L. Sent: Wednesday, October 10, 2007 5:12 PM To: [email protected] Subject: Re: Report Genaration ** I am not sure if this is the best way, but I think you could record a MACRO that runs the report you want and have an Escalation run the MACRO every 60 minutes. Someone of the more experienced guys here on the list may have a cleaner solution though. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sugavanam K K Sent: Tuesday, October 09, 2007 3:48 PM To: [email protected] Subject: Report Genaration HI All, I need some help from you all. Following is my requirement, I need to generate a report in CSV format every 60 minutes form Help Desk form based on the status = Resolved. Inputs appreciated. Thanks in advance. Regards, Sugan No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.8/1064 - Release Date: 10/11/2007 3:09 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
