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

What SolarwWnds table is average jitter stored?

wack2012

I am creating a SquaredUp dashboard by querying the SolarWinds database and need to know what table to select the avg jitter from?

Find more posts tagged with

Accepted answers

bobmarley

Here is an example of joining tables within SWQL Studio, I included the table you are looking for.

SELECT TOP 500
       Nodes.NodeID
     , Nodes.Caption
     , Nodes.IPAddress
     , Nodes.DNS
     , Nodes.Vendor
     , Nodes.snmpversion
     , Nodes.ObjectSubType as PollingMethod
     ,[Nodes].Engine.ServerName as PollingEngine
     , Nodes.LastBoot
     , [Nodes].IPSlaOperations.UDPJitterOperationStats.AvgJitter
--Lat/Long
     , [Nodes].WorldMapPoint.Latitude AS [Latitude]
     , [Nodes].WorldMapPoint.Longitude AS [Longitude]
--     , [Nodes].CustomProperties.Department

FROM Orion.Nodes

Order by [Nodes].Caption

wack2012

Thanks, that worked. The field is null, so I will need to work with my network team to capture the data.

All comments

chad.every

Look in the IPSLA tables. Jitter is only collected from that feature. On the web console, it is found under My Dashboards > VoIP & Network Quality > Service Assurance Summary. That particular feature requires Cisco IPSA or Juniper RPM setup and configured.

bobmarley

Put Jitter in the search in SWQL Studio

wack2012

Thanks, I was able to find a few tables related to jitter. However, none of the tables have a NodeID that I can join to the Orion.nodes table.

bobmarley

You can join the tables like this:

, [Nodes].IPSlaOperations.UDPJitterOperationStats.AvgJitter

bobmarley

Here is an example of joining tables within SWQL Studio, I included the table you are looking for.

SELECT TOP 500
       Nodes.NodeID
     , Nodes.Caption
     , Nodes.IPAddress
     , Nodes.DNS
     , Nodes.Vendor
     , Nodes.snmpversion
     , Nodes.ObjectSubType as PollingMethod
     ,[Nodes].Engine.ServerName as PollingEngine
     , Nodes.LastBoot
     , [Nodes].IPSlaOperations.UDPJitterOperationStats.AvgJitter
--Lat/Long
     , [Nodes].WorldMapPoint.Latitude AS [Latitude]
     , [Nodes].WorldMapPoint.Longitude AS [Longitude]
--     , [Nodes].CustomProperties.Department

FROM Orion.Nodes

Order by [Nodes].Caption