Exporting a list of connected devices & Mac Addresses

[Kenn_Buchanan]

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?

[PhilipDAth]

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.

[BrechtSchamp]

I'm with @PhilipDAth here, the API is the way to go.

These are the steps you'll need:

1. 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-becbc...
   
2. Fetch the networks of each org:
   https://documenter.getpostman.com/view/7928889/SVmsVg6K?version=latest#a4858ec1-7b44-4484-b414-d70da...
   
3. Fetch the clients in each network:
   https://documenter.getpostman.com/view/7928889/SVmsVg6K?version=latest#d75ef077-f31a-448f-b27a-38007...
   
4. 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:
   

[SoCalRacer · Accepted solution]

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.

[Kenn_Buchanan]

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.

[pdundon]

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