cancel
Showing results for 
Search instead for 
Did you mean: 
laurentf
Level 8

Report: AccessPoint Historical Clients - InterfaceIndex

                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)

pastedImage_1.png

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

0 Kudos