Version 1 (modified by mikeryan, 10 years ago) (diff)

copied from #230

By project:

mysql> select pid, count(*) from experiment_stats where batch
       group by pid order by count(*) desc;
+--------------+----------+
| pid          | count(*) |
+--------------+----------+
| ddos         |     2412 | 
| Fidran       |      134 | 
| FloodWatch   |       48 | 
| MONA         |       29 | 
| worm         |       12 | 
| emulab-ops   |       12 | 
| NSUDDOS      |       11 | 
| DeterTest    |       10 | 
| psuworm      |        8 | 
| UCLAClass    |        8 | 
| SOS          |        6 | 
| USCCSci530   |        5 | 
| rsgc         |        4 | 
| DIAMOND      |        3 | 
| Deter        |        2 | 
| SWOON        |        2 | 
| liveobjects2 |        2 | 
| Sec-Class    |        2 | 
| vinci        |        1 | 
| Panorama     |        1 | 
| T1T2         |        1 | 
| DDoSImpact   |        1 | 
| SecureIED    |        1 | 
| USC558L      |        1 | 
| eWorm        |        1 | 
+--------------+----------+

Activity since 2009:

mysql> select year(last_activity) as yr, month(last_activity) as mo, count(*)
       from experiment_stats
       where batch and year(last_activity) >= 2009
       group by yr, mo order by yr, mo;
+------+------+----------+
| yr   | mo   | count(*) |
+------+------+----------+
| 2009 |    4 |        9 | 
| 2009 |    5 |        1 | 
| 2009 |   10 |        2 | 
| 2010 |    1 |        2 | 
| 2010 |    2 |        2 | 
| 2010 |    3 |        4 | 
| 2010 |    4 |        1 | 
| 2010 |    8 |        1 | 
+------+------+----------+

Attachments (1)

Download all attachments as: .zip