Hi,
I´m looking for any way to create a resource to show me all Access Points in Down status in a NPM page.
Add this to your query. Then, set Status under Field Formatting tab to Icon and IconType to Status.
CASE NPM_NV_WL_ALERT_APS_V.Status
WHEN '0' THEN 'Unknown.gif'
WHEN '1' THEN 'Up.gif'
WHEN '2' THEN 'Down.gif'
END AS Status
Copy the existing "Nodes Not Up" from the standard Home screen, then edit it and add a filter to only show your access points
So a filter like Vendor = 'Meraki' and Status >1
I need to show all Access Point in Down status embedded in Cisco Wireless Controllers.
Are you polling those APs directly, or are they thin and you're looking to determine status via the status in WLC?
Yes, they are thin , and I´m looking fo any way to create a resource in NPM to show me all Thin in down status.
This may work for you. It works for our Aruba controllers with thin APs. Create an Advanced SQL report in Report Writer. Add this SQL. Set ParentID and Available fields in Field formatting to Hidden and set Status format to Icon and Icon type to Status. Then, go to Web console and add 'Report from Report Writer' resource to Summary page, click Edit and select the report name you gave to this report.
SELECT ap.NodeID as NodeID ,ap.ParentID as ParentID ,ap.Available as Available ,CASE ap.Status WHEN '0' THEN 'Unknown.gif' WHEN '1' THEN 'Up.gif' WHEN '2' THEN 'Down.gif' END AS Status ,ap.Name as Name ,ap.IPAddress as IPAddress ,wc.Name as Controller
FROM [NetPerfMon1].[dbo].[Wireless_AccessPoints_View] ap
INNER JOIN [NetPerfMon1].[dbo].Wireless_Controllers as wc ON wc.ID = ap.ParentID
WHERE ap.Available = 0
ORDER BY ap.Name ASC
Hi rgward,
In my NetPerfMon DB I didn´t found Wireless_AccessPoints_View and Wireless_Controllers tables.
Wireless_AccessPoints_View is a NPM View (not a table) and Wireless_Controllers is a NPM table.
I´m using this query to get AP in down status:
SELECT DISTINCT NPM_NV_WL_ALERT_APS_V.ID AS NetObjectID, NPM_NV_WL_ALERT_APS_V.AP_Name AS Name FROM NPM_NV_WL_ALERT_APS_V WHERE ( (NPM_NV_WL_ALERT_APS_V.WirelessType = 'Thin')
AND (NPM_NV_WL_ALERT_APS_V.Status = '2') )
Is there any way to insert a 'Down.gif' icon in this query ?
thanks
rgward and rob.hock,
I appreciate this new view, but is there a way to get alerts on down thin APs? I had it working in NPM 9.5, but it's not worked since I upgraded to 10 (currently on 10.6). I'm using Cisco WLC750s.
D
What about the Advanced Alert "Alert me when a Thin Wireless Access Point goes down", it doesn't work for you? It means, you have Down Thin APs in the list on WL Controller view, but the alert is not triggered?
Guys,
How do we do this in 11.5.2?
A simple SWQL that displays APs that are down.
BUMP
You should make a new discussion for this as this one is marked as answered so not everyone may open it anymore.
You're absolutely right, thanks.
Here's a link to the new discussion, for anyone that lands on this page through a search.
Down Access Points in NPM 11.5.x
I add the APs as nodes - discover the AP range over night and then in the morning run a powershell script to add 'AP' to a custom field. from the wireless table Orion knows about from the controllers. Then you are just monitoring them as normal nodes.
Obviously depends on your licence etc.
