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

Looking for SQL Query for Packet Loss

I have a report setup to show a table of nodes with packet loss issues. My only problem is, I cannot get the data to include only nodes with packet loss issues. It either shows all or none... I'm currently using the Dynamic Query Builder but I suspect I would need to convert to SQL/SWQL to get the outcome I'm looking for.

I would like to remove the data with nodes at 0.00%

Here are the columns I'm using for the data:

In short, to all you SQL Gods. Can you help be build a SQL query to pull a table displaying the node caption and the average % packet loss over the last 24 hours and to only include nodes with loss above 0%.

Thanks!

Find more posts tagged with

Accepted answers

All comments

clyde_r

Hi , i whipped one from the alerts really quick for SWQL :

SELECT [data].[DisplayName] AS [DisplayName],[data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.nodes AS data
WHERE
((([data].[UnManaged]) = (False)) AND (([data].[Stats].[PercentLoss]) != (0)))
WITH NOLOCK

I havent tested this for SQL but base on the SWQL query above i would assume the sql should be as below: :

select * -- you can add columnss like : NodeID, Ipaddress, Caption As [Displayname], Sysname , Vendor etc

from Nodes

where PercentLoss != 0

and Unmanaged = 0

stuartd

A very simple SWQL query (just shows NodeID and % loss) is:

SELECT NodeID, PercentLoss
FROM Orion.NodesStats
WHERE PercentLoss != 0

Or with an implicit join to the node table to get the node name it could look like:

SELECT s.Node.Caption, PercentLoss
FROM Orion.NodesStats as s
WHERE PercentLoss != 0

Just add in any other records/table you want to reference as s.recordname to pull data from the RecordName table or s.node.recordname to pull data from the Nodes table.