1 2 3 4 5 6 Previous Next 137 Replies Latest reply on Jul 22, 2015 10:44 AM by allistair Go to original post
      • 100. Re: Orion SDK Information
        tdanner

        We don't have a date planned for the next SDK release. Most of these feature requests are for product changes anyway, so we wouldn't be able to address them through SDK updates.

        • 101. Re: Orion SDK Information
          lynchnigel

          Hiya guys

           

          i've been trying to get some code working, its from the original code, I'm trying to get the AP's over another part of the Orion database -create actual nodes so these can be monitored.

           

          from:

          [wireless_AccessPoints].name and IPAddress fields

           

          To:

          [nodes].caption and SysName

           

          Name properties from the wireless table needs to be copied to the properties of the caption and SysName fields but not sure how to accomplish this.

          There is no properties to copy over so I can remove the   $nodePropsToCopy = @("AgentPort"........)

           

           

          Where the code says:

           

              # Make an in-memory copy of the node

              Write-Host "Copying" $sourceNode.Name "(" $sourceNode.IPAddress ")"

             # Write $SourceNode.Name to $TargetNode.caption / sysname

           

          I was going to insert the copying there as its in a for loop.

           

          im using NPM 11.0.1

          can anyone help

          • 102. Re: Orion SDK Information
            madhavan

            Hi,

             

            Just be on the same page, you wanted to copy all the nodes from one database to another using the copynodes script but you need to replace Caption and SysName with Name and IPAddress of Orion.Packages.Wireless.AccessPoints for all the nodes. Correct?

             

            In that case, in the copynodes.ps1 make the below mentioned changes

             

            1) Replace the below mentioned query (only partial query) in place of

             

            # Fetch all properties of the source node
            $sourceNodeProps = Get-SwisObject $source $sourceNode.Uri

             

            replace with

             

            # Fetch all properties of the source node

            $sourceNodeProps = Get-SwisData $source "SELECT NODES.ACCESSPOINTS.NAME AS CAPTION, NODES.ACCESSPOINTS.IPADDRESS AS SYSNAME, ... (ADD ALL OTHER PROPERTIES FROM NODES EXCEPT CAPTION AND SYSNAME)

            FROM Orion.Nodes Where NodeID = @nodeid" @{nodeid=$sourceNode.Nodeid}

             

            This change should copy all the nodes with Caption and Sysname taken from Orion.Packages.Wireless.AccessPoints. Please let me know if any clarification or changes.

            • 103. Re: Orion SDK Information
              lynchnigel

              Hi Thanks for your quick reply

               

              They are both in the same Orion database but just different tables the tables being From [Wireless_AccessPoints]  and to [Nodes] The reason for copying the properties from:

              [Wireless_AccessPoints].Name  To[Nodes]. Caption and SysName 

              and

              [Wireless_AccessPoints].IPAddress to [Nodes].IPAddress

              Is because there are no equal properties in both tables.

              IE there is no Caption or SysName property in the [Wireless_AccessPoint] table

              • 104. Re: Orion SDK Information
                madhavan

                Hi,

                 

                Still not sure why do you need to update IPAddress and Caption of Orion.Nodes as it may affect the functionality.

                 

                but provided below the PS script which takes the Name and IPAddress from Wireless_AccessPoint for matching nodeid and update Caption and IPAddress with this. You cannot update properties of Wireless_AccessPoint via SDK.

                 

                $nodedetails = Get-SwisData $swis "select Uri, nodeid, caption, ipaddress from orion.nodes"

                 

                foreach ($nodedetail in $nodedetails) {

                 

                    # Get Name and IPAddress from WIress_AccessPoints
                    $wirelessDetail = Get-SwisData $swis "select name, ipaddress from Orion.Packages.Wireless.AccessPoints where nodeid = @nodeid" @{nodeid=$nodedetail.nodeid}  

                 

                    if ($wirelessDetail -ne $null) {
                        # Update Node
                        $nodedetail.Uri|Set-SwisObject $swis -Properties @{Caption=$wirelessDetail.name; ipaddress=$wirelessDetail.ipaddress;}
                    }
                }
                • 105. Re: Orion SDK Information
                  lynchnigel

                  Thank you and sorry I didnt explain very well.

                   

                  I want to be able to create new nodes in [nodes]  from the [wireless_AccessPoint] table.

                   

                  There are no equal properties in both except IPAddress which i can copy over to the Node table and copy the Name contents to SysName and Caption.

                   

                  I hope that's clearer as to what i'm trying to achive and thank you again for the above code.

                  • 106. Re: Orion SDK Information
                    madhavan

                    Hi,

                     

                    To add a node via SDK, you can view the sample @"C:\Program Files (x86)\SolarWinds\Orion SDK\Samples\PowerShell\CRUD.AddNode.ps1"

                     

                    Instead of hard coding the values, you can get the values from wireless_AccessPoint using Get-SwisData and use it in the create script.

                     

                    Just adding IPAddress and Caption will not make the node creation complete. It will not be polled properly. In order to create a node properly, the below mentioned properties should be filled with proper value.

                     

                        "EntityType":"Orion.Nodes",

                        "IPAddress":"10.10.1.1", Sample

                        "IPAddressGUID":"044648a4-0000-0000-0000-000000000000", Sample

                        "Caption":"",

                        "DynamicIP":"false",

                        "EngineID":"1",

                        "Status":"1",

                        "UnManaged":"false",

                        "Allow64BitCounters":"false",

                        "SysObjectID":"",

                        "MachineType":"",

                        "VendorIcon":"",

                        "ObjectSubType":"SNMP",

                        "SNMPVersion":"2",

                        "Community":"public",

                        "RediscoveryInterval":"5",

                        "PollInterval":"120",

                        "StatCollection":"10",

                        "BufferNoMemThisHour":"-2",

                        "BufferNoMemToday":"-2",

                        "BufferSmMissThisHour":"-2",

                          "BufferSmMissToday":"-2",

                          "BufferMdMissThisHour":"-2",

                          "BufferMdMissToday":"-2",

                          "BufferBgMissThisHour":"-2",

                          "BufferBgMissToday":"-2",

                          "BufferLgMissThisHour":"-2",

                          "BufferLgMissToday":"-2",

                          "BufferHgMissThisHour":"-2",

                          "BufferHgMissToday":"-2"

                    • 107. Re: Orion SDK Information
                      yangj


                      Hi ,

                      May i know how solarwinds can trigger other system once detect the server fail ?

                      send out the email or can call exe file? or any other way like activemq?

                      • 108. Re: Orion SDK Information
                        tdanner

                        You can send email and run external programs from an alert trigger action. We don't have direct support for activemq, but you could write a simple script to push the alert details to your queue and make that script an alert trigger action.

                        • 109. Re: Orion SDK Information
                          yangj

                          Hi tdanner,

                          When the email will be sent (trigger condition) , by who , configurable ?

                          Would you please explain more about alert trigger action?

                          Does this action be auto triggered in solarwind system when the server fail?

                           

                          Thanks.

                          • 110. Re: Orion SDK Information
                            tdanner

                            Yes, these things are configurable. I recommend you check out the Advanced Alerts section in the Administrator Guide:

                             

                            http://www.solarwinds.com/documentation/en/flarehelp/orionplatform/#orioncoreagusingorionadvancedalerts.htm%3FTocPath%3D…

                            • 111. Re: Orion SDK Information
                              juniordev

                              Hi,

                              I couldn't see like "What's new in SDK v1.10?". Is there any information about v1.10?

                              • 112. Re: Orion SDK Information
                                tdanner

                                1.10 is a small SDK update. A few bug fixes to the tools and updating the HTML schema documentation for the product releases since last summer.

                                • 113. Re: Orion SDK Information
                                  Mark Roberts

                                  Hi,

                                   

                                  Couple of questions regarding the forthcoming NPM 11.5 / SAM 6.2 releases:

                                   

                                  1. How long after these releases will an updated SDK be

                                  2. Can you give a clue to some of the new/updated features

                                   

                                  many thanks

                                   

                                  Mark

                                  • 114. Re: Orion SDK Information
                                    Jan Pelousek

                                    Hi,

                                    1. Currently released SDK 1.10 is fully compatible with upcoming NPM 11.5/SAM/... releases.

                                    2. The functionality (Verbs, CRUD) is part of the products (Orion Platform, NPM, SAM). SDK just provides interface to use that, so it's quite hard to provide such info here from SDK point of view and is good to check the Metadata.* (Verb, Entity) entities to discover whether the functionality you need is available.

                                     

                                    H.

                                    • 115. Re: Orion SDK Information
                                      caesarkabalan

                                      Hi,

                                       

                                      Quick follow up to Dobb's question above. Jan stated that SDK v1.10 is fully compatible with the new 11.5/6.2 releases, and that is true. Looking at the SDK docs I don't see any way to retrieve new information about currently outstanding alerts. For instance, the Orion.AlertStatus object does not include a severity option. Is there another way that I'm missing to obtain this information? Maybe the SDK is compatible, but just hasn't caught up feature-wise with the 11.5/6.2 release.

                                      • 116. Re: Orion SDK Information
                                        tdanner

                                        We're working on an SDK update for NPM 11.5/SAM 6.2 that will include documentation on how to query the new alerting system. Orion.AlertStatus provides a view into the new alerting system, but it doesn't support all of the new features like Severity.

                                         

                                        Until then, you can use the existing SDK to query the new entities that do provide the full view into the new alerting system. The relevant ones are Orion.AlertActive, Orion.AlertObjects, and Orion.AlertConfigurations. SWQL Studio can show you the properties of these entities.

                                         

                                        You can get the currently outstanding alerts with a query like this:

                                         

                                        SELECT TriggeredMessage, TriggeredDateTime, aa.AlertObjects.EntityCaption, aa.AlertObjects.AlertConfigurations.Severity
                                        FROM Orion.AlertActive aa
                                        
                                        • 117. Re: Orion SDK Information
                                          MagnAxiom

                                          You say "Orion SDK.pdf: The documentation for the SDK. Includes an explanation of the purpose of the SolarWinds Information Service, a description of its query language, SWQL, and walkthroughs of the VBClient and JavaClient sample applications."

                                           

                                          There are NO PDF Files in the 1.10 package.

                                          • 118. Re: Orion SDK Information
                                            tdanner

                                            When I install the Orion SDK, the PDF shows up in C:\Program Files (x86)\SolarWinds\Orion SDK\Documentation.

                                            • 119. Re: Orion SDK Information
                                              njoylif

                                              tdanner, any updates on the docs for the 11.5/SAM 6.2 (new alerting system) for SWQL?  Perhaps the documentation is bundled into the existing v1.10 package ?

                                              • 120. Re: Orion SDK Information
                                                tdanner

                                                Documentation for the new alerting entities has been posted at https://github.com/solarwinds/OrionSDK/wiki/Alerts.

                                                 

                                                (The SDK is moving to Github - see Orion SDK moving to Github.)

                                                • 121. Re: Orion SDK Information
                                                  lcoursy

                                                  How do I start? I try running some examples and I get warnings "mismatched input 'swis' expecting 'Select'". Is there a step through where I could see the order of things? I see examples of different scripts, but do I call them from SWQL Studio? Nothing I've tried has been successful.

                                                  • 122. Re: Orion SDK Information
                                                    derhally

                                                    SWQL Studio accepts a select statement that you want to run.  If you are familiar with SQL you should be able to construct a similar query in SWQL and run it SWQL Studio

                                                     

                                                    The scripts provided need to be run in their respective scripting environments.  perl, powershell, python, etc...

                                                    • 123. Re: Orion SDK Information
                                                      lcoursy

                                                      Right on, I've been hammering the DB for information via SqlDbx and am picking it up. I'll keep working on it.

                                                      • 124. Re: Orion SDK Information
                                                        allistair

                                                        Hello everyone,

                                                         

                                                        I am new to Orion,

                                                        I am tasked with a project upgrade and migrate my NPM to a new server. I understand that version we are currently using is way to old to do a migration(9.1 SP3) so i have installed the new NPM on our new server with a new database server as well. We currently have over 2500 nodes in monitoring. Is there any way i can mass import/export the node information like interfaces being monitored and/or node groups to the new server? Is there any way i can salvage any information using SDK?