Historical wireless clients reports?

Question

I want to create a historical report for the wireless clients (last 30 days). I did not find historical wireless clients report format in the report formats. Anybody know the SQL query for this type of report? It is also a report feature request.

Also I use the following values for wireless statistics retention;

Detailed Wireless Statistics Retention - 7 days, Hourly Wireless Statistics Retention - 30 days, Daily Wireless Statistics Retention - 365 days.

Example Report:

Network_Guru · Answer

Thanks, I already created that report, but it's a little sparse on details.

I may look for a UnDP poller that will log the number of clients connected to each WLC.

That way I can get charts, which usually present better than just numbers.

zzz · Answer

NPM_NV_WL_REPORT_CLIENTS_V is the table you want for most of statistics of wireless clients.

http://thwack.solarwinds.com/thread/53388 gives a sample report for # unique wireless clients by MAC I did before.

Network_Guru · Answer

I too am looking for a "connected clients" report for the previous month for our executives.

There is report for avg & peak connected clients last month, but this is per AP.

We have hundreds of AP's so not a good report to put in front of management.

Ideally I'd like to have this report on a per WLC basis for the last month.

Show me the peak number of connected users across all 9 WLC's.

Better yet would be a graph/chart of total number of connected users last month across all WLCs, as this would also provide usage patterns and trends.