Live Head Geek Video Chat: Virtualization Trends & Best Practices. Register Now >>
Search 100,860 posts and 877 resources contributed by 61,822 members or post a topic.

Already Joined? Sign in
Adding Nodes to SQL Database Without Using the GUI

Page 1 of 2 (19 items) 1 2 Next > | RSS

rated by 0 users
Answered (Verified) This post has 1 verified answer | 18 Replies | 4 Followers | 14,426 Views


23 Posts
Points 97
cshiver replied on Fri, Oct 29 2004 8:22 AM
rated by 0 users
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
  • | Post Points: 21

Answered (Verified) Verified Answer


3,415 Posts
Points 15,700
Moderator
SolarWinds Certified Professional
SolarWinds Employee
Answered (Verified) bshopp replied on Tue, Jul 6 2010 1:51 PM
rated by 0 users
Verified by MarieB

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

Brandon Shopp - Product Manager Orion NPM, Network Atlas and LANSurveyor
SolarWinds SCP Certified 

  • | Post Points: 21

All Replies


80 Posts
Points 192
pancamo replied on Tue, Nov 2 2004 1:12 PM
rated by 0 users
It would be great if you could do it via the web page!

quote:
Originally posted by cshiver
SleepbrStarWe 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
http://viroptics.blogspot.com/
  • | Post Points: 1

105 Posts
Points 288
mjhamilton replied on Tue, Nov 2 2004 2:27 PM
rated by 0 users
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...
Martin J. Hamilton... lost in a sea of snmp...
  • | Post Points: 1

23 Posts
Points 97
cshiver replied on Wed, Nov 3 2004 10:00 AM
rated by 0 users
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.
  • | Post Points: 1

80 Posts
Points 192
pancamo replied on Thu, Nov 4 2004 2:18 PM
rated by 0 users
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
SleepbrStarJust 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...
http://viroptics.blogspot.com/
  • | Post Points: 1

1,549 Posts
Points 4,406
Thwack MVP
Network_Guru replied on Thu, Nov 4 2004 2:54 PM
rated by 0 users
Could you not use the Network Discovery tool to add all your devices?
It's documented in the admin guide;

http://www.solarwinds.net/netperfmon/help/AdminGuide/Network_Discovery.htm#_VPID_74


-=Cheers=-
NG

-=Cheers=-
NG

(1) Orion v8.1 SLX polling engine & web site
(1) Orion v8.1 SLX polling engine
(1) Orion v9.1 SP4 SL2000
(1) Orion v10.1 SP1 SL2000
(1) APM AL500 RC 2.5, (1) VoIP monitor V2.0, (1) NCM V8.3, (1) EOC
(1) MS SQL2005 SE - 14GB Ram, 3 disk Raid 0
(2) MS SQLExpress2005 c/w 3 & 4 SCSI disk Raid 0

  • | Post Points: 1

23 Posts
Points 97
cshiver replied on Mon, Nov 8 2004 8:28 AM
rated by 0 users
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
  • | Post Points: 1

7 Posts
Points 11
meethos replied on Mon, Nov 8 2004 1:12 PM
rated by 0 users
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.
  • | Post Points: 1

80 Posts
Points 192
pancamo replied on Wed, Nov 10 2004 11:03 AM
rated by 0 users
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
SleepbrStarCould you not use the Network Discovery tool to add all your devices?
It's documented in the admin guide;

http://www.solarwinds.net/netperfmon/help/AdminGuide/Network_Discovery.htm#_VPID_74


-=Cheers=-
NG
http://viroptics.blogspot.com/
  • | Post Points: 1

2 Posts
Points 2
al.gartner replied on Mon, Nov 15 2004 2:40 PM
rated by 0 users
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.
  • | Post Points: 1

61 Posts
Points 95
pblatz replied on Wed, Dec 14 2005 6:52 PM
rated by 0 users
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;

http://www.solarwinds.net/netperfmon/help/AdminGuide/Network_Discovery.htm#_VPID_74


-=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
Thanks, P. B. Success requires three bones--wishbone, backbone and funnybone. Kobi Yamada</font id="size1">
  • | Post Points: 1

1 Posts
Points 2
jebook replied on Mon, Nov 27 2006 9:25 AM
rated by 0 users
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?
  • | Post Points: 1

16 Posts
Points 38
juliov replied on Fri, Jul 4 2008 12:10 PM
rated by 0 users
Someone has a new about it?, I have the same problem.....
  • | Post Points: 3

4,067 Posts
Points 18,201
Moderator
SolarWinds Certified Professional
SolarWinds Employee
denny.lecompte replied on Sun, Jul 6 2008 8:56 AM
rated by 0 users

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.

Denny LeCompte
Director of Product Management
SolarWinds
Austin, TX

  • | Post Points: 3

16 Posts
Points 38
juliov replied on Sun, Jul 6 2008 10:09 PM
rated by 0 users
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 ...
  • | Post Points: 3
Page 1 of 2 (19 items) 1 2 Next > | RSS

© 2003 - 2010 SolarWinds, Inc. All Rights Reserved.

Who is SolarWinds?

SolarWinds is rewriting the rules for how companies manage their networks. Guided by a global community of network engineers, SolarWinds develops simple and powerful network management software and network monitoring software for networks of all sizes. SolarWinds also offers a network certification program to become a SolarWinds Certified Professional (SCP).

What is thwack?

thwack, SolarWinds online community site, was designed by network engineers, for network engineers. thwack is a vibrant, growing community of more than 30,000 IT pros who share a passion for technology.

Explore Resources, Answers, Templates, and Advice

Download Free Networking Tools

Learn More About SolarWinds Products