List of all Meraki Device hostnames and IP addresses

SOLVED
loopback0
Conversationalist

List of all Meraki Device hostnames and IP addresses

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?

1 ACCEPTED SOLUTION
AjitKumar
Head in the Cloud

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.

 

List Devices.png

Regards,
Ajit
AjitsNW@gmail.com
www.ajit.network

View solution in original post

7 REPLIES 7
AjitKumar
Head in the Cloud

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.

 

List Devices.png

Regards,
Ajit
AjitsNW@gmail.com
www.ajit.network
jdsilva
Kind of a big deal

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.

 

 

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"
  }
]
Nolan Herring | nolanwifi.com
TwitterLinkedIn

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.

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

Bruce
Kind of a big deal

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

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

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

Get notified when there are additional replies to this discussion.