To create link status count on dashboard

satyam_kumar

Hii everyone,

I have fortigate device(60d,60e 100e) i want to make a link status count on dashboard in NPM, NTA . I have not found any OID from the vendor side to create a UNDP for its.

I want to know how much link is UP/DOWN on the dashboard of solarwind if there is any link will down then i want to know which link is down from the dashboard itself.

Is there any alternate way to customise this requirement. Please help me out

Thank You

needaname

You can use a Custom Query Widget with a SWQL query to solve this.

*It will only work for the interfaces that you are already monitoring.

Device with monitored interfaces:

Device with only one interface monitored:

Where is the SWQL query that i created:

SELECT

COUNT(i.Caption) AS [IntCount]

,'/Orion/images/StatusIcons/Small-' + i.StatusIcon AS [_IconFor_IntCount]

,i.Node.Caption AS [DEVICE]

,nw.WebUri AS [_LinkFor_DEVICE]

,'/Orion/images/StatusIcons/Small-' + i.Node.StatusLED AS [_IconFor_DEVICE]

FROM Orion.NPM.Interfaces i

JOIN Orion.NodeWebUri nw ON nw.NodeID = i.NodeID

WHERE

i.Node.Caption = 'YourDeviceHere.domain'

GROUP BY i.Node.Caption, i.Status, nw.WebUri, ('/Orion/images/StatusIcons/Small-' + i.Node.StatusLED), ('/Orion/images/StatusIcons/Small-' + i.StatusIcon)

To customise the query all you need to do is edit the second last line between the brackets.

Replace YourDeviceHere.domain with your device name.

Hope this helps