ExtremeWireless (Identifi)

  • 1.  Get a machine readable list of each AP's BSSIDs

    Posted 06-16-2016 10:12
    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?


  • 2.  RE: Get a machine readable list of each AP's BSSIDs

    Posted 06-16-2016 10:54
    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


  • 3.  RE: Get a machine readable list of each AP's BSSIDs

    Posted 06-16-2016 10:54
    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]


  • 4.  RE: Get a machine readable list of each AP's BSSIDs

    Posted 06-16-2016 10:54
    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,....