Exporting a list of connected devices & Mac Addresses

SOLVED
Kenn_Buchanan
Conversationalist

Exporting a list of connected devices & Mac Addresses

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?

1 ACCEPTED SOLUTION
SoCalRacer
Kind of a big deal

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.

 

SoCalRacer_1-1575909625048.png

 

 

SoCalRacer_2-1575909802537.png

 

 

View solution in original post

5 REPLIES 5
PhilipDAth
Kind of a big deal
Kind of a big deal

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.

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

 

SoCalRacer
Kind of a big deal

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.

 

SoCalRacer_1-1575909625048.png

 

 

SoCalRacer_2-1575909802537.png

 

 

Kenn_Buchanan
Conversationalist

my screen.pngHi 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.

 

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



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