Please help me fix this alert - it´s firing all servers:
The alert is firing because of your last condition. If Node Name is equal to any of those listed, fire the alert.
As long as those nodes are in your DB the alert will keep firing. They do not need to meet any other condition the way you have it set up.
And what is the right sintax to create this alert ?
Thanks.
Try this and see what happens. I may not be following what condition you are trying to setup for.
Of course your node names and custom property should be filled in with your entries where i used my own.
Hi Scott,
I made this change in alert, but it´s firing alerts to all servers in the alert:
Let me check the DB to see what the actual select statement is reading. Gimme a few minutes...
Ooo! Also check your last condition... Are you looking for the Amount of memory used or Percent Memory used??
That line says Memory used is greater than 30 bytes.
Here is the actual Select statement that runs. It looks good to me and the test alert i have setup is working as i think it should... I think if you fix that last condition to Percent Memory Used you should be fine. Unless i am not understanding your criteria completely...
SELECT Nodes.NodeID AS NetObjectID, Nodes.Caption AS NameFROM NodesWHERE ( ( (Nodes.Caption = 'a') OR (Nodes.Caption = 'b') OR (Nodes.Caption = 'c')) AND ( (Nodes.Application = 'InfoCorp - Sequranca') AND ( (Nodes.PercentMemoryUsed = 95) OR (Nodes.CPULoad = 80))))
Thanks a lot to your fast answer.
Now my alert works fine !!
regards,
Valdemir
Very nice! Glad you got it sorted out.
scott