Python code - all client info into a csv file

[Stats2]

Hello, I'm not a developer so I'm looking for an easy way to get all organization network/client information (all info) into a csv or excel file. Since I have over 100 networks it would be nice run a python script to export to individual network csv files and/or a signal csv file. There must be something out there that I can just add my API_Key and Organization name (I have many organizations). Thank you in advance for the assistance.

[Jamiegprice15]

Check this out.

Merakicode/ClientScrape at main · jadexing/Merakicode (github.com)

[Stats2]

Thank you for your quick response. I'm looking for the following fields. Also, would like to dump all the networks into a csv/excel file(s) at once. I know I've seen this around but can't find the python script or a way to do this.

(Fields)

Network Name
id
mac
description
ip
ip6
ip6Local
user
firstSeen
lastSeen
manufacturer
os
deviceTypePrediction
recentDeviceSerial
recentDeviceName
recentDeviceMac
recentDeviceConnection
ssid
vlan
switchport
usage
status
notes
groupPolicy8021x
adaptivePolicyGroup
smInstalled
pskGroup
wirelessCapabilities

[Philip D'Ath]

Try looking at this example in the Python SDK that dumps the clients into every network into a CSV file per network.

https://github.com/meraki/dashboard-api-python/blob/main/examples/aio_org_wide_clients_v1.py

[shwpalan]

I would also recommend looking into Meraki Google sheets plugin - https://developer.cisco.com/docs/meraki-tools-google-sheets-add-on/introduction/#meraki-tools-for-google-sheets