cancel
Showing results for 
Search instead for 
Did you mean: 

How to Import big list of Client MAC Address

Getting noticed

How to Import big list of Client MAC Address

Hi All,

 

I am search for a solution to import a big amount of Clients with there Mac Address to Withelist them for any Splash Page.

 

If you go to Network-wide Client there is the possibility to export them to Excel. but no Way hoe to import. I also tried to find a solution true Postman by API but didn't find a way.

 

Does anybody has a Idea how to do this?

 

Thanks for any Help on this

8 REPLIES 8
Kind of a big deal

Re: How to Import big list of Client MAC Address

I don't see any option for the import of clients. The single add option on the client page though specifies that it is for clients that have not connected.

 

So it might be easier to change the policy of the clients after they join, just a few clicks etc.

 

I was going to suggest doing this via API

 

PUT /networks/[id]/clients/[mac]/policy

{
"mac": "00:11:22:33:44:55",
"type": "Group policy",
"groupPolicyId": 101
}

 

 

However you'd have to most likely develop a python script to do this, and even you did, I believe Meraki limits the API. "Call volume is limited to 5 calls per second (per organization)"

 

So you would have to find a way to delay the calls, so it would only do a couple every second.

Nolan Herring | nolanwifi.com
TwitterLinkedIn
Kind of a big deal

Re: How to Import big list of Client MAC Address

How are you authenticating (if you are even authenticating) the splash page users?

 

If you use radius, you could return the group policy to use dynamically.

Getting noticed

Re: How to Import big list of Client MAC Address

Hi all,

 

I have to Challenge, first there will be a SSID Called "Public". I have a list of 280 Mac Address of IPAD witch will connect to this SSID but don't need to see the Splash Page. This Means there are WhiteListed! But i only can add this Clients MAC in advanced on by one true the Dashboard. This takes for Ever :-( so i was looking for a better solution doing this.

 

Second: I have a other List of around 180 MAC Address witch will connect to a second SSID called 1:1 with only this mac addresses have the right to connect, and if one of this MAC gets connected it should ask for Username and Password from a Active directory Server.

Kind of a big deal

Re: How to Import big list of Client MAC Address

Is their any chance you could get Meraki systems manager, and use certificate based authentication (on a dedicated SSID)?

 

For the time it is going to take you to set this up and manage it - you could pay for many months of using Systems manager.

 

https://documentation.meraki.com/MR/Encryption_and_Authentication/Certificate-based_WiFi_authenticat...

Getting noticed

Re: How to Import big list of Client MAC Address

Hi Nolan,

 

Your API Call is just working if this MAC Adress already connected once to the Network. IF you add a MAC witch has never connected to the Network you get:

 

{
"errors": [
"Client not found"
]
}

Kind of a big deal

Re: How to Import big list of Client MAC Address

Oh well that's lame. Thanks for letting us know =)
Nolan Herring | nolanwifi.com
TwitterLinkedIn
Getting noticed

Re: How to Import big list of Client MAC Address

Hi All,

 

I just found out that sometimes the solution is closer as you think :-)

 

If you go to Network-Wide --> Clients you can click on add Client on the right side and Add a client Name and MAC and even put him on the Withelist. And if you look close you see the remark one MAC per LINE :-)

 

Bildschirmfoto 2018-11-28 um 16.50.34.png

in This way a could import all Mac Addresses the only thing is that all Client have the same name :-) but this not as important.

Kind of a big deal

Re: How to Import big list of Client MAC Address

Awesome. Not sure how I didn't see that fine print lol

What if you leave the name blank since it says it is optional. I would imagine then it will grab the hostname the client presents like normal.
Nolan Herring | nolanwifi.com
TwitterLinkedIn
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.