Get a machine readable list of each AP's BSSIDs

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of James A

James A, Embassador

  • 6,510 Points 5k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Ronald Dvorak

Ronald Dvorak, Embassador

  • 45,024 Points 20k badge 2x thumb
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
Photo of James A

James A, Embassador

  • 6,510 Points 5k badge 2x thumb
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
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/
(Edited)
Photo of Ronald Dvorak

Ronald Dvorak, Embassador

  • 45,024 Points 20k badge 2x thumb
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,....