src/utils/qa/checkHitter.csh 1.2

Index: src/utils/qa/checkHitter.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/checkHitter.csh,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 1000000 -r1.1 -r1.2
--- src/utils/qa/checkHitter.csh	14 Jul 2006 16:47:37 -0000	1.1
+++ src/utils/qa/checkHitter.csh	11 Apr 2009 00:37:01 -0000	1.2
@@ -1,59 +1,60 @@
 #!/bin/tcsh
+source `which qaConfig.csh`
 
 ####################
 #  06-24-05 Bob Kuhn
 #
 #  Checks for activity of heavyHitters
 #
 ####################
 
 set worst=""
 
 if ($#argv != 1) then
   echo
   echo "  checks for activity of heavyHitters."
   echo
   echo '      usage:  ipAddress '
   echo
   exit
 else
   set hitter=$argv[1]
 endif
 
 echo "stats for $hitter"
 
 hgsql -t -h genome-log -e \
   'SELECT COUNT(*) FROM access_log WHERE remote_host = "'$hitter'"' \
   apachelog
 hgsql -t -h genome-log -e 'SELECT (max(time_stamp) - min(time_stamp))/3600 \
   AS hours FROM access_log WHERE remote_host = "'$hitter'"' apachelog
 hgsql -t -h genome-log -e 'SELECT DISTINCT(request_uri) AS queries, \
   COUNT(*) AS number FROM access_log \
   WHERE remote_host = "'$hitter'" GROUP BY queries \
   ORDER BY number DESC' apachelog
 
 set lastHitHitter=`hgsql -N -h genome-log -e 'SELECT max(time_stamp)/3600 \
   FROM access_log WHERE remote_host = "'$hitter'"' apachelog`
 set lastHitAll=`hgsql -N -h genome-log -e 'SELECT max(time_stamp)/3600 \
   FROM access_log' apachelog`
 set quiet=`echo $lastHitAll $lastHitHitter | awk '{printf "%.1f", $1 - $2}'`
 echo
 echo "\n  quiet for $quiet hours\n"
 
 exit
 
 set hitsPerHr=`echo $num $timeHours | gawk '{printf  "%.0f", $1/$2}'`
 (pipes two values, divides them and prints as whole number)
 
 
 SELECT request_uri FROM access_log WHERE remote_host = "149.142.103.54" 
 AND request_uri != "/cgi-bin/hgc" AND request_uri != "/cgi-bin/hgTracks" 
 AND request_uri!= "/cgi-bin/hgGene" limit 10;
 
 
 SELECT COUNT(*) FROM access_log WHERE remote_host = "149.142.103.54" 
 AND request_uri != "/cgi-bin/hgc" AND request_uri != "/cgi-bin/hgTracks" 
 AND request_uri!= "/cgi-bin/hgGene" AND request_uri NOT LIKE "%trash%" 
 limit 10;