Thwack » SolarWinds » Orion Network Performance Monitor » Adding Nodes to SQL Database Without Using the GUI

in More Search Options

Adding Nodes to SQL Database Without Using the GUI

Last post 07-07-2008 12:54 PM by denny.lecompte. 15 replies.
Page 1 of 1 (16 items)
Sort Posts:

  • 10-29-2004 8:22 AM

    • cshiver
    • Top 500 Contributor
      •
    • Joined on 10-03-2003
    • Posts 23
    • Points 97

    Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-02-2004 1:12 PM In reply to

    • pancamo
    • Top 75 Contributor
      •
    • Joined on 11-14-2003
    • USA
    • Posts 80
    • Points 190

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-02-2004 2:27 PM In reply to

    • mjhamilton
    • Top 75 Contributor
      •
    • Joined on 08-19-2004
    • United Kingdom
    • Posts 105
    • Points 288

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-03-2004 10:00 AM In reply to

    • cshiver
    • Top 500 Contributor
      •
    • Joined on 10-03-2003
    • Posts 23
    • Points 97

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-04-2004 2:18 PM In reply to

    • pancamo
    • Top 75 Contributor
      •
    • Joined on 11-14-2003
    • USA
    • Posts 80
    • Points 190

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-04-2004 2:54 PM In reply to

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

    ---Orion V8.1 SLX, SLX secondary poller, SQL2005 x64 SE, 14GB Ram, 12k+ elements and counting--
    --Orion V9 Sp1 SL2000, SQL2005 Express 866 elements and counting---
    • Post Points: 1

  • 11-08-2004 8:28 AM In reply to

    • cshiver
    • Top 500 Contributor
      •
    • Joined on 10-03-2003
    • Posts 23
    • Points 97

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-08-2004 1:12 PM In reply to

    • meethos
    • Not Ranked
      •
    • Joined on 08-30-2004
    • USA
    • Posts 7
    • Points 11

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-10-2004 11:03 AM In reply to

    • pancamo
    • Top 75 Contributor
      •
    • Joined on 11-14-2003
    • USA
    • Posts 80
    • Points 190

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-15-2004 2:40 PM In reply to

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 12-14-2005 6:52 PM In reply to

    • pblatz
    • Top 100 Contributor
      •
    • Joined on 10-18-2005
    • USA
    • Posts 60
    • Points 94

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 11-27-2006 9:25 AM In reply to

    • jebook
    • Not Ranked
      •
    • Joined on 11-27-2006
    • Posts 1
    • Points 2

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 07-04-2008 12:10 PM In reply to

    • juliov
    • Not Ranked
      •
    • Joined on 06-24-2005
    • Brazil
    • Posts 5
    • Points 11

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    Someone has a new about it?, I have the same problem.....
    • Post Points: 3

  • 07-06-2008 8:56 AM In reply to

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply

    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
    Sr. Product Manager, Orion
    SolarWinds
    Austin, TX
    • Post Points: 3

  • 07-06-2008 10:09 PM In reply to

    • juliov
    • Not Ranked
      •
    • Joined on 06-24-2005
    • Brazil
    • Posts 5
    • Points 11

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply
    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

  • 07-07-2008 12:54 PM In reply to

    Re: Adding Nodes to SQL Database Without Using the GUI

    Reply

     Have you tried doing this via the web in v9?

    Denny LeCompte
    Sr. Product Manager, Orion
    SolarWinds
    Austin, TX
    • Post Points: 1
Page 1 of 1 (16 items)