List of all Meraki Device hostnames and IP addresses

[loopback0]

Hi; I'm looking to get a list of all of our Meraki devices, specifically the hostnames and IP addresses. Is there a way to do this in the dashboard?

[AjitKumar · Accepted solution]

Hi,

Certainly this is possible.

You may use an API to do so or the easier method shall be to download the data as  CSV.

You may tweak the "Select Common" option as per the requirement and download the records.

Screenshot attached for reference.

[jdsilva]

To add to what @AjitKumar said, for tasks like this I prefer the API and this would be the endpoint I think is most applicable:

https://api.meraki.com/api_docs#return-the-inventory-for-an-organization

If you have multiple Orgs you'll need to call it for every Org, but it's a lot faster than going into each org and grabbing the CSV manually. If you only have one Org then I would say grabbing the CSV is probably faster then using the API.

[NolanHerring]

If you want to do this via API I believe this command will do it.

curl -L -H 'X-Cisco-Meraki-API-Key: <key>' -X GET -H 'Content-Type: application/json' 'https://api.meraki.com/api/v0/organizations/[organizationId]/deviceStatuses'

Successful HTTP Status: 200
[
  {
    "name":"My AP",
    "serial":"Q2XX-XXXX-XXXX",
    "mac":"00:11:22:33:44:55:66",
    "status":"online",
    "lanIp:"1.2.3.4",
    "publicIp":"4.3.2.1",
    "networkId":"N_1234"
  }
]

Or possibly this one here

curl -L -H 'X-Cisco-Meraki-API-Key: <key>' -X GET -H 'Content-Type: application/json' 'https://api.meraki.com/api/v0/organizations/[id]/inventory'

[
  {
    "mac": "00:18:0a:12:2d:da",
    "serial": "Q2AT-Z8Q8-7TPH",
    "networkId": "L_646829496481095660",
    "model": "MC74",
    "claimedAt": "1483748363.47231",
    "publicIp": "198.27.198.2"
  }
]

[GlenW70]

Is this the proper method to export the dynamic DNS name assigned to the device too?

I need this for all of our MX devices.