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.
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 ?
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
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.