Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

How do you make a modern dashboard that applies only to a group of nodes?

Hello, I am trying to make a KPI widget on a modern dashboard that displays how many computers are up and running, and how many are shut down.

I work in a very large organization with thousands of computers, but I am only interested in about 100, which I have gathered in a node group in Solarwinds.

How do I customize my widget to show only the group that I am interested in?

I have tried the following SWQL query, but I get an unspecified error with no debugging information. I guess WHERE clauses don't work?

SELECT COUNT(NodeID) AS value, Status AS status
FROM Orion.Nodes
WHERE GroupName = 'PI Servers'

Find more posts tagged with

SWQL

Dashboards

Accepted answers

All comments

adam.beedell

Group name doesnt exist like that. You're thinking about "where in this group" but what you're asking for is specifically the property against each device to match 'PI Servers'. Think what it'd be like if a server was a member of two groups.

What you want to do is SELECT or JOIN to the Orion.ContainersMembers where containerid/name = X to fix that query. You could get some reasonably useful errors but they can be buried a bit

(or you could have a group who's membership query is customproperty.application like 'PI' and then you can select nodes.customproperties.application like 'PI', and that operates how you think)

More generally addressing the question, you can filter the whole modern dashboard or you can filter each element as you've suggested. Both can be a good idea

mesverrum

What makes you think groupname is an available attribute in SWQL?

Is that a custom property you have or are you trying to find all nodes that are a member of the PI servers group?

If it's a custom property you would want to join to the noes custom properties table, if it's a group you would join to the tables for container members and containers.

On my phone right now so I can't test and write the actual queries for that easily, but hopefully that gives you enough to find what you need.

You should be using the swql studio tool to come up with your queries, guessing and checking in the web console is much harder to do.

tropicallazerbeams

Honestly I did not know that SWQL Studio even exists, I am just trying SQL queries and hoping they would be similar enough. I will go check out SWQL Studio.

GroupName is not supposed to be a custom property, I am trying to reference the groups that you build in Solarwinds.

tropicallazerbeams

I don't really understand how I would use a select or join statement to return a list of servers belonging to a group. Can you give an example?

Also not sure about setting a custom property on a node and filtering by that. I really just need to build a dashboard that applies to a specific group of servers, hoping to accomplish that as simply as possible.

It would be great to filter the whole dashboard by my group that way I wouldn't have to repeat this whole rodeo every time I create a new widget, but I don't see whole dashboard options like that in the web interface. Is there something I am missing?

adam.beedell

Start from ContainerMembers rather than Nodes then and you'll probably arrive at the right answer

bobmarley

You can do some basic SWQL by using this URL and replacing YOURORIONSERVER with your server name.

https://YOURORINSERVER/Orion/Admin/swis.aspx

The URL to get SWQL Studio is here GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java.

You are going to need to join the tables that @mesverrum stated to link up with the node table. You may not need to link to that table.

Try this replacing YOURGROUPNAME with PI Servers

SELECT COUNT([Container].Members.Name) AS NodeName
FROM Orion.Container
Where [Container].Name LIKE '%YOURGROUPNAME%' AND [Container].Members.Status LIKE '2'

If you want to play with the query more here is GroupName, NodeName, Status.

SELECT
      [Container].Name AS Groupname
,     [Container].Members.Name AS NodeName
,     [Container].Members.Status -- 1 is up, 2 is down, there are others
FROM Orion.Container
Where [Container].Name LIKE '%YOURGROUPNAMEHERE%' AND [Container].Members.Status LIKE '1' --change to a 2 for down status

tropicallazerbeams

Thank you for the hints

tropicallazerbeams

Thank you for the examples, I was able to take these queries and modify them for my needs.

You da man!

KMSigma.SWI

There's a great bunch of knowledge in [mention:611dcbeac4a744629d169bd937026c93:393e7426ce8b492199490c0b60cb1f1e] about how to get started with the API and SWQL Studio.