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

SWQL - Current Percent Utilization of Top 10 Cisco Interfaces

bunjiega101

How would I modify my current query to get the current utilization for the top 10 highest Cisco interfaces

SELECT TOP 10 FullName, OutPercentUtil, InPercentUtil
FROM Orion.NPM.Interfaces

The above isn't seeming to sort by highest used interfaces.

Thank You!

I can't figure out/follow the guides to understanding how to use SWQL

current_example.png

Find more posts tagged with

Accepted answers

yaquaholic

Hi bunjiega101

SWQL works very much like SQL and you need to add an ORDER BY statement to the query before it will do what you want.
Using the DESC for descending order, you get the big numbers first. In the example below I've used the overall PercentUtil column to order the results by, you could use OutPercentUtil or InPercentUtil instead.

SELECT TOP 10 FullName, OutPercentUtil, InPercentUtil
FROM Orion.NPM.Interfaces
ORDER BY PercentUtil DESC

I originally thought you could use both in and out to order the results, such as:
ORDER BY OutPercentUtil, InPercentUtil DESC
But testing this in SWQL studio I was getting some duff results.

All comments

yaquaholic

Hi bunjiega101

SELECT TOP 10 FullName, OutPercentUtil, InPercentUtil
FROM Orion.NPM.Interfaces
ORDER BY PercentUtil DESC

I originally thought you could use both in and out to order the results, such as:
ORDER BY OutPercentUtil, InPercentUtil DESC
But testing this in SWQL studio I was getting some duff results.

bunjiega101

Awesome! Thank You

Do you know how I could only include 'Cisco' as the vendor? I tried the below.

SELECT TOP 10 FullName, OutPercentUtil, InPercentUtil
FROM Orion.NPM.Interfaces
WHERE Vendor = 'Cisco'
ORDER BY PercentUtil DESC

yaquaholic

Easy enough to do, though the Vendor field is stored within the Nodes table, which you can link to easily in SWQL:

SELECT TOP 10 i.FullName, i.OutPercentUtil, i.InPercentUtil
FROM Orion.NPM.Interfaces i
WHERE i.Node.Vendor = 'Cisco'
ORDER BY PercentUtil DESC

I'd like to write up how this linking of tables works, but I'm a bit busy today so i'll point you to a decent post - https://thwack.solarwinds.com/t5/Product-Blog/SWQL-Walkthrough/ba-p/477750

Also check out the Orion SDK on GitHub: https://github.com/solarwinds/OrionSDK

Hope it helps