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

IP SLA Reports

Hi Guys,

I need your help about Solarwinds Voice and Network Quality Manager.

In fact, We have installed Solarwinds VNQM in our site. We have also finished the IP SLA configuration.

Now we need to generate IP SLA indicators reports (UDP Jitter) for a particular duration of time in each month every day from 7AM to 7PM (Working Hour).

We have already generated an average value reports the entire day for a month. But i cannot do it for a specifc time interval: for each month, for each day, from 7AM to 7PM.

It seems we have to write a specific script to meet this needs.

Can someone help me about this ?

Find more posts tagged with

Accepted answers

All comments

mesverrum

This is the documentation relating to building business hours based reports

Success Center

ricardo.morais

Hey Aya,

Indeed you can try to use the Report Manager to try to do this but I dont think it will work since the tables for VNQM contains the same hour all the time.

I did a query to actually poll the data from the DB, I will try share below.

Example of a SQL query to retrieve data for ICMP ECHO operations

SELECT sourcenodeid, targetnodeid, avg(avgroundtriptime) as Average

FROM [dbo].[VoipOperationResults]

WHERE datepart(hh, [DateTime]) > 7

and datepart(hh, [DateTime]) < 19

and voipoperationtypeid = 5

group by sourcenodeid, targetnodeid

On the query above I am getting sourcenodeid, targetnodeid and average of roundtriptime for a time between 7 and 19 hours for each day.

Finally the filter is on voipoperationtypeid in this case is 5 for ICMP ECHO.

The full table of Operation Types can be found on the table VoipOperationTypes

BR,

Ricardo Morais

MEKVII

I ran the sql query you wrote which previously worked without issue. But now after 2022.3 I am getting the following error. Is it possible the object name has changed?

Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.VoipOperationResults'.