Sponsored Content
Full Discussion: Need Help on query
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
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..
 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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

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

7. 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

8. 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

9. 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
GLBEGINCONDITIONALRE(3G)					    OpenGL 3.3						  GLBEGINCONDITIONALRE(3G)

NAME
glBeginConditionalRender - start conditional rendering C SPECIFICATION
void glBeginConditionalRender(GLuint id, GLenum mode); PARAMETERS
id Specifies the name of an occlusion query object whose results are used to determine if the rendering commands are discarded. mode Specifies how glBeginConditionalRender interprets the results of the occlusion query. C SPECIFICATION
void glEndConditionalRender(void); DESCRIPTION
Conditional rendering is started using glBeginConditionalRender and ended using glEndConditionalRender. During conditional rendering, all vertex array commands, as well as glClear() and glClearBuffer() have no effect if the (GL_SAMPLES_PASSED) result of the query object id is zero, or if the (GL_ANY_SAMPLES_PASSED) result is GL_FALSE. The results of commands setting the current vertex state, such as glVertexAttrib() are undefined. If the (GL_SAMPLES_PASSED) result is non-zero or if the (GL_ANY_SAMPLES_PASSED) result is GL_TRUE, such commands are not discarded. The id parameter to glBeginConditionalRender must be the name of a query object previously returned from a call to glGenQueries(). mode specifies how the results of the query object are to be interpreted. If mode is GL_QUERY_WAIT, the GL waits for the results of the query to be available and then uses the results to determine if subsequent rendering commands are discarded. If mode is GL_QUERY_NO_WAIT, the GL may choose to unconditionally execute the subsequent rendering commands without waiting for the query to complete. If mode is GL_QUERY_BY_REGION_WAIT, the GL will also wait for occlusion query results and discard rendering commands if the result of the occlusion query is zero. If the query result is non-zero, subsequent rendering commands are executed, but the GL may discard the results of the commands for any region of the framebuffer that did not contribute to the sample count in the specified occlusion query. Any such discarding is done in an implementation-dependent manner, but the rendering command results may not be discarded for any samples that contributed to the occlusion query sample count. If mode is GL_QUERY_BY_REGION_NO_WAIT, the GL operates as in GL_QUERY_BY_REGION_WAIT, but may choose to unconditionally execute the subsequent rendering commands without waiting for the query to complete. NOTES
glBeginConditionalRender and glEndConditionalRender are available only if the GL version is 3.0 or greater. The GL_ANY_SAMPLES_PASSED query result is available only if the GL version is 3.3 or greater. ERRORS
GL_INVALID_VALUE is generated if id is not the name of an existing query object. GL_INVALID_ENUM is generated if mode is not one of the accepted tokens. GL_INVALID_OPERATION is generated if glBeginConditionalRender is called while conditional rendering is active, or if glEndConditionalRender is called while conditional rendering is inactive. GL_INVALID_OPERATION is generated if id is the name of a query object with a target other than GL_SAMPLES_PASSED or GL_ANY_SAMPLES_PASSED. GL_INVALID_OPERATION is generated if id is the name of a query currently in progress. SEE ALSO
glGenQueries(), glDeleteQueries(), glBeginQuery() COPYRIGHT
Copyright (C) 2009 Khronos Group. 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 GLBEGINCONDITIONALRE(3G)
All times are GMT -4. The time now is 11:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy