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 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 view?usp=sharingthe 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