cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Exporting a list of connected devices & Mac Addresses

SOLVED
Highlighted
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

Accepted Solutions
Highlighted
Kind of a big deal

Re: Exporting a list of connected devices & Mac Addresses

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
Highlighted
Kind of a big deal

Re: Exporting a list of connected devices & Mac Addresses

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.

Highlighted
Kind of a big deal

Re: Exporting a list of connected devices & Mac Addresses

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

 

Highlighted
Kind of a big deal

Re: Exporting a list of connected devices & Mac Addresses

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

Conversationalist

Re: Exporting a list of connected devices & Mac Addresses

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.

 
Highlighted
Conversationalist

Re: Exporting a list of connected devices & Mac Addresses

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



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