topic Adding devices directly in sql in Server Management - Systems Insight Manager

Adding devices directly in sql

Mark Skinner — Wed, 11 Aug 2004 12:04:24 GMT

I have an SQL database that holds information on all the servers that we manage. I would like to add these devised to HPSim.

Does anybody know if there is a command line option or anyway device information can be added directly into the sql database, that will allow HPSim to start monitoring these servers.

Thank you for any help.
Mark.

Re: Adding devices directly in sql

David Claypool — Wed, 11 Aug 2004 12:32:48 GMT

The best way would be through a manual discovery process. Export a file with the hostname and IP address and you can cut and paste the info into the manual discovery window.

Re: Adding devices directly in sql

Mark Skinner — Wed, 11 Aug 2004 12:43:13 GMT

Thanks for the info, but I was really looking for a more automated process, so that when a server is added to our support database a script is run, or details are also added into the HPSim database at the same time.

When the automatic discovery runs and it gets a returned ping it must enter that ip address into the sql db and then start to check what is on that address, if I could find where that ip address is located i could just add the ip addresses I wish to add, and HPSim should then carry on the rest of the automated discovery process.

Does that seem reasonable?

Mark.

Re: Adding devices directly in sql

David Claypool — Wed, 11 Aug 2004 13:18:23 GMT

The problem is that once a device is discovered, it kicks of a complex process of classification, data collection, indexing and so forth, populating several tables in the database. It really isn't practical to add an entry by doing a SQL operation to add a record into the database.

If I can suggest an alternative, your script could use the mxnode command to perform the add. The syntax is

mxnode -a hostname(s)|ipaddress(es)

Find mxnode in \Program Files\HP\Systems Insight Manager\bin. More info is in the help files about how you can use it in different scenarios.

Re: Adding devices directly in sql

Rob Buxton — Wed, 11 Aug 2004 15:36:17 GMT

Mark,
Just a question, are these devices on a number of different IP Subnets?
Why not just use a couple of IP Ranges and kick off the Auto-Discovery process.
I've set my ranges so that any new Servers will be picked up by the regular Auto-Discovery runs.

Re: Adding devices directly in sql

Mark Skinner — Thu, 12 Aug 2004 10:12:38 GMT

Thanks Rob,
But there are about 400 servers on over 100 subnets that I want to monitor, and there are at least 3000 other intel servers I'm not interested in some on the same subnets, and as for unix servers etc there are even more.
So you can see why I want to add the exact ip's but dont want to have to type them all in.
It looks like the mxnodes option could be the way to go.
Thanks for all your help.
Mark