nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Node Widget for a specific custom group

nwbarwell

Hi All,
Don't know if this is the correct place
I am fairly new to the SolarWinds platform and getting to grips with the SWQL creation. so hopefully this is easy.
We have a table widget for health of all our nodes which includes details such as cpu loads memory usage etc.
Now i have created a custom group under the name "telephony" which reports on all the nodes for our telephony servers.
How do i add to only report on those in that group? I have been pulling my hair out. the current SWQL is below.

SELECT n.Caption AS [Node Name]
, n.Status
, n.IPAddress
, n.StatusDescription AS [Status Description]
, n.DetailsURL AS [Node Details URL]
, n.MachineType AS [Vendor Name]
, n.VendorInfo.Icon AS [System Vendor Icon]
, n.CPULoad AS [CPULoad]
, n.ResponseTime AS [Response Time]
, n.PercentMemoryUsed AS [Memory Usge]
, n.PercentLoss AS [Packet Loss]
, CONCAT ('/Orion/SSH/Terminal.aspx?NodeId=' , n.NodeID) AS [SSH]
FROM Orion.Nodes n
WHERE n.MachineType NOT LIKE '%Wind%' AND n.Status != Unmanaged

If any ideas or if its just a simple change please let me know.

Thanks!

Find more posts tagged with

SWQL

Modern Dashboard

Accepted answers

mesverrum

Taking what you have here and combining it with some examples from way back in the day, this should work but I didn't test it Custom SWQL Query Questions

SELECT n.Caption AS [Node Name]
, n.Status
, n.IPAddress
, n.StatusDescription AS [Status Description]
, n.DetailsURL AS [Node Details URL]
, n.MachineType AS [Vendor Name]
, n.VendorInfo.Icon AS [System Vendor Icon]
, n.CPULoad AS [CPULoad]
, n.ResponseTime AS [Response Time]
, n.PercentMemoryUsed AS [Memory Usge]
, n.PercentLoss AS [Packet Loss]
, CONCAT ('/Orion/SSH/Terminal.aspx?NodeId=' , n.NodeID) AS [SSH]
FROM Orion.Nodes n
JOIN Orion.ContainerMembers cm ON cm.MemberPrimaryID=n.NodeID AND cm.MemberEntityType='Orion.Nodes'
JOIN Orion.Containers c on c.containerid = cm.containerid

WHERE n.MachineType NOT LIKE '%Wind%' AND n.Status != Unmanaged
AND c.Name = 'Telephony'

All comments

vinay.by

There are several ways to achieve this, but then I am a big fan of custom properties rather than groups

https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-creating-a-custom-property-sw1289.htm

If you create an node custom property in your environment like say suppose for example 'DeviceType' and you tag all the nodes that fall under 'telephony' as 'DeviceType = telephony' in your environment in that case you can modify your WHERE clause accordingly.

WHERE n.CustomProperties.DeviceType LIKE 'telephony'

I am assuming you are talking about Groups as of now, if you don't want to use custom properties then we are talking about nested queries to pull this from groups.

Hope this helps. Wait for a while and I am sure you will see lot many views from others here.

__PRESENT__PRESENT__PRESENT__PRESENT__PRESENT__PRESENT__PRESENT

mesverrum

nwbarwell

I have got it, Thank you what i did was the following using your guidance

LEFT JOIN Orion.ContainerMembers ON ContainerMembers.name=n.caption AND MemberEntityType='Orion.Nodes'

WHERE ContainerMembers.ContainerID = '138'

this is matching up the correct information now.

Thank you so much!