Automation Script to generate SLA report as PPT

[vasuv]

Hi All,

We have one client.for this client some jobs got scheduled. Those jobs will run daily/weekly/Monthly. But once it runs it will generate some log files with date and Timestamp. In log folder it contains the complete logs of that particular job.
By end of every month we are going to take the log files and deleting the timestamo.log and keeing those logfilenames in Excel sheet with the following details.

we are generating this report after completion of very month.

Date Job_name Start_time end_time

every month we are retrieving the data manually then we are exporting the final data to PPT. can you please let us know is there any way to retrieve the data Automatically and it should remove the timestamp.log and it should save the data in Excel first then exporting the data into PPT.

if Automation is possible please let us know the code in any language and please let me know if you required any other information.

Thanks in advance.

[tomholden]

Re: Automation Script to generate SLA report as PPT

as far as outputting the data to Excel format there are several open source/freeware tools available (google Scott Klement POI HSSF for one, easy400.net has one based on CGIDEV2, etc.) as far as converting it to powerpoint i don't know of any (doesn't mean it doesn't exist but my fingers refuse to type Google searches today).