Making Dashboard more Meaningful: Certain Challenges

[AhamBramhasmi]

Team, can someone help to address below challenges?

The Critical to business requirement, for getting details insight, we require daily dump of report in CSV format. So that we can publish more details report with customer on data usage/user behaviour/AP re-alignment (basis no of avg users trend)

Organization

\\ Monitor\\ Summary Report

CSV file in Email Scheduler

Currently, we can get report file but in HTML format. Cannot be collated for monthly report

below one will be quick help

Network Wide

\\ Monitor\\ Clients

Client MAC Address

Currently we can get this detail under list of users connected on specific AP, but require MAC details on Dashboard

Organization

\\ Monitor\\ Summary Report

MAC details in Top Client List

Currently, the (top) “client by usage” report give list of devices with description. But there are more than 1 (sometimes 4) devices with same description. Thus, posing challenge to identify the actual user, this can be mitigated by putting additional column, mentionig MAC of each device. This will help to distinguish devices with similar description

Network Wide

\\ Monitor\\ Clients

Topology

Sometimes the device identifier overlaps. The better presentation will help

[Brash]

For specific requirements in a specific format like this, I would look into using custom scripts to poll the API to get the data. It can then be correlated and formatted as required.

[AhamBramhasmi]

Agree! Tried exploring that option as well. However, in enterprise kind of environment, this is not feasible. And anyways, we have setting options, wherein we select required fields to display. Adding abovesaid options, will help, without much efforts.

[PhilipDAth]

Why not open the HTML file in Excel and process it from there?  You could even re-save in CSV.

[AhamBramhasmi]

This is not a solution but a workaround. And that too with limitations WRT collation, deeper analysis. If you've observed, there's this option of donwloading it on Daily basis in CSV format. So, its just a matter of adding option of Monthly report, apart from Daily.