I wan to create a pie chart with the status of Cisco accespoint. Please any one send me script.

I wan to create a pie chart with the status of Cisco accespoint. Please any one send me script.

  • The following query in SWQL should get you where you need to go, which with the following link on charts in 'Modern' dashboards on how to put in place:

    SELECT wap.DisplayName, wap.status
    FROM Orion.Wireless.AccessPoints wap
    INNER JOIN Orion.Wireless.Controllers c ON c.id = wap.ControllerID
    INNER JOIN Orion.Nodes n ON c.NodeID = n.NodeID
    WHERE n.vendor = 'Cisco'

    https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-fusion-proportional-widgets.htm

    Mark

  • The above script is working. But it is showing one by one device.

    I create a box for the vendor up warning down.

    Could you please create a script to add to this box. So, in one box I can see the status of all network devices.

    Please help me. 

    Please go through the attached file. 

    Waiting your reply. 

  • Sorry, for this, I didn't give you the right query. Try this:

    SELECT s.StatusName AS State, COUNT(wap.status) AS StatusCOUNT
    FROM Orion.Wireless.AccessPoints wap
    INNER JOIN Orion.Wireless.Controllers c ON c.id = wap.ControllerID
    INNER JOIN Orion.Nodes n ON c.NodeID = n.NodeID
    INNER JOIN Orion.StatusInfo s on s.statusid = wap.Status
    WHERE n.vendor = 'Cisco'
    GROUP BY wap.status, s.StatusName

  • The above script is working..But not able to add to my current script.

    Below is the script now I am using. Could you please add the acesspoint details on the below script.

    Thanks in Advance

    SELECT n.Vendor,
    COUNT (CASE n.Status WHEN '1' THEN 1 else NULL end) AS UP,
    COUNT (CASE n.Status WHEN '2' THEN 1 else NULL end) AS DOWN,
    COUNT (CASE n.Status WHEN '3' THEN 1 else NULL end) AS WARNING,
    COUNT (CASE n.Status WHEN '9' THEN 1 else NULL end) AS UNMANAGED
    FROM Orion.Nodes n
    WHERE n.Vendor like 'Cisco' or n.Vendor like 'Palo Alto Networks' or n.Vendor like 'Fortinet, Inc.'
    GROUP BY n.Vendor