NINO Report

Template Example2

report creation date: <% $date %>

This document contains some NINO database information.

Availability:
<% $availsummaryreport %> Summary of Events:
<% &sqlreport("SELECT eventlog.Host, eventlog.EventOID, eventlog.Event, count(*) Count FROM eventlog,trapd WHERE date >= \'$startdate\' AND date < \'$enddate\' AND ( eventlog.trapdid = trapd.id ) GROUP BY eventlog.Host, eventlog.eventoid, eventlog.Event ORDER BY Count DESC LIMIT 0, 10"); %> Critical Events:
<% &sqlreport("SELECT eventlog.ID,eventlog.Date,eventlog.Host,trapd.Severity,eventlog.EventOID,eventlog.Event,eventlog.Ack FROM eventlog, trapd WHERE date >= \'$startdate\' AND date < \'$enddate\' AND ( eventlog.trapdid = trapd.id AND Severity = \'Critical\' ) ORDER BY Date DESC"); %>