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

Is there a way to Sort filter nodes using SQL?

I'm working on creating a dashboard that displays nodes down, based on IP address. Is there a way to order the down nodes IP address? The down nodes are showing up but not in order.

Example: IP_Address Like ' *192.168.' AND Status=2

Find more posts tagged with

Accepted answers

All comments

Hi Kyle,

You would need to create a custom widget something along the lines of:

SELECT
n.Caption AS [Node]
,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node]
,n.DetailsUrl AS [_LinkFor_Node]
,n.IP_Address
FROM Orion.Nodes n
WHERE n.Status = 2 AND n.IP_Address LIKE '192.168.%'
ORDER By n.IP_Address ASC

Hope that helps.

Quick Links