Header Only - DO NOT REMOVE - Extreme Networks

Get a machine readable list of each AP's BSSIDs


I know I can get the BSSIDs for each AP in the AP inventory report, but is there an easy way to get a CSV or equivalent?

3 replies

Userlevel 7
Hey James,

try that,,,
- export the AP inventory report
- open/import it in Excel
- delete the columns that you don't need - I assume you are only looking only for APname and BSSID
- save as csv

In that case the csv looks like that in notepad...
name,mac
_AP3825e,D8:84:66:0C:DE:B0
_Home_Demo,20:B3:99:BC:72:30
_Home_Demo,20:B3:99:BC:72:31
_Home_Fritz,D8:84:66:02:DD:90
_Home_Ron,D8:84:66:02:DF:E0
_Home_Ron,D8:84:66:02:DF:E1

Cheers,
Ron
Ron wrote:

Hey James,

try that,,,
- export the AP inventory report
- open/import it in Excel
- delete the columns that you don't need - I assume you are only looking only for APname and BSSID
- save as csv

In that case the csv looks like that in notepad...
name,mac
_AP3825e,D8:84:66:0C:DE:B0
_Home_Demo,20:B3:99:BC:72:30
_Home_Demo,20:B3:99:BC:72:31
_Home_Fritz,D8:84:66:02:DD:90
_Home_Ron,D8:84:66:02:DF:E0
_Home_Ron,D8:84:66:02:DF:E1

Cheers,
Ron

Hi Ron, that's perfect. I never noticed the XML export at the bottom before, nor knew that Excel would do something sensible with it.

Now I can turn that into a sed file and pipe the output of the OS X scan command through it to get a human-readable output:
/System/Library/PrivateFrameworks/Apple80211.framework/Resources/airport -s|sed -Ef ap-bssid.sed|sort -rnk3[/code]ap-bssid.sed is based on the CSV and has lines like (don't forget to lowercase the MAC address):
s/(20:b3:99:92:a6:30)/\1 AP name/
[/code]
Userlevel 7
Ron wrote:

Hey James,

try that,,,
- export the AP inventory report
- open/import it in Excel
- delete the columns that you don't need - I assume you are only looking only for APname and BSSID
- save as csv

In that case the csv looks like that in notepad...
name,mac
_AP3825e,D8:84:66:0C:DE:B0
_Home_Demo,20:B3:99:BC:72:30
_Home_Demo,20:B3:99:BC:72:31
_Home_Fritz,D8:84:66:02:DD:90
_Home_Ron,D8:84:66:02:DF:E0
_Home_Ron,D8:84:66:02:DF:E1

Cheers,
Ron

I use the import in Excel a lot as it's a quick method to check for differences in AP config parameters
i.e. are all APs set to min. basic rate 6 or are there some still set to 1,....

Reply