Hi All,

I have an Output from a log file which is something like as follows..

***** CDR and SDR Statistics****
Wed Feb 25 00:05:00 EST 2009
*********CDR and SDR QUEUE STATUS*****
Queue busy wait msgs
cdr 2 2 4
sdr 2 0 2
******CWAY CROSS STATISTICS***********
name state last op busy%
cdr.140 busy 0:05.11 68.3
cdr.141 busy 0:06.42 59.6
cdr.142 free 0:07.80 42.9
cdr.143 free 0:08.26 33.0
cdr.144 free 0:14.64 20.9
cdr.145 free 0:10.72 14.0
cdr.146 free 0:32.41 9.5
cdr.147 free 0:16.32 7.1
sdr.150 busy 0:06.31 69.8
sdr.151 free 0:02.74 59.3
sdr.152 busy 401.60 48.1
sdr.153 free 0:03.02 37.1
sdr.154 free 0:19.02 26.8
sdr.155 free 0:19.67 19.9
sdr.156 free 0:07.48 15.4
sdr.157 free 1108.35 13.0
sdr.158 free 0:17.44 9.8
sdr.159 free 0:13.70 8.3
sdr.160 free 0:20.50 7.1
sdr.161 free 0:14.14 6.1


This info is written to the log file every 5 minutes(same as the above one).

Requirement:

I need to get the count of the msgs for CDR and SDR Induvidually every hour in a sperate file .Is there an way to do this by some script.The name of the log file is mg_stat.log

Something like this?

awk '
$1=="cdr"{print $4}
$1=="sdr"{print $4}
' file

Hi Franklin,

Thanks a lot for your reply..

should this be in the same script which produces this log or a differnt one??

awk '
$1=="cdr"{print $4}
$1=="sdr"{print $4}
' output.txt

You can use a separate script or at the end of the same script.

Regards