Add scripts to create myops-getqueryview:

[myops.git] / web / collect / server / summarize_stats.sh

diff --git a/web/collect/server/summarize_stats.sh b/web/collect/server/summarize_stats.sh
new file mode 100755 (executable)
index 0000000..7406a08
--- /dev/null
+++ b/web/collect/server/summarize_stats.sh
@@ -0,0 +1,39 @@
+#!/bin/bash
+
+PREFIX=/var/www/html/uploadlogs/raw/old
+
+# get keys
+key_list="uptime free_disk_root free_disk_vservers fprobe_size"
+extra="
+"
+
+#grep -E "^rpm_versions " * | \
+#      awk '{  for(o=1;o<=NF;o++){ if ( $o ~ /planetlab/){ print $(o) ; } } }' | \
+#      awk -F. '{printf("%s.%s.%s\n", $1,$2,$3) }' | sort | uniq -c
+
+
+if [[ -z "$1" ]] ; then
+    DATE=$( date --date "1 hour ago" +%Y-%m-%dT%H )
+else
+       DATE=$1
+fi
+
+# get count of unique values from keys
+echo $START Hours ago == $DATE
+c=`ls $PREFIX/$DATE/*--upload | wc -l`
+if [[ $c -gt 2 ]] ; then
+    for val in $key_list ; do 
+        echo $val
+        c=`grep -E -h "^$val :" $PREFIX/$DATE/*--upload | wc -l`
+               if [[ $c -gt 2 ]] ; then
+                   grep -h -E "^$val :" $PREFIX/$DATE/*--upload | \
+                               awk '{print $3}' | sort -n | \
+                               /usr/share/myops/web/collect/server/stats.py | \
+                               while read value_name value ; do 
+                                       /usr/share/myops/web/collect/server/load-graphite.py --target "myops.stats.$val.$value_name" --date $DATE  --value $value
+                                       sleep .2
+                               done
+               fi
+    done
+fi
+