Login or Register to Ask a Question and Join Our Community


Web Development

Automation Script to generate SLA report as PPT

Login to Discuss or Reply to this Discussion in Our Community

 
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

LEARN ABOUT DEBIAN

sarg-reports

SARG-REPORTS(1) 					      General Commands Manual						   SARG-REPORTS(1)

NAME

       sarg-reports - Daily/Weekly/Monthly squid usage reports creation tool

SYNOPSIS

       sarg-reports [OPTIONS]

DESCRIPTION

       This manual page documents briefly the sarg-reports command.

       sarg-reports is a script written to automate the SARG (a powerful squid log analyzer) reports and log management.  Sarg it self, provide to
       end user a generic interface to create reports based on squid access log (begin of log to current date).  sarg-reports is useful because it
       allow you to easly create and manage Daily, Weekly and Monthly reports.

OPTIONS

       A summary of options is included below.

       manual
	      Create Manual report

       today  Create Today report

       daily  Create Daily report

       weekly Create Weely report

       monthly
	      Create Monthly report

CRONTAB

       If  you	want  the  reports can be generated automatically insert the following lines (the today report creation time depend mostly of your
       sarg server load average, tune it):

       PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
       00 08-18/1 * * * sarg-reports today
       00 00	  * * * sarg-reports daily
       00 01	  * * 1 sarg-reports weekly
       30 02	  1 * * sarg-reports monthly

       REMEMBER: if you use logrotate, configure it to rotate the logs within MONTHLY basis, AFTER sarg-reports created the monthly html report.

VARIABLES

       Check before using the sarg-reports that the following variables are set to file /etc/sarg/sarg.conf

       SARG
	      The sarg executable location

       CONFIG
	      The sarg main configuration file location

       HTMLOUT
	      Location where will be saved the reports

       PAGETITLE
	      The title of main index page

       LOGOIMG
	      Image logo to view in main index page

       LOGOLINK
	      HTTP web page link of logo

       DAILY
	      Word 'daily' translation, translate it to your language

       WEEKLY
	      Word 'weekly' translation, translate it to your language

       MONTHLY
	      Word 'monthly' translation, translate it to your language

       EXCLUDELOG1
	      Exclude text from cron emails (normally, sarg, during cron activity, if it don't find any valid records,

       EXCLUDELOG2
	      It will output an error message (usually on 'today' reports). I don't want to be warned by email about this, so, i wrote the  'text'
	      that will be never logged. This is useful to receive email of real problems only.

AUTHOR

       sarg-reports was written by Ugo Viti <ugo.viti@initzero.it>

       This manual page was written by Juan Angulo Moreno <juan@apuntale.com>, for the Debian project (but may be used by others).

								   may 17, 2008 						   SARG-REPORTS(1)