magnachef wrote: > I need to create a report that will email out a report on the previous day's > Error and Critical events. I've been unable to figure out the necessary query > to generate this report. I am currently running on version 2.1.3. > > Thanks.
Hi must be something like: select device,component,firsttime as since from HISTORY where severity > 3 and firsttime and unix_timestamp(firsttime) > unix_timestamp(2009-02-09 00:00:00) and unix_timestamp(firsttime) < unix_timestamp(2009-02-09 23:59:59) With this query you will find all already cleared events. With the following all current events not being cleared up to now: select device,component,firsttime as since from STATUS where severity > 3 and firsttime and unix_timestamp(firsttime) > unix_timestamp(2009-02-09 00:00:00) and unix_timestamp(firsttime) < unix_timestamp(2009-02-09 23:59:59) I think there is no way to do define Event-Reports in the Zenoss-GUI. bye -------------------- m2f -------------------- Read this topic online here: http://forums.zenoss.com/viewtopic.php?p=31109#31109 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
