Usage Over Time Script

[Apple-freak555]

Hi all, 

I'm trying to create a script to help automate the process of extracting data from the Summary Report and inserting it into a CSV file every month. Instead of having someone manually export excels from multiple networks we can have this script speed up that process.

I've been stuck trying to program the "Usage Over Time" category. I've tried using the Get Network Clients Bandwidth Usage History API to extract the data from the category, but the output is inaccurate even with the conversion of Mbps to b/s. I'm not sure if there's an API that I've missed or not. Any help would be greatly appreciated. 

Thanks!

[sungod]

I use https://developer.cisco.com/meraki/api-v1/#!get-network-clients to build monthly usage data.

The per-client rx/tx usage and other info are then crunched to give figures per-client, per-SSID/non-wireless and per-network across the organization.

[AxL1971]

I use this API call to get usage for each AP

https://api.meraki.com/api/v1/networks/<network ID>/wireless/dataRateHistory?deviceSerial=<AP Serial Number>?timespan=3600&resolution=3600

This give me results for the last 10 minutes

Once I collect the info, I parse it and write it to a back end database and use Power BI to display the results