Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum

  1. Home
  2. Support
  3. Import list of servers

Import list of servers

Scheduled Pinned Locked Moved Support
19 Posts 3 Posters 36.0k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M
    M
    MatthewDreher
    wrote on last edited by
    #1

    Hello all,

    I'm currently in the process of migrating from another monitoring solution and wanted to know if there was an easy way to import a list of names/ip addresses into netxms.  Two caveats here: 1. The servers will not have the agent installed initially (network only monitoring for now) and 2. I'd like to be able to associate an ipv4 and ipv6 ip address to the node when it's imported. 

    Thanks for the assistance.

    1 Reply Last reply
    0
    • T
      T
      tomaskir
      wrote on last edited by
      #2

      You will have to do this using a NXShell script, or using the API (I recommend the Java API, its really easy to work with).

      Actually, if you want to, you can provide me with a sample csv file of you nodes, and I can write the Java importer into NetXMS for you.
      (its that easy, about 200 lines of Java code)

      Example csv:

      Node name, IPv4 address, IPv6 address, Container to bind to
      Example server 1, 1.1.1.1, 1::1, Servers
      Example server 2, 2.2.2.2, , Other container
      
      1 Reply Last reply
      0
      • M
        M
        MatthewDreher
        wrote on last edited by
        #3

        Yep, gimme a bit.  I'll make sure it's formatted like you have below.  It's like 400 plus servers, so it can take a bit to go though

        Thanks a ton.

        1 Reply Last reply
        0
        • M
          M
          MatthewDreher
          wrote on last edited by
          #4

          Hey, I actually realized something.  I probably can't send out this list. Server names/IP addresses might be considered a bit touchy.  Would you be able to take an input using a file formatted like your example?

          1 Reply Last reply
          0
          • T
            T
            tomaskir
            wrote on last edited by
            #5

            Here is a functional NetXMS .csv importer:
            https://github.com/tomaskir/NetXMS-csv-importer

            It will take any address for a node (ipv4, ipv6 or a hostname), but will not add multiple addresses to a single node.
            The reason for this is that NetXMS uses one primary address to communicate with the node, and then discovers all of the node's IP addresses over an Agent (be that NetXMS or SNMP Agent).

            Adding multiple IP addresses to a dynamic interface in NetXMS is not possible manually.
            I dont want to create multiple interfaces to assign multiple addresses to a node, because you would have to delete them manually later on.

            The right solution to having all information (which includes all IP addresses) of a node is to have an Agent.
            So lets not code work-arounds, and focus on solving it properly, by having an Agent present on the server node 🙂

            1 Reply Last reply
            0
            • M
              M
              MatthewDreher
              wrote on last edited by
              #6

              Unfortunately, I can't do that.  I've begged, but first and foremost we need to have an agentless monitoring solution.  I'll test this out this week (and I apologize for the delay... hectic week).

              Thank you very much.

              1 Reply Last reply
              0
              • M
                M
                MatthewDreher
                wrote on last edited by
                #7

                Hey, finally was able to sit down and work on this.  Getting an error  .Error - "NXCException"!
                Error message - "Incompatible operation".

                It imports about 150 servers out of a list of about 600, then I get this message. 

                Update:  Did a little troubleshooting.  Once I get past about 180 or so entires in the nodes table, I only seem to be able to import servers one at a time using the tool.  Otherwise it throws the above exception.

                1 Reply Last reply
                0
                • T
                  T
                  tomaskir
                  wrote on last edited by
                  #8

                  I will consult with Viktor (since the error is from the NetXMS API), and get back to you asap.

                  1 Reply Last reply
                  0
                  • M
                    M
                    MatthewDreher
                    wrote on last edited by
                    #9

                    Thank you very much.  You have no idea how helpful this is.

                    1 Reply Last reply
                    0
                    • T
                      T
                      tomaskir
                      wrote on last edited by
                      #10

                      After consulting with Victor, we found a potential issue when containers for imported nodes have name duplicities with other objects in NetXMS.
                      (internally, code could have chosen a non-container object to attempt to bind a node to)

                      I fixed it and released a newer version:
                      https://github.com/tomaskir/NetXMS-csv-importer/releases

                      Please try and let me know if it works now.

                      1 Reply Last reply
                      0
                      • M
                        M
                        MatthewDreher
                        wrote on last edited by
                        #11

                        Ah... much better.  Thank you very much.

                        1 Reply Last reply
                        0
                        • T
                          T
                          tomaskir
                          wrote on last edited by
                          #12

                          Is it working correctly for you now and importing all the nodes?

                          1 Reply Last reply
                          0
                          • M
                            M
                            MatthewDreher
                            wrote on last edited by
                            #13

                            I had a few duplicate IPs to weed out, but yes, I got everything imported.  Thank you very much for the assistance.

                            1 Reply Last reply
                            0
                            • G
                              G
                              gmonk63
                              wrote on last edited by
                              #14

                              Would it be possible to auto create the container if it does not exist

                              1 Reply Last reply
                              0
                              • T
                                T
                                tomaskir
                                wrote on last edited by
                                #15

                                Do you want just to create the container under "Infrastructure services", or do you want to create a whole container path?

                                1 Reply Last reply
                                0
                                • G
                                  G
                                  gmonk63
                                  wrote on last edited by
                                  #16

                                  Just  under Infrastructure Services

                                  1 Reply Last reply
                                  0
                                  • T
                                    T
                                    tomaskir
                                    wrote on last edited by
                                    #17

                                    Done, I released a new version with container creation support on
                                    https://github.com/tomaskir/NetXMS-csv-importer/releases

                                    1 Reply Last reply
                                    0
                                    • G
                                      G
                                      gmonk63
                                      wrote on last edited by
                                      #18

                                      Wow that was fast ...  Thank you  😄 😄

                                      1 Reply Last reply
                                      0
                                      • G
                                        G
                                        gmonk63
                                        wrote on last edited by
                                        #19

                                        tomas,

                                        is it possible to add a feature that allows setting of proxy address on import

                                        currently its is

                                        Node Name  |Address  |Container to bind to

                                        but it would be nice if it could be as follows

                                        Node Name | Address  | Agent Proxy  |  ICMP Proxy |  SNMP Proxy | SSH Proxy |  Container to bind to

                                        Thanks,

                                        Gary

                                        1 Reply Last reply
                                        0

                                        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                                        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                                        With your input, this post could be even better 💗

                                        Register Login
                                        Reply
                                        • Reply as topic
                                        Log in to reply
                                        • Oldest to Newest
                                        • Newest to Oldest
                                        • Most Votes


                                        • Login

                                        • Don't have an account? Register

                                        • Login or register to search.
                                        Powered by NodeBB Contributors
                                        • First post
                                          Last post
                                        0
                                        • Categories
                                        • Recent
                                        • Tags
                                        • Popular
                                        • Users
                                        • Groups