This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Help Needed from Orion.IpSla.VoipOperationsICMPEcho

mrkuwait over 1 year ago

Hello,
The below syntax gives data as one result per day. How can I get it hourly to create a graph, thank you in advance

SELECT Summarydate, Operation_Name, AVERAGE_of_Avg_Round_Trip_Time
FROM Orion.IpSla.VoipOperationsICMPEcho
where Operation_ID= "768"

Parents

0 marcrobinson over 1 year ago

Try something like this, which uses the hourly entity and the operations entity:

SELECT TOP 1000 op.OperationName
     , r.OperationInstanceID
     , r.RecordTime
     , r.MinRoundTripTime
     , r.AvgRoundTripTime
     , r.MaxRoundTripTime
FROM Orion.IpSla.OperationResultsHourly AS r
INNER JOIN Orion.IpSla.Operations AS op
     ON r.OperationInstanceID = op.OperationInstanceID
WHERE OperationInstanceID = 768

You can remove the top 1000 and consider the following to limit number of days of data by updating the WHERE clause.

SELECT op.OperationName
     , r.OperationInstanceID
     , r.RecordTime
     , r.MinRoundTripTime
     , r.AvgRoundTripTime
     , r.MaxRoundTripTime
FROM Orion.IpSla.OperationResultsHourly AS r
INNER JOIN Orion.IpSla.Operations AS op
     ON r.OperationInstanceID = op.OperationInstanceID
WHERE OperationInstanceID = 768
     AND r.RecordTime > ADDDAY(- 30, GETDATE())

I am not using echo paths but the above statements rely on operation instance ID, so just changing that and you should be able to re-use this for any active IpSLA operation.

Needed to edit: Perfstack may not play well with all features of VNQM.

Reply

0 marcrobinson over 1 year ago

Try something like this, which uses the hourly entity and the operations entity:

SELECT TOP 1000 op.OperationName
     , r.OperationInstanceID
     , r.RecordTime
     , r.MinRoundTripTime
     , r.AvgRoundTripTime
     , r.MaxRoundTripTime
FROM Orion.IpSla.OperationResultsHourly AS r
INNER JOIN Orion.IpSla.Operations AS op
     ON r.OperationInstanceID = op.OperationInstanceID
WHERE OperationInstanceID = 768

You can remove the top 1000 and consider the following to limit number of days of data by updating the WHERE clause.

SELECT op.OperationName
     , r.OperationInstanceID
     , r.RecordTime
     , r.MinRoundTripTime
     , r.AvgRoundTripTime
     , r.MaxRoundTripTime
FROM Orion.IpSla.OperationResultsHourly AS r
INNER JOIN Orion.IpSla.Operations AS op
     ON r.OperationInstanceID = op.OperationInstanceID
WHERE OperationInstanceID = 768
     AND r.RecordTime > ADDDAY(- 30, GETDATE())

I am not using echo paths but the above statements rely on operation instance ID, so just changing that and you should be able to re-use this for any active IpSLA operation.

Needed to edit: Perfstack may not play well with all features of VNQM.

Children

No Data