And for excel, I followed the TAC guide on how the calculation works, and made an excel formula to calculate 2.4 & 5GHz bssids - but you have to break apart the calculation into chunks since the formula is too long to fit in one cell. Depending on your Excel version, CONCAT() may be used instead of CONCATENATE().
Assume cell B4 contains the mac address (no colons):
B4 = 001122aabbcc //eth0 mac of AP//
A2 = 4 (my BSSID offset for a particular BSSID in the list of VAPs on the AP group ... starts at 0 and goes to F, allowing 16 BSSIDs. They are always in order of vaps defined in the ap-group)
B7 = CONCATENATE(MID($B4,1,6),DEC2HEX(BITXOR(8,HEX2DEC(MID($B4,8,1))))) //first part of the BSSID (OUI) (#1-#6), drop the first HEX (#7) after OUI, and XOR the next HEX char (#8 XOR (1000))//
B8 = CONCATENATE(MID($B4,9,3),DEC2HEX(SUM(HEX2DEC(MID($B4,12,1)),0)),$A$2) //last half of the BSSID, plus vap_num. This one is for 2.4GHz band (the add of "0")//
B9 = CONCATENATE(MID($B4,9,3),DEC2HEX(SUM(HEX2DEC(MID($B4,12,1)),1)),$A$2) //last half of the BSSID, plus vap_num. This one is for 5GHz band (the add of "1")//
In sum:
B8 is your BSSID for the vap-num on 2.4GHz band for the AP whose Eth0 MAC is in B4.
B9 is your BSSID for the vap-num on 5GHz band for the AP whose Eth0 MAC is in B4.
I have yet to look at how this works for a 6GHz (or 60GHz!) radio on the Aruba platform.
==========
note:
Since we lose information in this transformation (1 hex at #7, and XOR of hex at #8 potentially mangles 1 bit of information) it may not be possible to reliably reconstruct the Eth0 MAC of the AP. However, it provides a simple list of possibilities, and a regex search comparison should yield you *likely* only one result from your infrastructure inventory list.
Hope this helps (me in the future)!
------------------------------
ryh
------------------------------
Original Message:
Sent: Apr 05, 2023 12:15 PM
From: ryh
Subject: BSSID indicator widget
Here is the way to run it from the command line using cURL (mostly for a reference for myself in the future!):
curl -k https://koopen.net/aruba_bssid.php --data "mac=00:11:22:33:44:55&num_bssid=16"
------------------------------
ryh
Original Message:
Sent: Jan 17, 2020 12:01 PM
From: the.sleeper
Subject: BSSID indicator widget
from this thread:
https://community.arubanetworks.com/t5/Controller-Based-WLANs/How-is-the-BSSID-derived-from-the-Access-Point-ethernet-MAC/tac-p/553568
The http://koopen.net/aruba_bssid.php page's certificate seems to have expired...
Any chance the widget could be reposted, or maybe just incorporated into Airwave?