UNIX for Dummies Questions & Answers

I have big large snapshot file which contains every process start time and end time. One server snapshot contains many Application handle. My task is to identify the process id for which the end time is not there or empty also if the completion time is not on the same date then I need to kill.

The process is noted in the log file like “Application handle = 189” and the 14th and 15th line contains the time stamp like

Connection request start timestamp = 06/11/2008 02:56:45.952566
Connect request completion timestamp = 06/11/2008 02:56:45.954183

Please suggest some logic for this.

I think I need to separate the file in pieces by the searching the string Application handle, then using awk take the start time and compared to end time.

Thanks,
Senthilkumar

Please post the log for a couple of "Application handle" worth of lines.

I have attached the complete file.

jim,

do you need any more information..?

Try this:

Code:

awk '{
if ($0 ~/^Connection request start/) st=$(NF -1);
if ($0 ~ /^Connect request completion /) et=$(NF -1);
if ($0 ~ /^Process ID of client /) {
 if (st != et)print st" "et " PID="$NF;
}  }'  snapshot_file

There might be several ways of doing this, probably by simply counting lines and predicting where the "Connection request*" and "Process ID*" lines are.

My logic for this solution is storing every line into an $app var and when I find /Application Snapshot/ and I'm not on the first line or it's the EOF (END {}), I process $app which contains all the lines referring to the "last" application entry. So after processing I could choose to print $app or not ...

Code:

perl -ne 'BEGIN { sub analyze { $app =~ /Connection request.*?=\s(.*?)\n.*?Process ID.*?=(.*?)\n/sg;  print "$1 $2\n"; $app = "";  } } if (/Application Snapshot/ and $app !~ /^$/) { analyze(); } else { $app .= $_; } END { analyze(); }' samplesnapshot.txt

In print "$1 $2\n"; $app = ""; It could have something like if ($1 something and $2 something) { print $app; } $app = "";
Thus only printing $app if the requirement fits the need.

dennis, this give me the Process ID but i want the first line Application Handle