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

    Report: AccessPoint Historical Clients - InterfaceIndex

    laurentf

                      Hello,

       

      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