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

Reports - 95th Percentile Traffic

sboston

How do I change the SQL query to select only certain interfaces?

Find more posts tagged with

SWQL

sql query

Accepted answers

KMSigma.SWI

Depends entirely how you want to filter it.

Below is a simple example:

SELECT I.InterfaceID
     , N.NodeID
     , N.Caption AS NodeName
     , N.DetailsUrl AS NDetailsUrl
     , N.VendorIcon AS Vendor
     , I.Caption AS Interface_Caption
     , I.InterfaceIcon AS Interface_Icon
     , I.DetailsUrl AS IDetailsUrl
     , AverageInboundBps95th
     , AverageOutboundBps95th
     , AverageTotalBps95th
FROM (
     SELECT [DateTime]
          , InterfaceID
          , AverageInboundBps95th
          , AverageOutboundBps95th
          , AverageInboundBps99th
          , AverageTotalBps95th
     FROM Orion.NPM.InterfacePercentiles
     WHERE [DATETIME] BETWEEN AddMonth(- 1, DateTrunc('month', GETUTCDATE()))
               AND DateTrunc('month', GETUTCDATE())
     ) AS IP
JOIN Orion.NPM.Interfaces AS [I]
     ON I.InterfaceID = IP.InterfaceID
JOIN Orion.Nodes AS [N]
     ON I.NodeID = N.NodeID
WHERE [N].Caption LIKE 'StartsWith%'
     OR [I].Caption LIKE '%EndsWith'

It just uses standard SQL-style filtering with a WHERE clause.

All comments

KMSigma.SWI

What query are we talking about? Can you include a screenshot or something to help us understand specifically where you are trying to make this change?

sboston

Sorry....It is this query

SELECT
I.InterfaceID,
N.NodeID,
N.Caption AS NodeName,
N.DetailsUrl AS NDetailsUrl,
N.VendorIcon AS Vendor,
I.Caption AS Interface_Caption,
I.InterfaceIcon AS Interface_Icon,
I.DetailsUrl AS IDetailsUrl,
AverageInboundBps95th,
AverageOutboundBps95th,
AverageTotalBps95th
FROM
(
SELECT
[DateTime],
InterfaceID,
AverageInboundBps95th,
AverageOutboundBps95th,
AverageInboundBps99th,
AverageTotalBps95th
FROM Orion.NPM.InterfacePercentiles
WHERE [DATETIME] BETWEEN AddMonth(-1,DateTrunc('month', GETUTCDATE())) AND DateTrunc('month', GETUTCDATE())
) AS IP
JOIN Orion.NPM.Interfaces I ON I.InterfaceID = IP.InterfaceID
JOIN Orion.Nodes N ON I.NodeID = N.NodeID

KMSigma.SWI

Depends entirely how you want to filter it.

Below is a simple example:

SELECT I.InterfaceID
     , N.NodeID
     , N.Caption AS NodeName
     , N.DetailsUrl AS NDetailsUrl
     , N.VendorIcon AS Vendor
     , I.Caption AS Interface_Caption
     , I.InterfaceIcon AS Interface_Icon
     , I.DetailsUrl AS IDetailsUrl
     , AverageInboundBps95th
     , AverageOutboundBps95th
     , AverageTotalBps95th
FROM (
     SELECT [DateTime]
          , InterfaceID
          , AverageInboundBps95th
          , AverageOutboundBps95th
          , AverageInboundBps99th
          , AverageTotalBps95th
     FROM Orion.NPM.InterfacePercentiles
     WHERE [DATETIME] BETWEEN AddMonth(- 1, DateTrunc('month', GETUTCDATE()))
               AND DateTrunc('month', GETUTCDATE())
     ) AS IP
JOIN Orion.NPM.Interfaces AS [I]
     ON I.InterfaceID = IP.InterfaceID
JOIN Orion.Nodes AS [N]
     ON I.NodeID = N.NodeID
WHERE [N].Caption LIKE 'StartsWith%'
     OR [I].Caption LIKE '%EndsWith'

It just uses standard SQL-style filtering with a WHERE clause.