|
|
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 OSX
glgetqueryobject
GLGETQUERYOBJECT(3G) OpenGL 3.3 GLGETQUERYOBJECT(3G) NAME
glGetQueryObject - return parameters of a query object C SPECIFICATION
void glGetQueryObjectiv(GLuint id, GLenum pname, GLint * params); void glGetQueryObjectuiv(GLuint id, GLenum pname, GLuint * params); void glGetQueryObjecti64v(GLuint id, GLenum pname, GLint64 * params); void glGetQueryObjectui64v(GLuint id, GLenum pname, GLuint64 * params); PARAMETERS
id Specifies the name of a query object. pname Specifies the symbolic name of a query object parameter. Accepted values are GL_QUERY_RESULT or GL_QUERY_RESULT_AVAILABLE. params Returns the requested data. DESCRIPTION
glGetQueryObject returns in params a selected parameter of the query object specified by id. pname names a specific query object parameter. pname can be as follows: GL_QUERY_RESULT params returns the value of the query object's passed samples counter. The initial value is 0. GL_QUERY_RESULT_AVAILABLE params returns whether the passed samples counter is immediately available. If a delay would occur waiting for the query result, GL_FALSE is returned. Otherwise, GL_TRUE is returned, which also indicates that the results of all previous queries are available as well. NOTES
If an error is generated, no change is made to the contents of params. glGetQueryObject implicitly flushes the GL pipeline so that any incomplete rendering delimited by the occlusion query completes in finite time. If multiple queries are issued using the same query object id before calling glGetQueryObject, the results of the most recent query will be returned. In this case, when issuing a new query, the results of the previous query are discarded. glGetQueryObjecti64v and glGetQueryObjectui64v are available only if the GL version is 3.3 or greater. ERRORS
GL_INVALID_ENUM is generated if pname is not an accepted value. GL_INVALID_OPERATION is generated if id is not the name of a query object. GL_INVALID_OPERATION is generated if id is the name of a currently active query object. SEE ALSO
glBeginQuery(), glEndQuery(), glGetQueryiv(), glIsQuery(), glQueryCounter() COPYRIGHT
Copyright (C) 2005 Addison-Wesley. This material may be distributed subject to the terms and conditions set forth in the Open Publication License, v 1.0, 8 June 1999. http://opencontent.org/openpub/. OpenGL 3.3 03/08/2011 GLGETQUERYOBJECT(3G)