1 Reply Latest reply on Jul 27, 2015 1:30 AM by madhavan

    Help with simple Json query?

    sja

      Hi

       

      I need query that will give me all the nodes with CP to every node order by node id

       

      Have node ID Okay but how do I join CP and other field from the node table to that JSON query  ?

       

       

      17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT+Caption,dns,vendor,nodeid+from+orion.nodes

       

      I run NPM 11.1.

        • Re: Help with simple Json query?
          madhavan

          Hi,

           

          You can query using extended properties. In SWQL, instead of writing a join query, extended properties can be used. Refer to "C:\Program Files (x86)\SolarWinds\Orion SDK\Documentation\Orion SDK.pdf" for details about extended properties.

           

          Provided below a sample query to query Orion.Nodes's properties and CPs.

           

          select NodeID, Caption, IP_Address, Nodes.CustomProperties.City

          from orion.nodes

           

          Here to query custom properties of nodes, we can add Nodes.CustomProperties.City (EntityName.ExtendedPropertyLinkName.PropertyName)

           

          You can also open SWQL Studio to see the list of extended property links that are created to each entity (Those with link icon)