awk and sum with original data

I am using the

cat /home/billing/1|awk '{ SUM += $8} END { print SUM }' >> /home/billing/test

I am getting the only total of the all i need to print with all details

Source File

All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 0134B TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 0134C TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A4 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A5 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A6 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A7 TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00215 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00216 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00217 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00218 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00219 RDF1+TDEV 151451

I need output has below

All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 0134B TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 0134C TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A4 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A5 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A6 TDEV 151451
All-dum-sg--Oc-14-2018 261 dummy server1_root_Silver  dummy 013A7 TDEV 151451
Total =908706

All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00215 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00216 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00217 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00218 RDF1+TDEV 151451
All-dum-sg--Oc-14-2018 640 dummy server2_d1_Silver  snapfound 00219 RDF1+TDEV 151451
Total=757255

what's the key for each group/block?

The key will be server name. for each server i need to total

sort -k4,4 myFile | awk '$4!=p {if(p) print "Total= " tot;p=$4;tot=0} {print;tot+=$NF} END {print "Total= " tot}'
1 Like

thanks working fine