To save those who don't like a book I'll put my question up top and then the
history will follow:
Main Question:
is there a list of all the Event Variables and their criteria to using them in
email alerts available?
History:
I'll admit I'm a Newbie to Zenoss, about 3 weeks old now, but this forum and
the manual have been great in getting us running. We've just ordered Zenoss
Core Network and System Monitoring by Michael Badger and are verry pleased by
what we have seen Zenoss do in this short time.
We were about to enter phase 2 of our testing/rollout, when I thought I'd
revamp the Event alerts, to make them more user friendly. Using the Forum I
found you could use most HTML as long as you had <! at the end of each line to
comment out the <cr> Zenoss attaches. Simple enough, but I wanted to see how
each Piece of information came through the email perhaps there was a transform
or two I could use.
I copied the list found on the bottom of the Alerts window added the "%(" and
the ")s" and pasted that into my alerts, sadly that broke then alerts.
Normally if you break the HTML in an alert it sends the default alert, but
according to this I broke the SQL in an alert (see below) and it sends nothing.
I've reverted my alerts to their previous form and they send again but two
questions remain:
Questions:
What variable broke the alert?
(Main question from above)
Is there a list of all the Event Variables and their criteria to using them in
email alerts available?
Log:
Here is the log from ZenActions, showing I broke the SQL on the alerts
> 2008-10-03 17:47:45 INFO zen.ZenActions: processed 1 rules in 0.01 secs
> 2008-10-03 17:48:45 INFO zen.ZenActions: Processed 0 commands in 0.000045
> 2008-10-03 17:48:45 WARNING zen.ZenActions: SELECT
> prodState,firstTime,facility,eventClassKey,agent,dedupid,manager,Location,ownerid,stateChange,eventClass,id,DevicePriority,suppid,priority,DeviceClass,eventKey,monitor.,evid,eventClassMapping,component,clearid,DeviceGroups,eventGroup,ntevid,device,severity,count,message,summary,eventState,lastTime,ipAddress,Systems,severity,summary,
> evid FROM status WHERE (prodState <= 1000) and (eventState = 0) and
> (severity >= 2) AND evid NOT IN (SELECT evid FROM alert_state WHERE
> userid='admin' AND rule='Testing' )
> 2008-10-03 17:48:45 ERROR zen.ZenActions: action:Testing
> Traceback (most recent call last):
> File "/usr/local/zenoss/zenoss/Products/ZenEvents/zenactions.py", line 220,
> in processRules
> self.processEvent(zem, ar, actfunc)
> File "/usr/local/zenoss/zenoss/Products/ZenEvents/zenactions.py", line 246,
> in processEvent
> for result in self.query(q):
> File "/usr/local/zenoss/zenoss/Products/ZenEvents/zenactions.py", line 182,
> in query
> curs.execute(stmt)
> File
> "/usr/local/zenoss/python/lib/python2.4/site-packages/MySQLdb/cursors.py",
> line 137, in execute
> self.errorhandler(self, exc, value)
> File
> "/usr/local/zenoss/python/lib/python2.4/site-packages/MySQLdb/connections.py",
> line 33, in defaulterrorhandler
> raise errorclass, errorvalue
> ProgrammingError: (1064, "You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right syntax to
> use near
> 'evid,eventClassMapping,component,clearid,DeviceGroups,eventGroup,ntevid,device,s'
> at line 1")
> 2008-10-03 17:48:45 INFO zen.ZenActions: processed 1 rules in 0.01 secs
>
Current Specs:
Zenoss 2.2.4 on Red Hat 5
100 Dell Servers Monitored with
|-Open Manage 5.4
|-SNMP-informant installed
MIBs uploaded and Traps flowing as intended
Basic HTML Email Alerts going out
Like I said we are on the verge of phase 2, and everyone here has been helpful,
simply in the amount of information available to anyone who searches the
forums... I just haven't seen this yet
-------------------- m2f --------------------
Read this topic online here:
http://forums.zenoss.com/viewtopic.php?p=25899#25899
-------------------- m2f --------------------
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
