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.

[Michael_Gibbs]

HI, This function is no longer there, does anyone know where to get this information from in the current version of the platform?

[Bruce]

@Michael_Gibbs, the v1 endpoint is /organizations/{organizationId}/inventoryDevices

See the reference here, https://developer.cisco.com/meraki/api-v1/#!get-organization-inventory-devices 

[sharrill]

Hello, I don't see those column options in my dashboard.  Could this be due to not being an admin?