add scrappy statistics gathering scripts

[monitor.git] / statistics / aggregate.py

diff --git a/statistics/aggregate.py b/statistics/aggregate.py
new file mode 100755 (executable)
index 0000000..371a2b8
--- /dev/null
+++ b/statistics/aggregate.py
@@ -0,0 +1,39 @@
+#!/usr/bin/python
+
+
+from monitor import database
+import time
+import sys
+
+actall = database.dbLoad("act_all_080825")
+agg = database.dbLoad("aggregatehistory")
+
+for node in actall.keys():
+       for record in actall[node]:
+               if 'date_created' in record:
+                       t = record['date_created']
+               elif 'time' in record:
+                       t = record['time']
+               else:
+                       continue
+
+               acttime = time.strftime("%Y-%m-%d", time.localtime(t)) 
+
+               if acttime > '2007-11-06':
+                       if 'noop' in record['action']:
+                               if node in agg:
+                                       for ntime,state in agg[node]:
+                                               if state == 'BOOT':
+                                                       if ntime > acttime:
+                                                               if type(record['action']) == type([]):
+                                                                       action = record['action'][0]
+                                                               else:
+                                                                       action = record['action']
+                                                               print acttime, action, ntime, state, node
+
+                               #print time.strftime("%Y-%m-%d", time.localtime(t)), record['action'], node
+
+#for node in agg:
+#      for ntime,state in agg[node]:
+#              if state == 'BOOT':
+#                      print ntime, state, node