We are using IP SLA to monitor performance of our Ethernet circuits in our WAN. If we don't get a IP SLA response on a particular interface on a nodes can that interface icon be made to change color in NPM?
that's an interesting idea... something that would definitely be good for a feature request.
You might try this in the Report Writer application and then you can embed this in a view using the 'Report from Orion Report Writer' resource.
SELECT VI.VOIPOPERATIONINSTANCEID ,VT.OPERATIONTYPE AS 'OPERATION TYPE' ,CASE WHEN ST.OPERATIONSTATUS = 'UNKNOWN' THEN 'UNKNOWN.GIF' WHEN ST.OPERATIONSTATUS = 'UP' THEN 'UP.GIF' WHEN ST.OPERATIONSTATUS = 'DOWN' THEN 'DOWN.GIF' WHEN ST.OPERATIONSTATUS = 'WARNING' THEN 'WARNING.GIF' WHEN ST.OPERATIONSTATUS = 'UNREACHABLE' THEN 'UNREACHABLE.GIF' WHEN ST.OPERATIONSTATUS = 'CRITICAL' THEN 'DOWN.GIF' END AS STATUSLED ,ST.OPERATIONSTATUS AS 'OPERATION STATUS' ,SRC.CAPTION AS 'SOURCE NODE' ,CASE WHEN TGT.CAPTION IS NULL THEN 'ONE-WAY OPERATION' ELSE TGT.CAPTION END AS 'TARGET NODE' ,CONVERT (DATETIME, SWITCHOFFSET (CONVERT(DATETIMEOFFSET, VI.LASTOPERATIONRESULTRECORDTIMEUTC), DATENAME(TZOFFSET, SYSDATETIMEOFFSET()))) AS 'LAST POLLED (LOCAL TIME)'FROM VOIPOPERATIONINSTANCES VIJOIN VOIPOPERATIONTYPES VT ON VT.VOIPOPERATIONTYPEID = VI.VOIPOPERATIONTYPEIDJOIN VOIPOPERATIONSTATUSES ST ON ST.VOIPOPERATIONSTATUSID = VI.VOIPOPERATIONSTATUSIDJOIN ( SELECT N.CAPTION, N.NODEID FROM NODES N JOIN VOIPOPERATIONINSTANCES VI ON N.NODEID = VI.SOURCENODEID ) SRC ON SRC.NODEID = VI.SOURCENODEIDLEFT JOIN ( SELECT N.CAPTION, N.NODEID FROM NODES N JOIN VOIPOPERATIONINSTANCES VI ON N.NODEID = VI.TARGETNODEID ) TGT ON TGT.NODEID = VI.TARGETNODEIDGROUP BY VI.VOIPOPERATIONINSTANCEID ,VT.OPERATIONTYPE ,ST.OPERATIONSTATUS ,SRC.CAPTION ,TGT.CAPTION ,VI.LASTOPERATIONRESULTRECORDTIMEUTC
Let me know how this works out... This is a really intriguing idea.
-ZackM
Loop1 Systems: SolarWinds Training and Professional Services
Awesome....thanks. We will give it a shot and let you know how it turns out. Also, about submitting it as a feature request...why the heck not?. I think I will do just that. Thanks again. Stay tuned!!!
Hi Zack,
How do i copy the query without including the line numbers?
SELECT
VI.VOIPOPERATIONINSTANCEID
,VT.OPERATIONTYPE AS 'OPERATION TYPE'
,CASE
WHEN ST.OPERATIONSTATUS = 'UNKNOWN' THEN 'UNKNOWN.GIF'
WHEN ST.OPERATIONSTATUS = 'UP' THEN 'UP.GIF'
WHEN ST.OPERATIONSTATUS = 'DOWN' THEN 'DOWN.GIF'
WHEN ST.OPERATIONSTATUS = 'WARNING' THEN 'WARNING.GIF'
WHEN ST.OPERATIONSTATUS = 'UNREACHABLE' THEN 'UNREACHABLE.GIF'
WHEN ST.OPERATIONSTATUS = 'CRITICAL' THEN 'DOWN.GIF'
END AS STATUSLED
,ST.OPERATIONSTATUS AS 'OPERATION STATUS'
,SRC.CAPTION AS 'SOURCE NODE'
WHEN TGT.CAPTION IS NULL THEN 'ONE-WAY OPERATION'
ELSE TGT.CAPTION
END AS 'TARGET NODE'
,CONVERT
(DATETIME, SWITCHOFFSET
(CONVERT(DATETIMEOFFSET, VI.LASTOPERATIONRESULTRECORDTIMEUTC),
DATENAME(TZOFFSET, SYSDATETIMEOFFSET())))
AS 'LAST POLLED (LOCAL TIME)'
FROM VOIPOPERATIONINSTANCES VI
JOIN VOIPOPERATIONTYPES VT ON VT.VOIPOPERATIONTYPEID = VI.VOIPOPERATIONTYPEID
JOIN VOIPOPERATIONSTATUSES ST ON ST.VOIPOPERATIONSTATUSID = VI.VOIPOPERATIONSTATUSID
JOIN
(
SELECT N.CAPTION, N.NODEID
FROM NODES N
JOIN VOIPOPERATIONINSTANCES VI ON N.NODEID = VI.SOURCENODEID
) SRC ON SRC.NODEID = VI.SOURCENODEID
LEFT JOIN
JOIN VOIPOPERATIONINSTANCES VI ON N.NODEID = VI.TARGETNODEID
) TGT ON TGT.NODEID = VI.TARGETNODEID
GROUP BY
,VT.OPERATIONTYPE
,ST.OPERATIONSTATUS
,SRC.CAPTION
,TGT.CAPTION
,VI.LASTOPERATIONRESULTRECORDTIMEUTC
Thanks Zack,
Outstanding work!
