Python code - all client info into a csv file

Stats
Here to help

Python code - all client info into a csv file

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.  

4 Replies 4
Jamieinbox
Getting noticed
Stats
Here to help

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

PhilipDAth
Kind of a big deal
Kind of a big deal

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

 

shwetaP
Meraki Employee
Meraki Employee

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-go...

Get notified when there are additional replies to this discussion.
Welcome to the Meraki Community!
To start contributing, simply sign in with your Cisco account. If you don't yet have a Cisco account, you can sign up.