iso1103

I tried it but it didn't work (I changed line 14 to left join, maybe I did it wrong). If the events are only held for 30 days, how can I get the down time of nodes with down time older than a month? I found something on the alerts table but I don't know how to reach it.