Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Generating formatted reports from log files
Top Forums Shell Programming and Scripting Generating formatted reports from log files Post 302338408 by summer_cherry on Monday 27th of July 2009 11:19:46 PM
Old 07-28-2009
perl:


Code:
while(<DATA>){
	chomp;
	next if $. == 1;
  my @tmp=split("[ |]",$_);
  push @{$hash{$tmp[1]}}, $tmp[0]." ".$tmp[5];
}
foreach my $key(keys %hash){
	print "ID = $key\n";
	print join "\n", @{$hash{$key}};
	print "\n";
}
__DATA__
DATE ID LOG_LEVEL | EVENT
2009-07-23T14:05:11Z T-4030097550 D | MessX
2009-07-23T14:10:44Z T-4030097550 D | MessY
2009-07-23T14:34:08Z T-7298651656 D | MessX
2009-07-23T14:41:00Z T-7298651656 D | MessY
2009-07-23T15:05:10Z T-4030097550 D | MessZ

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Generating a report -Formatted printing -Urgent

Hi, My aim is to generate a report using shell script. There are various formats fields coloumns etc. I want to print in a single line (row) but in different coloumn as given below: field1 field2 field3 field4 ....... ....... ...... ....... The spacing... (1 Reply)
Discussion started by: jisha
1 Replies

2. Shell Programming and Scripting

generating reports based on time field of network data

hi i have data extracted in the following format ranging around 300000 to 800000 records in a text file , the format is of network data . No. Time Source Destination Protocol 1 1998-06-05 17:20:23.569905 HP_61:aa:c9 HP_61:aa:c9 ... (1 Reply)
Discussion started by: renukaprasadb
1 Replies

3. Shell Programming and Scripting

Generating files.

I/P file name:- 20092008.txt Check number of entries in i/p file by following command ChkEnt -infl 20092008.txt -opfl 20092008_test.txt >count.txt Dear Friends, Please help me in automating following thing. If output generated (count.txt) is having value more than 1000 i.e.... (8 Replies)
Discussion started by: anushree.a
8 Replies

4. Shell Programming and Scripting

how to search reports with specified keyword in log

Hi, I have a question with sed/awk. When I handle some log files I want to search all reports with specified keyword. For example, in the log below. abcd efg ===start abc e ===end xyz ===start af f ===end nf ga ===start ab ===end (4 Replies)
Discussion started by: danielnpu
4 Replies

5. Red Hat

sarg issue while generating reports for squid

I installed sarg from sarg rpm and i am facing issue while generating sarg reports and getting this time different error below sarg -l /var/log/squid/access.log SARG: Records in file: 242332, reading: 0.00% SARG: Records in file: 242332, reading: 2.06% SARG: Records in file: 242332, reading:... (0 Replies)
Discussion started by: mail4vij
0 Replies

6. Shell Programming and Scripting

Extract information from Log file formatted

Good evening! Trying to make a shell script to parse log file and show only required information. log file has 44 fields and alot of lines, each columns separated by ":". log file is like: first_1:3:4:5:6:1:3:4:5:something:notinterested second_2:3:4:3:4:2 first_1:3:4:6:6:7:8 I am interested... (3 Replies)
Discussion started by: dummie55
3 Replies

7. Linux

Generating apache log reports

Hello all, I'm trying to find some tool on generating reports based on apache access_log files (of Common format). I found some of them (awstats, lire/logreport, weblog expert, apache logs viewer, etc..) but they generate some global and general report about the log file. Also some perl... (0 Replies)
Discussion started by: enux
0 Replies

8. Shell Programming and Scripting

Generate a Execution time reports using log files.

Hi Experts, I am having a requirement, where i need to generate a report of the execution time of all the processes. All the processes generate the log files in a log directory and I can get the execution time from the log files. like below is the log file. /home/vikas/log >ls -l... (2 Replies)
Discussion started by: k_vikash
2 Replies

9. Shell Programming and Scripting

Split files with formatted numbers

How to split the file and have suffix with formatted numbers Tried the following code awk '{filename="split."int((NR-1)/2)".txt"; print >> filename}' split.txt Current Result Expected Result (21 Replies)
Discussion started by: bobbygsk
21 Replies

10. UNIX for Beginners Questions & Answers

Cron job scheduled is running once, but reports are generating twice

Team, Hope you all are doing fine I have one admin server which is being used dedicately to run cron jobs on hourly basis, fetching the details from Database which is in a different server.These cronjob are run on every hourly/5 minutes basis depending as per end user requirement.The script... (12 Replies)
Discussion started by: whizkidash
12 Replies

LEARN ABOUT SUSE

scanlogs

SCANLOGS(8)						    InterNetNews Documentation						       SCANLOGS(8)

NAME

       scanlogs - Summarize and rotate INN log files

SYNOPSIS

       scanlogs [norotate]

DESCRIPTION

       scanlogs summarizes the information recorded in the INN log files which reside in the pathlog directory set in inn.conf (see newslog(5) for
       further details about these log files).	It is normally invoked by the news.daily(8) script which performs daily server maintenance tasks.

       It invokes "ctlinnd flushlogs" to close the news and error log files, rename them to add ".old" to the file names and open fresh news and
       error logs; the active file is also flushed to disk, along with the history database.

       By default, scanlogs rotates and cleans out the logs.  It keeps up to logcycles old compressed log files in pathlog/OLD (the logcycles
       parameter can be set in inn.conf).   scanlogs also keeps archives of the active file in this directory.

       It invokes tally.control if newgroup.log or rmgroup.log exists in pathlog (see the control.log entry of newslog(5) for more information
       about that).

       scanlogs displays the contents of errlog and news.crit, if non-empty, and runs innreport to summarize the contents of news and news.notice,
       and to update the unwanted.log file amongst other things (see more information about that in innreport(8)).

OPTIONS

       Only one option is currently accepted:

       norotate
	   Using this option disables the rotating and cleaning aspect of the log processing:  the logs files are only scanned for information and
	   no contents are altered.  If scanlogs is invoked more than once a day, the norotate option should be used to prevent premature log
	   cleaning.

FILES

       See newslog(5) for the list of log files processed by scanlogs.

HISTORY

       Written by Landon Curt Noll <chongo@toad.com> and Rich $alz <rsalz@uunet.uu.net> for InterNetNews.  Converted to POD by Julien Elie.

       $Id: scanlogs.pod 8357 2009-02-27 17:56:00Z iulius $

SEE ALSO

       inn.conf(5), innreport(8), news.daily(8), newslog(5), shlock(1), tally.control(8).

INN 2.5.2							    2009-05-21							       SCANLOGS(8)
All times are GMT -4. The time now is 12:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy