UNIX for Dummies Questions & Answers

I have big log file, which contains the netstat output from my application server to a particular DB server. I aim is to plot a daily graph for this. Please find the sample log file below.

[2009-02-25:12:27:00] @ [783] - ...........................................................
[2009-02-25:12:27:00] @ [783] - Total number of connection to the DB is 5
[2009-02-25:12:27:00] @ [783] - ...........................................................
[2009-02-25:12:27:00] @ [783] - Netstat output For DB

tcp 0 0 783:57934 315-VIP.ipc.us.ae:5150 ESTABLISHED
tcp 0 0 783:57901 315-VIP.ipc.us.ae:5150 ESTABLISHED
tcp 0 0 783:58243 315-VIP.ipc.us.ae:5150 ESTABLISHED
tcp 0 0 783:57574 315-VIP.ipc.us.ae:5150 ESTABLISHED
tcp 0 0 783:57572 315-VIP.ipc.us.ae:5150 ESTABLISHED

[2009-02-25:12:28:00] @ [783] - ...........................................................
[2009-02-25:12:28:00] @ [783] - Total number of connection to the DB is 5
[2009-02-25:12:28:00] @ [783] - ...........................................................
[2009-02-25:12:28:00] @ [783] - Netstat output For DB

tcp 0 0 783:57934 315-VIP.ipc.us.ae:5150 ESTABLISHED
tcp 0 268 783:57901 315-VIP.ipc.us.ae:5150 ESTABLISHED
tcp 0 0 783:58243 315-VIP.ipc.us.ae:5150 ESTABLISHED
tcp 0 0 783:57574 315-VIP.ipc.us.ae:5150 ESTABLISHED
tcp 0 0 783:57572 315-VIP.ipc.us.ae:5150 ESTABLISHED

from which i need to extract like the below
12:27:00 5
12:28:00 5

This is the time and total number of connection to the DB.

For this i have write a one line script like this

awk '/Total/' smp.log | awk 'BEGIN{FS="["} {print $2, $3}' | awk 'BEGIN{FS="]"} {print $1, $3}' | awk 'BEGIN{FS=":"} {print $2":"$3":"$4}' | awk '{print $1, $12}'

I think i am using too much awk command for this.. It would be great if some one tune my logic.

Thanks,
Senthilkumar

Code:

nawk -F'[- :]|[[]|[]]' '/Total number/ {print $5 ":" $6 ":" $7, $NF}' smp.log

A big thanks to vgersh99,
Is it possible to explain me what it means.. for the
[- :]|[[]|[]]
meaning of the command..?

How ever awk works fine for me and not the nawk.

thanks
Senthil.

We're supplying ALL needed FSs (FieldSeparators) - '|' is logical 'or':

Code:

[- :]|[[]|[]]