|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Need Help on query
Post 302276867 by snipfer on Wednesday 14th of January 2009 10:26:16 PM
01-14-2009
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 -
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]
}
} '
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 -
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..
|
|
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
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
7. Shell Programming and Scripting
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
8. UNIX for Dummies Questions & Answers
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
9. Shell Programming and Scripting
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
LEARN ABOUT LINUX
grub-setup
GRUB-SETUP(8) System Administration Utilities GRUB-SETUP(8) NAME
grub-setup - set up a device to boot using GRUB SYNOPSIS
grub-setup [OPTION...] DEVICE DESCRIPTION
Set up images to boot from DEVICE. You should not normally run this program directly. Use grub-install instead. -a, --allow-floppy Make the drive also bootable as floppy (default for fdX devices). May break on some BIOSes. -b, --boot-image=FILE Use FILE as the boot image [default=boot.img] -c, --core-image=FILE Use FILE as the core image [default=core.img] -d, --directory=DIR Use GRUB files in the directory DIR [default=/boot/grub] -f, --force Install even if problems are detected -m, --device-map=FILE Use FILE as the device map [default=/boot/grub/device.map] -r, --root-device=DEV Use DEV as the root device [default=guessed] -s, --skip-fs-probe Do not probe for filesystems in DEVICE -v, --verbose Print verbose messages. -?, --help give this help list --usage give a short usage message -V, --version print program version Mandatory or optional arguments to long options are also mandatory or optional for any corresponding short options. DEVICE must be an OS device (e.g. /dev/sda). REPORTING BUGS
Report bugs to <bug-grub@gnu.org>. SEE ALSO
grub-install(8), grub-mkimage(1), grub-mkrescue(1) The full documentation for grub-setup is maintained as a Texinfo manual. If the info and grub-setup programs are properly installed at your site, the command info grub-setup should give you access to the complete manual. grub-setup (GRUB) 1.99-12ubuntu5 October 2011 GRUB-SETUP(8)