Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > VoIP & Network Quality Manager (VNQM) > Path based IPSLA Operations: Historical traceroute resource missing history

Path based IPSLA Operations: Historical traceroute resource missing history

Created by Matthew Lamb, last modified by MindTouch on Jun 16, 2016

Views: 40 Votes: 0 Revisions: 3



This article describes the issue when a series of path based IPSLA operations being monitored in VNQM (ICMP Path Echo and ICMP Path Jitter) and in the IPSLA Details view, the Current and Historical traceroute only display limited information. 


  • VNQM version 4+
  • Network devices utilizing ICMP Path Echo and ICMP Path Jitter



The Historical Traceroutes resource only displays the latest historical traceroute information. In some cases, if multiple different traceroutes are gathered from the device, then it will display the latest historical traceroutes per each different traceroute.


This is working by design. If you would like for it to change, you will need to submit a feature request for it. Otherwise, they will need to use reports to gather the information.



  1. Utilize stock report in Report Writer for the Path based historical data.
  2. Create a new report for select data

The query below is also usable to gather traceroute information directly from the database as well. Can be utilized as a SQL based report in Report Writer:

select top 1000
vhopresults.VoipOperationInstanceID as OperationID,
vhopnames.operationname as Name,
ipslaoperationnumber as OperationNumber,
                            DATENAME(TzOffset, SYSDATETIMEOFFSET()))) 
       AS Time,
hopindex as HopIndex,
from VoipPathHopOperationResults vhopresults inner join voipoperationnames vhopnames on vhopresults.voipoperationinstanceid=vhopnames.voipoperationinstanceid
INNER JOIN VoIPOperations vpo on vhopresults.voipoperationinstanceid=vpo.VoipOperationInstanceID
where vpo.ipslaoperationnumber = 40000 and vpo.operationtype = 'ICMP Path Echo'
-- You will need to make sure to set the 2 above where statements to the value want for the operation number and the operation type
-- The types of operation type are: vpo.operationtype = 'ICMP Path Echo' or 'ICMP Path Jitter'
order by vhopresults.VoipOperationInstanceID asc, vpo.ipslaoperationnumber asc, time asc, hopindex asc



Last modified
16:31, 16 Jun 2016