Visit Our UNIX and Linux User Community


shell-script which extract data from log file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting shell-script which extract data from log file
# 1  
Old 06-25-2008
MySQL shell-script which extract data from log file

give me a shell-script which extract data from log file on a server by giving date and time as input (for both start time and end time) and it will give the logs generated during the given time as output.
# 2  
Old 06-25-2008
Does ur log file contain any entries of Date and Time when the messages were logged.
justsam
# 3  
Old 06-26-2008
yes the log file contains the date and time entry in it...in the formate 06/25/08:02:15:00
# 4  
Old 06-26-2008
Could you provide afew line to justsam ? I want to have that as well.
# 5  
Old 06-27-2008
Date %Used WAS Dir %Used Content Dir % Used Logs Dir AHR JAVA VSZ CBIT JAVA VSZ FWS JAVA VSZ IDW JAVA VSZ CORP1 JAVA VSZ CORP2 JAVA VSZ INST1 JAVA VSZ INST2 JAVA VSZ ET2 JAVA VSZ TOT AHR BI VSZ Num AHR BI AVG AHR BI VSZ TOT CBIT BI VSZ Num CBIT BI AVG CBIT BI VSZ TOT FWS BI VSZ Num FWS BI AVG FWS BI VSZ TOT IDW BI VSZ Num IDW BI AVG IDW BI VSZ TOT CORP1 BI VSZ Num CORP1 BI AVG CORP1 BI VSZ TOT CORP2 BI VSZ Num CORP2 BI AVG CORP2 BI VSZ TOT INST1 BI VSZ Num INST1 BI AVG INST1 BI VSZ TOT INST2 BI VSZ Num INST2 BI AVG INST2 BI VSZ TOT ET2 BI VSZ Num ET2 BI AVG ET2 BI VSZ USED SWAP SPACE FI FO PI PO ENTITLED CPU % USED
06/25/08:00:45:00 72% 81% 15% 1585860 429604 596524 332576 409316 1208380 499724 288556 1 288556 355136 1 355136 255400 1 255400 427376 2 213688 303560 1 303560 0 0 293032 1 293032 769272 2 384636 294600 1 294600 53% 470 0 0 0 21.9
06/25/08:00:46:00 72% 81% 15% 1585860 429604 596524 332576 409316 1208380 499724 288556 1 288556 355136 1 355136 255400 1 255400 427376 2 213688 303560 1 303560 0 0 293032 1 293032 769272 2 384636 294600 1 294600 53% 164 0 0 0 26.1
06/25/08:00:47:01 72% 81% 15% 1585860 429604 596524 332576 409316 1208380 499724 288556 1 288556 355136 1 355136 255400 1 255400 427376 2 213688 303560 1 303560 0 0 293032 1 293032 769272 2 384636 294600 1 294600 53% 696 0 0 0 18.7
06/25/08:00:48:00 72% 81% 15% 1585860 429604 596524 332576 409316 1208380 499724 288556 1 288556 355136 1 355136 255400 1 255400 427376 2 213688 303560 1 303560 0 0 293032 1 293032 769272 2 384636 294600 1 294600 53% 919 5 0 0 14.7

this what our log looks like in the log file.....

Previous Thread | Next Thread
Test Your Knowledge in Computers #95
Difficulty: Easy
SMH is an Internet expression that stands for 'shake my head' or 'shaking my head'.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shell script to extract data in a file

I have this 5GB file, and i want to extract from the file particulars pattern. this is my script: // count=`grep -wc "MSISDN" file_name` k=1 >OUTPUT >OUTPUT_Final while do cat file_name | awk -F":" -v var="$k" '$1=="MSISDN" {m++}m==var{print; exit}' >> OUTPUT cat file_name |awk -F":"... (33 Replies)
Discussion started by: gillesi
33 Replies

2. Shell Programming and Scripting

Shell script to extract data from csv file

Hi everyone, I have a csv file which has data with different heading and column names as below. Static Data Ingested ,,,,,,,,,,,,Known Explained Rejections Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Discussion started by: Vivekit82
14 Replies

3. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values. Name, Address,... (7 Replies)
Discussion started by: Vivekit82
7 Replies

4. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file based on certain conditions

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Discussion started by: Vivekit82
1 Replies

5. Shell Programming and Scripting

regular expression with shell script to extract data out of a text file

hi i am trying to extract some specific data out of a text file using regular expressions with shell script that is using a multiline grep .. and the tool i am using is pcregrep so that i can get compatibility with perl's regular expressions for a sample data like this, i am trying to grab... (6 Replies)
Discussion started by: vemkiran
6 Replies

6. Shell Programming and Scripting

need a shell script to extract data from a log file.

If I have a log like : Mon Jul 19 05:07:34 2010; TCP; eth3; 52 bytes; from abc to def Mon Jul 19 05:07:35 2010; UDP; eth3; 46 bytes; from aaa to bbb Mon Jul 19 05:07:35 2010; TCP; eth3; 52 bytes; from def to ghi I will need an output like this : Time abc to def... (1 Reply)
Discussion started by: hitha87
1 Replies

7. Shell Programming and Scripting

Need shell script to extract data from oracle database

shell script (4 Replies)
Discussion started by: frns5
4 Replies

8. Shell Programming and Scripting

Help with shell script to extract data from XML file

Hello Scripting Gurus, I need help with extracting data from the XML file using shell script. The data is in a large XML and I need to extract the id values of all completedworkflows. Here is a sample of it. Input and output data is also in the attached text files. <wfregistry>... (5 Replies)
Discussion started by: yajaykumar
5 Replies

9. Shell Programming and Scripting

extract data from xml- shell script using awk

Hi, This is the xml file that i have. - <front-servlet platform="WAS4.0" request-retriever="SiteMinder-aware" configuration-rescan-interval="60000"> <concurrency-throttle maximum-concurrency="50" redirect-page="/jsp/defaulterror.jsp" /> - <loggers> <instrumentation... (5 Replies)
Discussion started by: nishana
5 Replies

10. Shell Programming and Scripting

How to extract data using UNIX shell script?

Hello All, I am starting with UNIX. Any help is highly appreciated. How to extract data using UNIX shell script? And how do you export data using UNIX shell scripts into Microsoft Excel format? Thank you. (3 Replies)
Discussion started by: desiondarun
3 Replies

Featured Tech Videos