topic Re: MAC address to DEVICE-NAME table? in Apps and SPoT

MAC address to DEVICE-NAME table?

steve_rosen_566 — Wed, 19 Jun 2013 20:22:32 GMT

I'm looking for some sort of way to map MAC addresses to a human readable string (like Steves-iPhone). As I collect and map MAC's I could place them in a Database, Text File, LDAP or Active Directory table. This would make the various management screens easier to track devices for the sake of debugging.

Is this possible? Has anyone done it?

Also, I'm running a ZD1000 with the "9.3.4.0 build 15" firmware.

Thanks,

Re: MAC address to DEVICE-NAME table?

santosh_bittu — Thu, 20 Jun 2013 00:57:00 GMT

Hello Steven,

I see you contacted support regarding the above mentioned question, kindly let me know if the suggestion provided was useful in resolving your issue or not.

Thanks

Re: MAC address to DEVICE-NAME table?

steve_rosen_566 — Thu, 20 Jun 2013 14:40:06 GMT

The support agent (via chat) told me there was no official way to do this. I was just reaching out to the community to see if anyone wrote any sort of extensions or tools to make this type of substitution.

Could it become a feature in future versions?

-Steve

Re: MAC address to DEVICE-NAME table?

keith_redfield — Thu, 20 Jun 2013 21:17:21 GMT

Just for completeness, I'll mention that the workaraound offered was a browser plugin (RegX for Chrome) which essentially does a DOM re-write of the ZD web pages and will substitute (via regular expression matches) one "word" (in this case a MAC address) with another (the name). I would bet GreaseMonkey for FF would be able to do the same (Sorry IE fans...)

I'll have to be blunt - it won't ever happen for the ZD1000. We aren't developing for that platform anymore and 9.3.4 is the last release (ask you reseller about ZD1100 trade-ins though - we're offering some good deals)

I will mention this to our product managers, in particular our ZD Remote App team - we can be a bit more agile with features there.

Re: MAC address to DEVICE-NAME table?

aaron_katske — Wed, 03 Jul 2013 22:41:27 GMT

It would be nice to map names to Mac's. we are using ACLs and I have to keep a spreadsheet so I know whom I have added and not......

Re: MAC address to DEVICE-NAME table?

david_stiff_578 — Fri, 26 Jul 2013 23:19:52 GMT

Steve,

Anticipating your request we have a feature introduced in 9.4 that discovers both the host name and OS type of the device and puts this into the monitor-> clients table!

Here is a quick screen snap so you can what I'm talking about.

https://dl.dropboxusercontent.com/u/9...

Re: MAC address to DEVICE-NAME table?

aaron_katske — Tue, 30 Jul 2013 23:35:10 GMT

This really doesn't address (my) the concern. The problem is that we have a long list in the ACL but we don't know to which device the MAC belongs. What if they haven't logged in?

Re: MAC address to DEVICE-NAME table?

john_olsthoorn — Thu, 08 Aug 2013 07:31:39 GMT

Did you look at snmp / MIB to collect this data? There is documentation on this in the downloads section of the support site.

Re: MAC address to DEVICE-NAME table?

susan_arnold_60 — Thu, 17 Oct 2013 19:04:10 GMT

I just upgraded to 9.5.3.0 build 44 and it does as you have asked - I wanted the same thing. My users do not log in. If there is a name set on the device itself, it displays on the Monitor > Active Clients page. I *love* it. Now to just get the users to give more descriptive device name than "My iPad"!

Re: MAC address to DEVICE-NAME table?

bill_burns_6069 — Thu, 09 Jan 2014 01:56:13 GMT

Here's a script that builds an "offline database" (text file) containing mac-address, hostname and operating system of each wifi client.
https://github.com/bot779/ruckusconf/...

Each time the script is run, it adds the currently associated clients to the database.

I'm not sure that's what you're looking for.
It's not integrated w/ a GUI, but it is useful for certain commandline / scripted uses.

Re: MAC address to DEVICE-NAME table?

jelle_alten_606 — Fri, 14 Mar 2014 18:13:09 GMT

This will not work on the zd1000, right?

Just out of curiosity, how do you actually get this information? I am trying to do something similar (developing an iPhone app), but I find it is not easy at all to retrieve the hostname let alone the OS on the device. It seems it is only possible using a combination of Bonjour, NetBIOS and UPnP. Is that what you do?

Re: MAC address to DEVICE-NAME table?

bill_burns_6069 — Fri, 14 Mar 2014 18:22:40 GMT

Everything depends on what version of ZD firmware you're running. AFAIK: the ZD1000 can't run the latest version. but... I posted a link to a linux script that does exactly what Steve wanted. I think it needs to be tweaked to work with 9.7 firmware but it worked perfectly with 9.6.1
Let me know if you have trouble with it.

Re: MAC address to DEVICE-NAME table?

keith_redfield — Fri, 14 Mar 2014 18:33:48 GMT

right - ZD1000 updates stop at 9.3.4

Re: MAC address to DEVICE-NAME table?

jeffrey_kohl — Wed, 20 Apr 2016 20:13:19 GMT

Now if we can just get the hostname into syslog to feed to our firewall

Re: MAC address to DEVICE-NAME table?

bill_burns_6069 — Wed, 20 Apr 2016 20:22:02 GMT

You're probably better off using IP addresses there anyway, otherwise you'd be trusting whatever name someone manually configured on their device. (if you're talking about the automatically discovered OS/hostname information provided by Ruckus controllers) ..or maybe you wanted the hostname in addition to the IP/MAC for extra info. I just wouldn't want to automate any action based on user provided hostnames.

Re: MAC address to DEVICE-NAME table?

abhishek_sharma — Thu, 29 Dec 2016 17:39:06 GMT

how to ip address of ruckus 2211

Re: MAC address to DEVICE-NAME table?

mehdi_koraichi — Mon, 18 Sep 2017 15:20:16 GMT

hi, how can i get the hostname and osType of the stations connected to an AP via SNMP. I want to get the informations in the clients table via snmp, thanks in advance

Re: MAC address to DEVICE-NAME table?

nate_liv — Sat, 08 Dec 2018 17:14:34 GMT

If I remember correctly, your arp table doesn't have to be complete. Assuming your Lan is on a Switch instead of a Hub, it shows the hosts your machine was connected with previously somehow. And I don't think entries are automatically deleted from the table if a host goes offline or is added when a new one comes online. Your switch has it's own arp table (probably most complete if your Lan only has 1 switch). So has your router and your gateway. As for hostnames, I think you can only get them via lookups. IP Scanners basically do ping sweeps over the subnet to see if certain ports respond. If it does, then it does a lookup for the hostname. Although a bit overkill (and not installed by default) but 'nmap' is an all-in-one tool for these kind of things.

Re: MAC address to DEVICE-NAME table?

arso_martiner — Sun, 16 Dec 2018 05:29:28 GMT

Your switch has it's own arp table (probably most complete if your Lan only has 1 switch). So has your router and your gateway.

As for hostnames, I think you can only get them via lookups.

IP Scanners basically do ping sweeps over the subnet to see if certain ports respond. If it does, then it does a lookup for the hostname.

Although a bit overkill (and not installed by default) but 'nmap' is an all-in-one tool for these kind of things.

see: https://tgw.onl/digitalocean/ https://tgw.onl/siteground/ https://tgw.onl/ipage/