Network Management

Access Points doesn't appear in "Top 10 Wireless APs by Clients Count"

In the "Top 10 Wireless APs by Clients Count" view, some Access Points do not appear in the top 10, despite having higher client counts.

First published date

1/22/2024 6:01 PM

Last published date

1/21/2026 4:42 PM

Overview

  • In the "Top 10 Wireless APs by Clients Count" view, some Access Points do not appear in the top 10, despite having higher client counts.
  • Upon reviewing the Wireless Access Point table, We observed that the corresponding table entries for those access points are marked as in the 0 available table and Access points marked as 1 are reflected in the top access point client view.

Product section

Network Performance Monitor

Cause

  • Some APs where the polled status is Up have Available set to 0 in the database.
  • Because the Available column is updated only when status changes, it is not fixed with the next successful poll.

Resolution

    To address the AP availability issue, perform the following:

    1. Connect to the SolarWinds Platform server.
    2. Open SolarWinds Platform Service Manager from the SolarWinds Platform folder of the start menu.
    3. Stop all SolarWinds Services.
    4. Open Database Manager from the SolarWinds Platform folder of the start menu.
    5. Select Add Orion Server and expand the SQL server in bold.
    6. Right-click the SolarWinds Platform database and select New Query.
    7. Paste the SQL query below and select Execute Query.
    -- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

update Wireless_AccessPoints set Available=1 where Status=1 and Available=0
    1. Start all SolarWinds services.