topic Python code - all client info into a csv file in Network Platform API

Python code - all client info into a csv file

Stats2 — Fri, 02 Aug 2024 22:58:40 GMT

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.

Re: Python code - all client info into a csv file

Jamiegprice15 — Fri, 02 Aug 2024 23:01:02 GMT

Check this out.

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

Re: Python code - all client info into a csv file

Stats2 — Fri, 02 Aug 2024 23:22:28 GMT

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

Re: Python code - all client info into a csv file

Philip D'Ath — Sun, 04 Aug 2024 09:30:40 GMT

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

Re: Python code - all client info into a csv file

shwpalan — Mon, 05 Aug 2024 19:56:30 GMT

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