Orion Down Nodes Widget with Link to All Related Orion Maps

Hi all,

I am using this custom query widget when in order to search by node id and find out what maps the node is a part of, it works great for this purpose.

SELECT TOP 100
p.DisplayName
,concat('http://{redacted orion IP}/ui/maps/viewer/', p.ProjectID) AS [_LinkFor_DisplayName]
,n.Caption
,n.IPAddress
FROM Orion.Maps.Projects AS p
JOIN Orion.Nodes AS n ON ${SEARCH_STRING}=n.NodeID
WHERE p.Data LIKE '%Nodes_${SEARCH_STRING}/%'

My new goal is to adapt this query to a new purpose. I would like to display all the current down nodes with a link to all maps that are related to their node ID's. Anyone have any ideas how this can be done? I think its a two step process and not sure how to make the SWQL query. First filter down to the down node IDs and than run the above query per node ID returned from the down nodes and join the queries with Union?

Any help would be greatly appreciated I think this would help others as well since it would allow for anyone to drill into a topology map right from the down node list very fast troubleshooting capability. I dare say it might be worth a feature request in NPM if it can't be done through a custom query already.

This is what the current query result looks like when search node id 1807 as an example:

So basically I am looking for the same output but instead of having to enter a search criteria it would union all the current down node ids into the output.

Find more posts tagged with

let solarwinds work

streamline

down nodes

easier

orion maps

Instant troubleshooting

Accepted answers

KMSigma.SWI

This is what I came up with. Let me know if it does what you need.

SELECT DISTINCT [Projects].DisplayName AS [Map Name]
     , [Groups].DetailsUrl AS [_LinkFor_Map Name]
FROM Orion.Container AS [Groups]
INNER JOIN Orion.Maps.Projects AS [Projects]
  ON [Groups].Name = [Projects].ProjectID
WHERE [Groups].Owner = 'Maps'
  AND [Groups].Members.EntityDisplayName = 'Node'
  AND [Groups].Members.Status = 2 --Down

Here's the details:

In the architecture Maps are just Orion Groups.
Orion Groups are called "Containers" in the API (to help keep them distinct from the "GROUP BY" SWQL clause) [Lines 2, 6]
Containers has a connected Navigation Property to members. [Lines 7, 8]
Those members can be anything, so we filter it only to 'Nodes' [line 7]
Then we filter those members to those with a down status. [Line 8]

I think this is what you are looking for, but if not, always happy to help.

All comments

KMSigma.SWI

So you are looking for Map membership that contains Node with ID ###? Am I reading that correctly?

shyde

Close but not quite the above query does return map membership with Node = search string but I'm looking for help to adapt it so there is no search input required and automatically reflects the map membership for all nodes status = 2 aka down nodes.

KMSigma.SWI

I must be crossing lines in my own head here, and for that, I apologize.

You want a custom resource that displays all maps with ANY node down to render by default.
Then after the search, you want it only to show those for nodes that match the search string?

Are you putting this on a Node Details page or a summary page? I assure you there's a reason for this inquiry.

shyde

Not to worry, happy to clarify the confusion I think I created.

The query I provided was just to give example in case it helped the creation of what I was looking for.

You want a custom resource that displays all maps with ANY node down to render by default.
Correct
Then after the search, you want it only to show those for nodes that match the search string
I created confusion here the new widget I am looking for has no requirement for search functionality

Are you putting this on a Node Details page or a summary page? I assure you there's a reason for this inquiry.
Looking to put this on a summary page. Adding it to the Node Details page would actually also be interesting for quick navigation but summary page is where I was initially going with it.