I just started using Nagios and I like that my team can acknowledge problems, but I haven't yet found a way to log the solutions that are used to correct the problems. Is there a tool that logs Nagios alerts and provides a way to complete post-mortems and log solutions so that when someone encounters similar problems, they can reference the logged data?
I have a query that checks if we've made sales of a particular stock item
select * from merchand_history where stock_code = 'zzz007' and create_timestamp >= getdate() order by create_timestamp desc
I'd like to have a sql job that emails a user (I guess using the alert mechanism) but only if there are rows returned by that query.
I can't think how to do this and submit to the hivemind. I really need a sql only solution...
It was a long time coming but I've just had AC installed in my server room. I've also purchased a MiniGoose II from ITWatchDogs which I can't say enough about. So I'm covered by cooling, and I'll be alerted if something goes wrong but what if I'm a significant distance away? What I would really like to do is have a computer controlled winch which could be activated in the event of a problem. Can anyone suggest any hardware / software I might use for this? My MiniGoose II is capable of sending SNMP traps, emails and has consumable XML services so those could be the methods of sending / retrieving the alert. The server room has a security grate which is always locked off hours and a door which has no latch so if pulled would pop open. If our new AC system broke down it wouldn't take long before the temperature in that room hit 90. I was thinking about some sort of winch that could be activated somehow and would reel in its cable thereby opening the door.
Any ideas?
Reconnoiter is a new tool in the world of monitoring. It is not only a trending tool but also an alerting/fault detection one. IMHO, I reckon that it's in the trending capacities that Reconnoiter has a very huge potential.
One of the premises Recoinnoter is built upon is that RRDTool large installations are very inneficient regarding I/O usage and I think this is RRDTool major problem.
One of the things that can difficult the change from the traditional RRDTool frontends to Reconnoiter is, obviously, the cost of change and the learning curve.
So, any of you has experience with Reconnoiter? How's the learning curve? Was it difficult to move from RRDTool frontend applications (Cacti, Munin, Ganglia) to Reconnoiter? I'm looking forward to read your opinions.
Is there an easy way to send an email when a particular severity of event from a particular service hits the Windows server event log? This is on Windows Server 2003, if it makes a difference.
n.b. we do have proper monitoring and alerting in place for production servers at my workplace, but we just a need quick solution for this service in development.