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

SQWL Query Based on Group

I am using the following query. The issue is that I get elements not listed within the "Metaswitch_Platform" group. Any insight would be appreciated.

SELECT TOP 10 COUNT(AlertActiveID) AS Quantity
	,[ALERTS].AlertObjects.RelatedNodeCaption AS [Node]
	,[ALERTS].AlertObjects.RelatedNodeDetailsURL AS DetailsUrl
	,[Nodes].Status
FROM Orion.AlertActive AS [Alerts]
	,Orion.Groups AS [Groups]
JOIN Orion.Nodes AS [Nodes] ON [ALERTS].AlertObjects.RelatedNodeID = [Nodes].NodeID
WHERE [Alerts].AlertObjects.RelatedNodeCaption IS NOT NULL
	AND [Groups].DisplayName = 'Metaswitch_Platform'
GROUP BY [Alerts].AlertObjects.RelatedNodeCaption
	,[Alerts].AlertObjects.RelatedNodeDetailsUrl
ORDER BY COUNT(AlertActiveID) DESC

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

What are you trying to query for - specifically? I think if you use some Navigation Properties, you might be better served.