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.statusFROM Orion.Wireless.AccessPoints wapINNER JOIN Orion.Wireless.Controllers c ON c.id = wap.ControllerIDINNER JOIN Orion.Nodes n ON c.NodeID = n.NodeIDWHERE n.vendor = 'Cisco'
https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-fusion-proportional-widgets.htm
Mark
Sorry, for this, I didn't give you the right query. Try this:
SELECT s.StatusName AS State, COUNT(wap.status) AS StatusCOUNTFROM Orion.Wireless.AccessPoints wapINNER JOIN Orion.Wireless.Controllers c ON c.id = wap.ControllerIDINNER JOIN Orion.Nodes n ON c.NodeID = n.NodeIDINNER JOIN Orion.StatusInfo s on s.statusid = wap.StatusWHERE n.vendor = 'Cisco'GROUP BY wap.status, s.StatusName
The above script is working. But it is showing one by one device.
I create a box for [View:https://drive.google.com/file/d/1QpGTS1ffqSqzAcvQWuHMsn6X0NkUhNy1/view?usp=sharing:640:50]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.
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 UNMANAGEDFROM Orion.Nodes nWHERE n.Vendor like 'Cisco' or n.Vendor like 'Palo Alto Networks' or n.Vendor like 'Fortinet, Inc.'GROUP BY n.Vendor
