Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Adding Nodes to SQL Database Without Using the GUI

We recently migrated our SLX database from the desktop engine to a MS SQL server and are greatly expanding the number of nodes and interfaces we're tracking.

Has anyone come up with a way to add nodes and interfaces to the NetPerfMon database without using the GUI? Maybe create a table in access and join it?

Thanks,
Chris

Find more posts tagged with

Accepted answers

bshopp

Not via SNMP trap, we do have request to be able to do this without the GUI and via an API/SDK and this is something we are looking to add in a future release

All comments

pancamo

It would be great if you could do it via the web page!

quote:Originally posted by cshiver

We recently migrated our SLX database from the desktop engine to a MS SQL server and are greatly expanding the number of nodes and interfaces we're tracking.

Has anyone come up with a way to add nodes and interfaces to the NetPerfMon database without using the GUI? Maybe create a table in access and join it?

Thanks,
Chris

mjhamilton

Just out of curiousity more than anything else... why would you want to do this and not use the GUI???

Martin J. Hamilton... lost in a sea of snmp...

cshiver

I ended up using the GUI, but it took me almost three days to add 450 switches.

CiscoWorks, for instance, let's me build and import a .CSV file which helps alot for widespread adds and deletes.

pancamo

Two minutes vs 20 seconds... Several different groups add/update/delete several hosts a day. A simple web interface would be nice and quick...

Also a bulk add feature is DESPERATELY needed.

dp

quote:Originally posted by mjhamilton

Just out of curiousity more than anything else... why would you want to do this and not use the GUI???

Martin J. Hamilton... lost in a sea of snmp...

Network_Guru

Could you not use the Network Discovery tool to add all your devices?
It's documented in the admin guide;

www.solarwinds.net/.../Network_Discovery.htm

-=Cheers=-
NG

cshiver

Network discovery is okay, but for in this particular case I was adding a switch from each of 450 different subnets. Using network discovery would have been more work than doing it the way I ended up doing it (through the GUI).

- C

meethos

I have been trying to find a way to do this. The reason Automation. We nightly add and remove devices from our network. Currently I use a script that downloads a flat file of the entire DNS database then parses it out to create a load file of devices that are new and a delete file for the devices that are no longer in production.
I have been trying to find a way to make this work with Orion. but there are some hooks in the GUI that prevent direct loading into the SQL database. I think automation of device addition adn removal would be an incredibly helpful tool.

pancamo

Several major problems with the network discovery...
1. It's a manual process
2. It's DOG(hours) slow when adding the devices to a large database
3. If you rename a node, discovery creates a duplicate node
4. NO IMPORT FEATURE
5. You have to go back and manually add cpu/storage monitoring (good luck finding which ones were added in the tree view)
6. NO IMPORT FEATURE (yea it's listed 2 times

quote:Originally posted by Network_Guru

Could you not use the Network Discovery tool to add all your devices?
It's documented in the admin guide;

www.solarwinds.net/.../Network_Discovery.htm

-=Cheers=-
NG

al.gartner

I'm going to add my two cents in here as well. We maintain a separate inventory system that we are home building. It would be GREAT to be able to have that system automagically insert a new host record into Solar Winds when it's added. Could be a SQL insert, web post, anything like that.

pblatz

quote:Originally posted by pancamo

Several major problems with the network discovery...
1. It's a manual process
2. It's DOG(hours) slow when adding the devices to a large database
3. If you rename a node, discovery creates a duplicate node
4. NO IMPORT FEATURE
5. You have to go back and manually add cpu/storage monitoring (good luck finding which ones were added in the tree view)
6. NO IMPORT FEATURE (yea it's listed 2 times

quote:Originally posted by Network_Guru

Could you not use the Network Discovery tool to add all your devices?
It's documented in the admin guide;

www.solarwinds.net/.../Network_Discovery.htm

-=Cheers=-
NG

Additionally, I would like to pre-populate my custom properties fields. Thus allowing my cutomized maps, views and reports to be populated with the most up-to-date information without an additional step of importing that information as well.

Thanks,
P. B.

Success requires three bones--wishbone, backbone and funnybone. Kobi Yamada

jebook

Just checking in to see if anyone has made any progress on this subject?

I am hoping to have a script monitor a range of IPs, (on different subnets) and when a new node comes online, automatically enter basic node info into Orion.

Has anyone tested doing a SQL insert of node info directly into MSSQL? If so, I would be interested in any info you could give, what issues you ran in to?

juliov

Someone has a new about it?, I have the same problem.....

FormerMember

You can add nodes via a SQL insert, but it's more complicated than you might expect since each node has a lot of properties (e.g., interfaces, volumes) associated with it.

juliov

When we use the tool System Manager, we need to adjust a little information on NODE and associated to the interface as:

Addnode <Node Name> <IP address> <Community> <InterfaceName> <Interface port> <bandwith).

But this information is in some moments, slow to be added using the system Manager. Some Switches have 300 ports, and it is necessary to add in some cases 30 to 40 devices. And in our case we must repeat the operation on 3 software to manage (Default, backup and Cirrus). We would like to have a way to make this process automatically, without human intervention, using it for a batch processing or import of data, where the information could be inserted without waiting for each transaction.

It would be important that information be included with the check of their consistencies, so that we could check the result at the end of the operation.

This feature would be very important to us ...

FormerMember

Have you tried doing this via the web in v9?