NPM - NCM allowing automatic IP change of a node based on NPM alert

Question

Good afternoon all

Say I have several remote locations each with an adsl line and a failover isdn line

I have NPM monitor these creating an alert that goes out when the primary one fails

I would then like NPM to communicate to NCM having it automatically send out a command to change the gateway on the failover box so connectivity is restored pretty much instantly

is this possible?

So far I have the following process

NPM ----> Alert ----> VBScript ----> SQL Query into NCM using IP for the match

Manipulate job file to include Node.ID from SQL Query above

This is where I am getting stuck, if this is possible, can the one job file contain a variable for the node ID (I can't seem to find this variable) thus allowing me to have it control more than 1 gateway as we have several remote locations that each have an adsl and isdn as back up and I want 1 alert to be able to react to any location having an issue

I hope I've made this clear enough

chris.lapoint · Answer

The problem is the NPM node ID isn’t going to match the NPM node ID since they’re separate databases.

If you want the job to be dynamic, you’ve got a couple of options:

Option 1:

* Create custom property in NCM called “Include”  (or something like that)
* Create an NCM job that targets all devices with “Include” = 1
* Create a vbscript that does the following* Sets the “Include” to 1 using  SQL query for the nodes you want to execute the job on
* Starts the NCM job.  It will dynamically chose the node based on the custom property value
* Sets the “Include” to 0 using SQL query

* Run the vbscript from NPM alert action

Option 2:

* Create a vbscript that does the following:* Looks up NCM node ID (in the ConfigMgmt DB) using the node’s IP address as key
* Set the NCM node ID in the job configuration
* Runs the NCM job

* Run the vbscript from NPM alert action

HTH,

randomguy · Answer

Nobody able to throw some light on this??