Wireless Access

Reply
Occasional Contributor I
Posts: 8
Registered: ‎08-11-2014

Report Definition: Client Session Count per Device for specific SSID

[ Edited ]

Hi.

 

I would like to generate a report that gives me a list of devices in specific folders (thin APs), with the total count of client sessions on a specific SSID in a given amount of time, e.g. three weeks.

 

So far, I've tried to define a report with:

  • Device Summary: Devices

but the only available columns are:

  • AP/Device
  • Clients
  • Total Data
  • Avg Usage
  • Location
  • Max Clients
  • Controller
  • Folder
  • Group

Using the report template "Client Session" doesn't seem to help me solving the problem, as the template doesn't give me per-device information.

 

Does anyone have suggestions to this issue?

 

Another subquestion to this:

What does the "Clients" column actually give me?

I suppose it is the total count of unique clients for the period, but i am unsure.

Moderator
Posts: 1,252
Registered: ‎10-16-2008

Re: Report Definition: Client Session Count per Device for specific SSID

The key is 'include details about every session' in Client Session report

 

One way to get this data:

Then you're going to want to create a client session report

Include session data by ssid (list)

Include details about every session -> this is the important part

Set time range for 3 weeks ago to now (3 weeks ago is limited by amount of time historical data retention is set)

Save and run

Once the report is generated

Export the details about every session to CSV

Then you can manipulate in Excel or Spreadsheet to sort by Device Name, SSID, time frame and get counts of rows.

 

Caveats:

If you have a large number of devices / folders -> you may want to create a separate client session report per folder since the reports will get large

This is probably something worth raising a feature request about as well.  This can be done from the Ideas Portal on the Support Page.

 

Clients = unique clients that were present on the SSID (but won't matter if you're only parsing the detailed sessions table)

Sessions = unique sessions with a start and end association event -> multiple sessions can represent a single client in a time period.

 


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company
Occasional Contributor I
Posts: 8
Registered: ‎08-11-2014

Re: Report Definition: Client Session Count per Device for specific SSID

That works like a charm! Thanks a lot.

 

New Contributor
Posts: 1
Registered: ‎01-04-2016

Re: Report Definition: Client Session Count per Device for specific SSID

Hi Rob,

 

May I know if this function needs a controller? Can IAP product this report function?

Thanks.

 

BRs,

Michael

Moderator
Posts: 1,252
Registered: ‎10-16-2008

Re: Report Definition: Client Session Count per Device for specific SSID

Yes, IAPs provide all the same data points that were desired from the report request.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company
Search Airheads
Showing results for 
Search instead for 
Did you mean: