9 Replies Latest reply on Nov 8, 2016 5:38 PM by issakeitala

    Update multiple records

    issakeitala

      Just got started with Orion API. I have the task of updating a big number of nodes. Here are the steps involved:

       

      1 - Login to Orion

      2 - Navigate to Manage Nodes

      3 - In Manage Nodes->Show Nodes enter an IP address

      4 - If the IP address is not found click on Add Node

      5 - In Add Node ->Define Node->Polling Hostname or IP Address:

           Enter an IP address

      6 -  In Add Node ->Define Node->Polling Method:

           Enable Status Only: ICMP

      7 - In Add Node ->Define Node->Polling Engine:

           select a Polling Server

      8 - Click on NEXT

      9 - In Add Node->Add Application monitors

           Click on NEXT

      10 - In

            BBB = Yes

            Ops = Yes

            Site = AFACDY (for this example, it will change with each IP you add)

            Type Of Device = Circuit

      11 - Click OK, ADD NODE

       

      All these steps could be summed up into SWQL to searching for a record and if the record doesn't exist, run a CREATE query to add it.

      Again, being new to SWIS, I have downloaded and installed SWQL Studio. I have been able to run queries; so far that's where I stand.

      Could anybody point me towards the tools I can use for my project?

       

      Thanks

        • Re: Update multiple records
          designerfx

          issakeitala :

          1: what are you trying to do? Are you solely adding nodes via doing ping + SAM templates + some custom properties?

          2: Are you modifying existing nodes or solely creating new nodes?

          3: How often do you do this? There is a network discovery that may work for this and/or you can edit multiple nodes at the same time from that manage nodes page.

           

          There are indeed ways to script this but I would clarify those first few questions before assuming SWQL is a must. 

            • Re: Update multiple records
              issakeitala

              I have this list with IP addresses and hostnames of devices we have in the field. First, by using the IP addresses I need to find which ones are already in Orion and which ones are not. The ones that are not need, to be added as new nodes. The ones that are, need to be edited. If it's possible to use the manage nodes that would be great.

               

              Thanks

                • Re: Update multiple records
                  designerfx

                  So, relatively good news. You can use discovery to simply try to add everything and it won't cause duplicates if you already have them in orion. You can even just copy + paste the ip addresses or hostname lists, or just tell solarwinds what subnets to use if it's an entire subnet. Look into settings -> network discovery and create a new discovery. There are posts about how that works in thwack, too.

                   

                  What you can do with manage nodes is edit a bunch of node properties at the same time like address, etc. You don't use that to add a bunch of nodes at the same time. You can also edit custom properties through the custom properties editor at settings -> all settings -> manage custom properties. That one is the fastest way to edit one property across a bunch of nodes.

                    • Re: Update multiple records
                      issakeitala

                      I'll create a new discovery and I'll see whether it's possible to enter my list of IP Addresses which are all from different subnets.

                        • Re: Update multiple records
                          issakeitala

                          Adding the list of IP addresses worked well. The IPs that were already in NCM were skipped. The ones that weren't were added.

                          For the ones that have been added, I need to update their hostnames. I also need to set the following properties as such:

                                BBB = Yes

                                Ops = Yes

                                Site = ""

                                Type Of Device = Circuit

                           

                          What's the way to do this with network discovery?

                            • Re: Update multiple records
                              designerfx

                              You just did the part for discovery. The wording for the tool is "network discovery", but calling it discovery is accurate.

                               

                              For updating the properties, you have two easy options and one scripting one.

                              1: use the mange nodes page. Search for a matching criteria such as subnet, hostname, etc. Get your partial match, select them all, hit edit node. Then you can update anything on that page field by field for all the selected nodes. This is the easiest way.

                              2: use the custom properties editor. This is more like editing a web-based spreadsheet but contains whatever you want to edit. Good if you want to edit the group you find from searching A and then the group from searching B in less clicks. Faster, but interface is not as intuitive.

                              3: script it using SWiS (this is where the SWIS comes in)

                               

                              There isn't a way to tie that to discovery, it's not what discovery is for technically speaking. Discovery is for updating/adding nodes, not updating/adding their custom properties etc.