Monitoring SSID for APs

Question

It is possible setup alert if SSID is not working or users are not able to connect to that SSID and also status of SSID

stuartd · Answer

OK so have had a little time to get in front of a system.

You could do a Custom SQL / SWQL Alert  (right at the bottom of the list of "I want to alert on" section:

And the following very basic SQL code

SELECT  * FROM [dbo].[Wireless_AccessPoints]
WITH (NOLOCK)
WHERE Clients = '0'

Would return all yous WAPs where the number of clients connected = 0.

But I have to stress ....this does NOT mean the SSIDs or AP isn't working. It simply means there are no clients connected.

One of the returned records is 'Status' which could be used for the AP being down but not the SSID. But then there is already an OOTB Thin AP down alert.

An alternative SWQL query you could use is:

SELECT ID
	,ParentID
	,Available
	,MACAddress
	,IPAddress
	,Name
	,SSID
	,SignalStrength

FROM Orion.NPM.WL.Clients AS CL
WHERE SignalStrength IS NULL OR SignalStrength = '0'
	AND Available = '1'

This one looks at the Available column (where 1 = UP) and then also at where the SignalStrength is either 0 or empty (null). But again, these conditions being met does not necessarily imply the device and/or an SSID is down.

I suggest you run the queries in either the DB Mgr (SQL) or SWQL Studio (SWQL) and tweak to suit. Once tweaked take that list and investigate if they are actually down or just have no connections, etc.

Truth be told, the reporting, monitoring & alerting of Thin APs by Solarwinds is far short of useful. I have an open Feature Request [  [mention:81aa5c7d88a746b381a458424f93810d:fb5d84b10a5745448a7a45dafc1faa43] ] which you could vote on if you fancy. It might nudge Solarwinds in to doing something about it.

stuartd · Answer

> Is it possible to enable alert when AP's cant broadcast SSID.

Not that I know of from within Solarwinds. You might be able to do it from either a SysLog message or from the manufacturers controller.

As to the Alert if SSID = 0 you'd need to dig into the Wireless AP tables in SWQL and look to see precisely which fields you need and then build an alert out from there. I don't have an install available right now to check, but using SWQL Studio it should be easy enough to identify an appropriate table that has both the SSID names and connection number (you might need to do a JOIN [implied or otherwise] fields.

Then get your alert to query that table and field so that when Conn_Numbs = 0 then alert.

lokeswarapidapa · Answer

Hi @stuartd ,

Thanks for the reply, How to configure the alerts when SSID has zero connections, in our env more than 2K APs are there in different locations. in this condition if users are not connected to AP it will show zero connection i think this will not work. kindly suggest any alternative ways.

Is it possible to enable alert when AP's cant broadcast SSID.