Shell Programming and Scripting

when i run a command the output is something like this:

#3136 0.872914 01/17/08 22:06:36
#24817 1.231532 01/18/08 05:00:44
#15371 1.291679 01/18/08 03:00:08
#21279 2.130480 01/18/08 04:03:16
#7835 27.892056 01/18/08 00:01:32

i need to check if any one of the second column is greater than 5,if it greater than 5 then take the process id of that row(column1)
and i have to give this command: less <logfile> <processid>.

when i do this i get a screen filled with @.
then i again search for <processid> and i copy the text to word document

1)is there any command which gives the text of logfile directly instead of @ in the first go itself.
2)and do we have any command which copies the content returned by previous command in to a word document.


Thanks & Regards,
Cybersandex.

Code:

> cat file1
#3136 0.872914 01/17/08 22:06:36
#24817 1.231532 01/18/08 05:00:44
#15371 1.291679 01/18/08 03:00:08 
#21279 2.130480 01/18/08 04:03:16
#7835 27.892056 01/18/08 00:01:32

> echo "hello `awk '$2>5 {print $1}' file1 | tr -d "#"`"
hello 7835

Instead of doing an echo to say hello, other commands could be done. While you mention logfile, I could not understand what you meant or what this referred to.

after i run this command:
cat sqllog_clrdg5q1 | grep SQL_ROUNDTRIP_TIME | cut -d' ' -f4,4,3,3,7,7,8,8 | sort -k 2,2n | tail -5

i get output like:
#3136 0.872914 01/17/08 22:06:36
#24817 1.231532 01/18/08 05:00:44
#15371 1.291679 01/18/08 03:00:08
#21279 2.130480 01/18/08 04:03:16
#7835 27.892056 01/18/08 00:01:32

now i have to copy the sqlquery which has run for more than 5 secs in to a word document
can we automate this whole process?

I can get to the 7835, but how do I know the sqlquery that you want to copy?

By the way, you might be able to streamline your original command.
original

Code:

>cat sqllog_clrdg5q1 | grep SQL_ROUNDTRIP_TIME | cut -d' ' -f4,4,3,3,7,7,8,8 | sort -k 2,2n | tail -5

proposed

Code:

>grep SQL_ROUNDTRIP_TIME sqllog_clrdg5q1 | cut -d' ' -f3,4,7,8 | sort -k 2,2n | tail -5

we give: less sqllog_clrdg5q1 7835 and i get a screen wid @(astricks)
then i search wid 7835 like /#7835 and then i get output on the screen with the sql query.I copy this to a word document

Start by extracting a simplified log file of key data:

Code:

>grep SQL_ROUNDTRIP_TIME sqllog_clrdg5q1 | cut -d' ' -f3,4,7,8 | sort -k 2,2n | tail -5 > temp_sql

Then, to make your next step:

Code:

> echo `awk '$2>5 {print $1}' temp_sql | tr -d "#"`" > temp_sql2

So the file temp_sql2 will hold a listing of all the id #'s with more than 5 seconds.