P5/20X/discoverPedestals.sh

0001 #!/bin/sh
0002
0003 cd `dirname $0`
0004 basePath=`pwd`
0005 source /nfshome0/cmssw2/scripts/setup.sh
0006 cd /raid/cmssw/Development/O2O/CMSSW_2_0_8/src/
0007 eval `scramv1 runtime -sh`
0008 cd $basePath
0009 export TNS_ADMIN=/nfshome0/xiezhen/conddb
0010
0011 onlineDB="cms_trk_tkcc/tkcc2008@cms_omds_lb"
0012
0013 sqlplus -S -M "HTML ON " $onlineDB < discoverPedestals.sql | awk 'BEGIN{newline=0; stringa=""} $0~/<*th.*>/{newline=0} $0~/<tr>/{newline=1;if(stringa!="") print stringa; stringa=""} $0~/<\/tr>/{newline=0;} $0!~/<?td.*>/{if(newline && $0!="<tr>"){stringa=sprintf("%s %s",stringa,$0)}} END{print "99999999999999 LATENCY"}' | sort -n| while read line;
0014 do
0015 vec=($line)
0016
0017 echo -e "----------------\n${vec[@]}\n----------------"
0018 done