Access Points on Down 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.

Hi,

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

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

Thanks a lot !!