How do I compose a report of clients connecting to 2.4ghz?

[RyanDonaldson]

Hello, 

i have been trying to compose a report of clients connecting to the 2.4 ghz Wifi via the event log, i have been able to get the 802.11 association but that is pulling the 5 ghz as well, I'd rather not have to scroll through thousands of entries to find the ones I'm looking for is there any way to do this?

[alemabrahao]

Check it out.

Re: Report on 2.4Ghz clients - The Meraki Community

Solved: Reporting on clients connecting at 2.4GHz - The Meraki Community

[ammahend]

other option is also running a client report in google sheet using Meraki API, use this link here, then you can filter client by radio 0 or 1 for 2.4 or 5Ghz

https://developer.cisco.com/meraki/build/meraki-dashboard-reports-with-google-sheets/

[Main10ence]

@RyanDonaldson, @ammahend is on the money! Meraki's Google Speadsheets plug in is the way to go here! You can pull and filter the results in a spreadsheet. 

Not only that, you will find more useful reports within the plug-in that will help in the future; I'm sure of it!

[AxL1971]

I use API call for this, The API call I make extracts clients connected to SSID or Radio spectrum, writes to a back end SQL database and then I can report on the data either using Power BI or Excel