Here is a way to get this done.
1.Open Start-->All Programs-->Alerting,Reporting and Maping-->Advance Alert Manager
2.Select Configure Alert and then click 'New' option
3.You must be able to take care of the 'General' Tab,coming to 'Trigger Condition' tab.Select the dropdown option for the field "Tyope of Property to Monitor" and select "Custom SQL Alert" option.And for the field "Set up your Trigger Query" select the option "Node".
4.Key in the following Query
select message from Events where EventType=9 and EventTime= 'mm/dd/yyyy hh:mm:ss AM/PM'
Please enter the current date and time on your server in the above Query.So any new Node added from this particular date and time will trigger the email alerts.
5.Now we move to 'Trigger Actions' tab and select the option "Add New Action".
6.Make sure the following tabs are filled in appropriately.
Email/Pager Address,SMTP server
7.Regarding the 'Message' tab,you could enter information like below
Subject:New Node Added
So once this is set,you must start seeing the email alerts whenever a New Node is added to the NPM server.
Hmm surely that query wouldn't work? The 'Node' trigger query would by default just select all nodes since that part of the SQL is already preset (and unchangeable). The 'EventTime =' part should probably be >= anyway, otherwise it would only match a specific date/time.
I would personally go for something a little more accurate and scalable that also allows the trigger to reset (the above query would never reset and you'd have a huge list of triggered alerts). Following the preset Node part of the trigger I would set the query to:
INNER JOIN Events ON Events.NetObjectID = Nodes.NodeID
WHERE NetObjectType = 'N' AND EventType = 9 AND EventTime >= DATEADD(HOUR,-1,GETDATE())
As long as you set the alert check interval to less than an hour that should trigger any devices added within the last hour the trigger is run. It will also reset those triggers after they've matched for an hour.
You were right.I hope this query should work for any new Node added to NPM.
Here is the trigger condition.
select * from events where eventtype = 9 and netobjectid not in (select objectid from alertlog where actiontype='EMail')
Please let me know the results.
thank for your guide, but unfortunately i can't find "Custom SQL Alert" in drop down option.
would you please help me to find it or enable it if it's needed.
What version of NPM are you using?
That'd be why its missing - Custom SQL was introduced in 10.1 if I recall.
You won't be able to touch the Events table until you upgrade.
1 of 1 people found this helpful
That is correct, Advanced SQL in Advanced Alerts was introduced in 10.1
thank you all.
it seems I need to upgrade my NPM for this.