Grab last 7 days of load notifications from Hybodus

gistfile1.sql

--  Grab the last 7 days of load notifications
select from_unixtime(notification_history.dts), server.servername, notification_history.message
from server, service, notification_history 
where service.server_id = server.server_id
and notification_history.service_id = service.service_id
and notification_history.message like '%Load%' 
and from_unixtime(notification_history.dts) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) 
order by server.servername desc;