topic Re: Exporting a list of connected devices & Mac Addresses in Endpoint Security

Exporting a list of connected devices & Mac Addresses

Kenn_Buchanan — Thu, 05 Dec 2019 21:33:01 GMT

Good afternoon All,

I've been asked to supply a list of all SIP devices within our network.

We user "Polycom" IP phones as the SIP devices in this case.

Within the Meraki Cloud environment, we have a few dozen or so sites, all with Polycoms and it would take days or even weeks to manually access each individual site & manually record all of our Polycoms.

I've tried a general dashboard search for 'Polycom_6416' (the 'Description' name all of these devices start with) and received only 6 total results. A nice start, but obviously isn't enough.

How can I go about exporting the full list of one specific device type, across the whole of our network within the cloud?

Re: Exporting a list of connected devices & Mac Addresses

Philip D'Ath — Thu, 05 Dec 2019 22:33:16 GMT

You are going to have to write a script to walk across all the networks and extract this info. Go for Python.

https://developer.cisco.com/meraki/api/#/rest/guides/python-sdk-quick-start

If you don't have the skills consider bringing in someone experienced with Python. I'm guessing you could get a student to do the work for not very much.

Re: Exporting a list of connected devices & Mac Addresses

BrechtSchamp — Fri, 06 Dec 2019 07:28:41 GMT

I'm with @Philip D'Ath here, the API is the way to go.

These are the steps you'll need:

Fetch the orgID's you're interested in (unless they're all in the same org, in which case you can skip this step):
https://documenter.getpostman.com/view/7928889/SVmsVg6K?version=latest#986c513c-9498-47bf-8753-becbcd52fb4b
Fetch the networks of each org:
https://documenter.getpostman.com/view/7928889/SVmsVg6K?version=latest#a4858ec1-7b44-4484-b414-d70da474a8d0
Fetch the clients in each network:
https://documenter.getpostman.com/view/7928889/SVmsVg6K?version=latest#d75ef077-f31a-448f-b27a-38007134bc60
Parse the contents of the last call and create your list. This is what the result looks like. You'll have all the fields you need I think:

Re: Exporting a list of connected devices & Mac Addresses

SoCalRacer — Mon, 09 Dec 2019 16:48:27 GMT

If I am not mistaken you could try the Download as button in the Clients Monitor section of the dashboard. It will export the Manufacturer data from the dashboard, which is a decent place to start. Below are some snips of those. Choose CSV and then use Excel to filter the data. This might be a more manual process, but might be quicker/easier for non coders.

Re: Exporting a list of connected devices & Mac Addresses

Kenn_Buchanan — Thu, 02 Jan 2020 21:40:21 GMT

Hi Everyone,

Thanks for your assistance in coming to resolve on this.

As a non-coder, it looks likes SoCalRacer's suggestion is what I've gone with.

Of course, I'll have to go through each of my org's areas, as illustrated here, from 1 - 75, individually and then combine then into an Excel sheet. It's not as time consuming as I'd expected to be & about 30 minutes in I'm nearly halfway through.

So far so good. Thanks to all, for your assistance.

Re: Exporting a list of connected devices & Mac Addresses

pdundon — Fri, 03 Jan 2020 18:36:39 GMT

This is a great discussion. 75 is a lot but glad you are able to at least use one of the noted solutions!