Automation Script to generate SLA report as PPT


 
Thread Tools Search this Thread
Top Forums Web Development Automation Script to generate SLA report as PPT
# 1  
Old 04-02-2012
Automation Script to generate SLA report as PPT

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.

<code>
Date || Job_name || Start_time || end_time </code>

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.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk use to generate report

Hi , In a directory list of ddl files are stored in the given format above. Above is the sample ddl file. The ddl file name is same as that of table name ie email_notifications.ddl I want to generate below report using awk utility reading all the ddl files stored in /ddl path Desired output:... (1 Reply)
Discussion started by: vedanta
1 Replies

2. Shell Programming and Scripting

Shell script to generate report for each user ?

I have 3 user in my linux machine let's say a,b,c .By Using last command I am able to identify list of last logged in user and by w command who is logged in and what they are doing and by history command all command used by particular user all will be shown. Now I want to write shell script... (1 Reply)
Discussion started by: beingswarupmall
1 Replies

3. Shell Programming and Scripting

UNIX script generate report grouped on date

Dear Team, I am try n gerrating a report by writing a shell script, the content of the report should be aggrigated based on date value exist in the content of the file. initially the file is zip format My file content is in below format 031627787 034626800357002013050613310400000013500 CLT01... (1 Reply)
Discussion started by: balram0179
1 Replies

4. Shell Programming and Scripting

Generate a Summary report

Hi All, Script to meet my requirement might be simpler for UINIX experts.. :) I need to generate an summary report in .txt file using shell script I have Reject directory in Unix server which contains all reject files for three diff categories- Presentation, Chapter and Scene Following... (3 Replies)
Discussion started by: Sakthikalluri
3 Replies

5. Shell Programming and Scripting

Need a script that generate a report from a combined sudoers

Hello Gurus Is anyone aware of a script/utility that can be used to generate a report from a combined "sudoers" file for more than 100 servers in one go please? Basic query: Which particular user or an user group can execute root equivalent commands or has the ability for e.g. to do a... (1 Reply)
Discussion started by: kapil514
1 Replies

6. Shell Programming and Scripting

generate a report

I am trying to generate a report for a file called phone_book awk -f {phone_book} why does this not work? Nothing happens at all. (2 Replies)
Discussion started by: gustave
2 Replies

7. UNIX for Advanced & Expert Users

Unix- filters ppt

Hello.. i want a ppt on unix filters.. can anybody gv me d link 4 that?? (1 Reply)
Discussion started by: shweta_babbar
1 Replies

8. AIX

Re-Generate error report

Hi Is there a way to re-generate AIX error report after clearing it? I mean if I did errclear 0, Does the error log get erased? Is there a command that will get entries back in errpt? I hope that made sense. (5 Replies)
Discussion started by: Dardeer
5 Replies

9. Shell Programming and Scripting

generate a report

Hi Please help me to resolve the below query. My shell script has generated a file output.file like below ******************************** DROP TABLE GPS_CONTACT_DETAILS DB20000I The SQL command completed successfully. CREATE TABLE GPS_CONTACT_DETAILS ( CONTACT_ID ... (8 Replies)
Discussion started by: sailaja_80
8 Replies

10. Shell Programming and Scripting

Help generate report from log files

Hi Expert, I have some confusing to generate report from the log file as shown below: filename :test1.log start_time date end_time number code P 000029.621 20070823 000029 12134567890 111111111111 00 0 000 003... (4 Replies)
Discussion started by: bucci
4 Replies
Login or Register to Ask a Question
LIRE.IN(1)						  LogReport's Lire Documentation						LIRE.IN(1)

NAME
lire - Lire interface SYNOPSIS
lire DESCRIPTION
lire has two purposes: it configures Lire, and it enables automatic report generation. lire is a menu driven application. You should use the TAB key to navigate across the various interface elements. The arrow keys should be used to navigate menus. The main menubar can be accessed at all times using F10. The mouse might be available depending on your terminal and the implementation of the Curses::UI module of your system. configuring Lire The 'Preferences' menu item in the 'Lire' menu will give you access to all the Lire settings. The lire command edits or creates ~/.lire/config.xml. automatic report generation lire enables automatic report generation by creating and managing DLF stores. A DLF store is a log repository. In a DLF store, you can configure ImportJobs and ReportJobs that will be executed regularly. Store configuration is saved in store/config.xml. An ImportJob is a job that will import log data into the DLF store. This data will be used later to generate the reports. ReportJobs should be used to generate periodical reports. Reports are generated from the DLF streams available in your DLF store. The report can be generated for different schedules. Lire supports 5 different schedules: hourly, daily, weekly, monthly and yearly. You will need to select the report configuration file to use for each schedule. Defaults are located in <sysconfdir>/lire/, which you should use as templates that you need to customize according to your purpose. The reports can be generated either from the log data imported in the database or from previously generated daily reports. This is useful when you have lots of log data and you don't want to keep all the raw data available. The source is selected automatically based on data availability. You should note however that only 'daily' reports are considered as a data source for other reports (making that possible only with weekly or longer schedules). When executed, a ReportSchedule will only generate the report and save it in the DLF store. If you want to obtain a formatted copy of the report, you will need to configure one or more OutputJobs. Two types of OutputJob are supported: 1- The report can be sent by email to one or more address; 2- or it can saved in a file on the disk. A useful configuration is to generate HTML reports in a directory published on a web site. When using a "file" OutputJob you will probably want to use strftime(3) expansion so that the filename is different each time the report is generated. The most common expansions are: %Y - fou digits year (2000); %m - two-digits month number (01 for january); %V - ISO week number; %d - day of the month number; %H - hour of day (01-23). Also, contrary to the lr_log2report command, HTML reports are generated into a directory (not as a tar file). To run the scheduled jobs, you will need to setup cron jobs. Use lr_cron(1) to process the configured jobs in a store. SEE ALSO
lire(7), lr_cron(1), Lire User's Manual AUTHORS
Francis J. Lacoste <flacoste@logreport.org> Wolfgang Sourdeau <wolfgang@logreport.org> VERSION
$Id: lire.in,v 1.10 2006/07/23 13:16:32 vanbaal Exp $ COPYRIGHT
Copyright (C) 2004 Stichting LogReport Foundation, LogReport@LogReport.org This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with http://www.gnu.org/copyleft/gpl.html. Lire 2.1.1 2006-07-23 LIRE.IN(1)