Status tree from REST API

davinciguerra

Let me start off by saying that I am not overly familiar with REST, JSON, or SolarWinds; but I am excited to learn!

In our SolarWinds website (which I get to by going to our internal site http:/server/Orion/SummaryView.aspx) we have a hierarchy of based on geography and facility that I can slowly drill into until I get to actual equipment.  It starts at the overall US level, then by state, then county, the location, and then you get to the level of equipment.  Each piece of equipment (switch, router, etc.) has a status (up or down) and each level in the hierarchy has a status that is rolled up from everything underneath of it.  So if something in a field office in Baltimore County is down, Baltimore Count is flagged and so is Maryland; so starting at the top you know where to drill down to to see your issues.  I think this is all standard SolarWinds setup, I am just documenting my thought process so that if my question doesn't make sense you'll know where I went wrong.

Right now I can get a "flat" list of all equipment and its status and when it was last updated using this REST query:

     https://server:17778/solarwinds/informationservice/v3/json/query?query=SELECT+Caption,LastSync,Status+FROM+Orion.Nodes

The response looks like this:

     {"results":[{"Caption":"DCPGOL-SYSTECH1","LastSync":"2018-05-25T18:31:54.6","Status":1},{"Caption":"DCPGOLW01","LastSync":"2018-05-25T18:30:12.873","Status":1}]}

But this is just a flat list and doesn't tell me how the different pieces rollup or are related.  Is there a REST query I can run that will give me a JSON response in a hierarchical form with statuses all the way up and down the hierarchy.  For instance:

US

     Status: 1

     Maryland

          Status: 1

          Baltimore County

               Status: 1

               Switch A

                    Status: 1

               Switch B

                    Status:1

          Montgomery County

               Status: 1

     New York

          Status: 1

Is this even possible?  Any help would be appreciated.  thanks.

tdanner

You can't get hierarchical results from the REST API - it will always give you a list of simple objects with no nesting.

I assume your state/county/location fields are stored as custom properties. You could do something like this:

SELECT N.Caption, N.LastSync, N.Status, CONCAT(N.CustomProperties.Country, '/', N.CustomProperties.State, '/', N.CustomProperties.County, '/') AS Location

FROM Orion.Nodes N

The problem is doing the rollup records for counties and states. There's no good way to aggregate status values within a query. You would have to derive that in your own client script.