Need Help on query


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Need Help on query
# 1  
Old 01-14-2009
Data Need Help on query

I just started to learn unix -

need help to write a script to query a logfile and produce the results that
contains a specific word "alarm" for a period from X day to Y day.

I really have no idea how to begin - Smilie

please help...

____________________________________________________

# Print out XXX statistics
# Usage

DIR=/xxx/log/
FILE=${DIR}test.log

[ $# = 1 ] && { FILE=$FILE.$1 ; }
#echo "LEGEND: DN-Down ; UP-Up ; DS-Disconnected ; AL-Alert ; FL-Failed\n"
#echo "Device ID DN | UP | DS | AL| FL| Device ID DN | UP | DS | AL| FL|"
#echo "===============|====|====|===|===| ===============|====|====|===|===|"

cat $FILE | awk '

/Alert/ {
spos = index($0,"[") + 1
epos = index($0,"]")
LEN = epos - spos
DEV = substr($0,spos,LEN)
dev[DEV]++
getline;
getline;
getline;

if ( index($0,"Low") ) {
devalert[DEV]++

}
}
END {
for (i in dev ) {
printf "%-10s %4s \n", i, devalert[i]
}
} '

Last edited by snipfer; 01-15-2009 at 12:21 AM..
# 2  
Old 01-15-2009
Hi snip,

You can start with this:

Code:
ls | while read $file_to_read
do
	grep -sin "alarm" $file_to_read
done

Just modify it a little. You can use a combination of find, ls, or grep and you'll finally get there Smilie
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

2. UNIX for Dummies Questions & Answers

Query

Hi, I have a script to remove null values from a file. Could any one explain how this is working? :confused: while read f do echo process $f gawk... (0 Replies)
Discussion started by: abhi_n123
0 Replies

3. Shell Programming and Scripting

want to query : YES or NO

hi i want to make script. where i want to query from the user yes or no exp: do you want to proceed : y for yes n for NO. how this is possible in unix (3 Replies)
Discussion started by: dodasajan
3 Replies

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

5. Shell Programming and Scripting

Query

hi i am producing txt outputs of archives created by our tsm software. problem is some of these files are too large to open in excel so i can despatch. here is a example of the output TAG_460 /prod_bak 7 FILE /ARCHIVE/Whistles- ... (4 Replies)
Discussion started by: treds
4 Replies

6. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1... (0 Replies)
Discussion started by: hazno
0 Replies

7. Shell Programming and Scripting

query.....

hi friends i want to know details of `exec` exact use of this command ..... actually i went through the man page but i didn`t get the satisfactory ...conclusion.... thaks in advance.... (1 Reply)
Discussion started by: newson
1 Replies

8. Shell Programming and Scripting

query

I have converted data written on excel sheet in unix through shell & perl prg now the problem is I want that if starting columns of the xls sheet is Blank than when data is converted into unix then it should appear with this '|' sign. but it appearing like this: hfgg|tytt| but I want like... (2 Replies)
Discussion started by: akash
2 Replies

9. UNIX for Dummies Questions & Answers

query

hi, how can i do the following..... i have file containing followig a k 10000 b c 200000 d e 50 a j 40 how can i list all rows containg last value more than 1000? and how can i find number of blank rows in the file? THANKS! regards vivek (2 Replies)
Discussion started by: vivekshankar
2 Replies
Login or Register to Ask a Question