0 Replies Latest reply on Oct 23, 2019 2:47 AM by laurentf

    Report: AccessPoint Historical Clients - InterfaceIndex




      The request: A customer is asking if we can provide an overview of all users that connected to an AP associated with a particular Wireless controller for last week, containing:


      - Date/hour connection was made

      - Wi-Fi AP

      - SSID used

      - Name and first name of the person (username)

      - Client IP address


      My approach: I can't find a pre-made report, but a resource containing almost all required information exists in SolarWinds: the History Wireless Clients for last 7 days (see below)


      Excepted that the username is not present and this report can’t be exported to Excel.


      But, using “Hubble” I can retrieve the SWQL query and then add the username, this report will be also exportable in Excel.




      The question: But I can’t found the values in the statement “IN” for cl.InterfaceIndex in an another table, in the case above, the values 2493, 2494.


      How I can retrieve these values ?


      In attachment, you have all queries found in “Hubble”


      Thanks in advance