convert statsf files

convert statsf files

zcat 20150325*_log/elmsto20*/mss.elmsto*stat.gz | grep StatMssCassandraGetSliceWithSliceRange | sed -e 's#[/]# #g' | awk '{print $2,$3,$7,$9,$16,$17}' | sed -e 's/\(..\)\(..\)\(..\)\(...\)+\(....\) /\1:\2:\3.\4 /' | sed 's/\(..:..:\)\([012].....\) /\100 /' | sed 's/\(..:..:\)\([345].....\) /\130 /' > ~/work/aminamid/cmpare/slicerange.txt
for s in 1 2 3 4 5 6 7 8 9 ; do sar -f ../elcdto20${s}_sar.201503250500 -n ETCP -s 12:30:00 -e 14:10:00 | awk "{print \""'elcdto20'${s}"\",\$0; fflush() }"; done
zcat elms*/mss*stat.gz  | grep -e StatMssCassandraGetSliceWithSliceRange -e StatMssRmeImapSelectTime -e StatMssSLRmeCreateMessageTime | sed 's# [^ ;]*;\(.*\)(.*\/[^)]*) # \1 #' |  sed -e 's#[/]# #g' | awk '{print $2,$3,$5,$6,$8,$15,$16}' | sed -e 's/\(..\)\(..\)\(..\)\(...\)+\(....\) /\1:\2:\3.\4 /' | sed 's/\(..:..:\)\([012].....\) /\100 /' | sed 's/\(..:..:\)\([345].....\) /\130 /' 
cat xxx | while read line ; do echo ${line} | sed -e "s/.*\(172.25.105.9.\).\(....\) \(172.25.105.9.\).\(.....\): .*$/tcpdump -nn -r elmsto202_bond5_20150401_1120.cap host \1 and port \2 and host \3 and port \4/"  ; done 


# all mxstat

zcat */*.stat.gz | grep " ms " |  sed 's# [^ ;]*;\(.*\)(.*\/[^)]*) # \1 #' | sed -e 's#[/]# #g' | awk '{print $2,$3,$4,$5,$6,$8,$15,$16}' | sed -e 's/\(..\)\(..\)\(..\)\(...\)+\(....\) /\1:\2:\3.\4 /' | sed 's/\(..:..:\)\([012].....\) /\100 /' | sed 's/\(..:..:\)\([345].....\) /\130 /' > imap_mss_stat.ssv

# all mxos stat

zcat */mxos.stats.201504*gz | grep -e "..-04-2015 \(05:[0-2]\|06:[0-2]\|21:\)"|  sed -e 's#[/,]# #g' | awk '{print $2,$5,$6,$13,$9,$7,$8}' |  sed -e 's/\(..\):\(..\):\(.\). /\1:\2:\30 /' > z_mos.ssv


# mta.stat

 cat *stat | grep "20150408 174" | grep -e StatPool -e StatExtServiceNode | sed -e "s#[;/=]# #g" | awk '{printf("%s %s %s ",$2,$8,$9); for(i=9;i<NF;i++){printf("%s%s",$i,OFS=" ")}print $NF}'| column -t | sort -k2,2 -k1