Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Counting specific words from the log

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Counting specific words from the log
# 1  
Old 08-24-2011
Counting specific words from the log
Hi,

I need a shell script which can provide details from error logs like this

Code:
Aug 23 21:19:41 red mountd[5323]: authenticated mount request from bl0110.bang.m
pc.local:651 for /disk1/jobs (/disk1)
Aug 23 08:49:52 red dhcpd: DHCPDISCOVER from 00:25:90:2b:cd:7c via eth0: unknown client
Aug 24 15:49:52 red mountd[5323]: authenticated unmount request from bk0006.bang.mpc.local:726 for /disk1/jobs (/disk1)
Aug 24 15:49:52 red mountd[5323]: authenticated mount request from bk0006.bang.mpc.local:731 for /disk1/jobs (/disk1)
Aug 24 15:49:55 red dhcpd: DHCPDISCOVER from 00:25:90:2b:cd:7c via eth0: unknown client
Aug 24 15:49:55 red mountd[5323]: authenticated unmount request from pinapple.bang.mpc.local:958 for /disk1/jobs (/disk1)
Aug 24 15:49:58 red dhcpd: DHCPDISCOVER from 00:25:90:2b:cd:7c via eth0: unknown client
Aug 24 15:50:01 red mountd[5323]: authenticated mount request from cochin.bang.mpc.local:804 for /disk1/jobs (/disk1)

needs to get output like this

it should give the count of 'unknown client' error happend on
every day with date
Code:
Date            no. errors    
Aug 24        3
Aug 23        2



Arthur
Moderator's Comments:
Mod Comment Please use CODE tags (as required by forum rules) when displaying sample input, sample output, and code segments.
Last edited by Don Cragun; 09-23-2018 at 03:33 AM.. Reason: Add CODE tags again.
# 2  
Old 08-24-2011
Code:
#!/bin/bash
grep "unknown client" inputfile | awk ' { print $1,$2 } ' | uniq > tempfile1
grep "unknown client" inputfile > tempfile2
while read i
do
        echo "$i : `grep "$i" tempfile2 |  wc -l`"
done<tempfile1
rm tempfile1 tempfile2

# 3  
Old 08-24-2011
Through awk
Code:
$># Below output is from the given sample input file
$>awk '/unknown client/{++a[$1FS$2]}END{for(i in a) print i,a[i]}' inputfile
Aug 23 1 
Aug 24 2

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Counting occurrences of all words in multiple files

Hey Unix gurus, I would like to count the number occurrences of all the words (regardless of case) across multiple files, preferably outputting them in descending order of occurrence. This is well beyond my paltry shell scripting ability. Researching, I can find many scripts/commands that... (4 Replies)
Discussion started by: twjolson
4 Replies

2. Shell Programming and Scripting

Counting occurrence of all words in a file

Hi, Given below is the input file: http://i53.tinypic.com/2vmvzb8.png Given below is what the output file should look like: http://i53.tinypic.com/1e6lfq.png I know how to count the occurrence of 1 word from a file, but not all of them. Can someone help please? An explanation on the... (1 Reply)
Discussion started by: r4v3n
1 Replies

3. Shell Programming and Scripting

counting words with perl?

how to use perl to count number of lines, words characters in a file. (3 Replies)
Discussion started by: winter9
3 Replies

4. Shell Programming and Scripting

Help in counting the no of repeated words with count in a file

Hi Pls help in solving my doubt.Iam having file like below file1.txt priya jenny jenny priya raj radhika priya bharti bharti Output required: I need a output like count of repeated words with name for ex: priya 3 jenny 2 (4 Replies)
Discussion started by: bha148
4 Replies

5. Programming

Counting the words in a file

Please find the below program. It contains the purpose of the program itself. /* Program : Write a program to count the number of words in a given text file */ /* Date : 12-June-2010 */ # include <stdio.h> # include <stdlib.h> # include <string.h> int main( int argc, char *argv ) {... (6 Replies)
Discussion started by: ramkrix
6 Replies

6. Shell Programming and Scripting

Counting words

Hi Is there a way to count the no. of words in all files in directory. All are text files.I use wc -w but somehow i am not getting the rite answer. Is there an alternative. Thanks in advance (9 Replies)
Discussion started by: kinny
9 Replies

7. UNIX for Dummies Questions & Answers

counting words

if i have a long list of data, with every line beginning with an ip-address, like this: 62.165.8.187 - - "GET /bestandnaam.html HTTP/1.1" 200 5848 "http://www.domeinnaam.nl/bestandnaam.html" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)" how do i count which ip-adresses are mentioned... (3 Replies)
Discussion started by: FOBoy
3 Replies

8. Programming

Counting characters, words, spaces, punctuations, etc.

I am very new to C programming. How could I write a C program that could count the characters, words, spaces, and punctuations in a text file? Any help will be really appreciated. I am doing this as part of my C learning exercise. Thanks, Ajay (4 Replies)
Discussion started by: ajay41aj
4 Replies

9. UNIX for Dummies Questions & Answers

counting words then amending to a file

i want to count the number of words in a file and then redirect this to a file echo 'total number of words=' wc -users>file THis isnt working, anyone any ideas. (1 Reply)
Discussion started by: iago
1 Replies

10. Shell Programming and Scripting

Counting words in a file

I'm trying to figure out a way to count the number of words in the follwing file: cal 2002 > file1 Is there anyway to do this without using wc but instead using the cut command? (1 Reply)
Discussion started by: r0mulus
1 Replies
Login or Register to Ask a Question