Automated Reports of SLA Operations

casanave

Is there a way to automate reporting showing the last hour of an IP SLA operation status, hourly?

Thanks Guys and Gals,

Find more posts tagged with

ip sla

vnqm

report

Accepted answers

All comments

mrxinu

Hey casanave - you could start with the SWQL query below and then whittle it down to just the operation you're looking for. Once you've got that, you can schedule the report to be run hourly via Settings > Manage Reports. If you're not already using SWQL Studio grab the latest copy by installing the Orion SDK:

Release v2.1.13 · solarwinds/OrionSDK · GitHub

SELECT r.OperationInstanceID, r.OperationTypeID, r.SourceNodeID, r.TargetNodeID, r.OperationResultID, r.RecordTime, r.MinRoundTripTime, r.MaxRoundTripTime, r.AvgRoundTripTimeFROM Orion.IpSla.OperationResults rJOIN Orion.IpSla.Operations o ON r.OperationInstanceID = o.OperationInstanceID AND r.SourceNodeID = o.SourceNodeIDWHERE MINUTEDIFF(r.RecordTime, GETDATE()) <= 60

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu