We'd like to update the notes under each AP to show the connected with name & port. We can bulk extract this via the LLDP tables on our procurve switches but need to bulk upload this onto existing APs in Airwave.
We'd find this extemely helpful during troubleshooting.
Does anyone know how this can be done via the Airwave CLI or maybe the API?
If you add the procurve switches to airwave as devices, it will read the mac address table and match them to the wired port on an AP and show the procurve switch and port as an upstream device and upstream port:
That would be the ideal solution, yes.
I would do that if we had licenses to burn.
We have several thousand switches and our Airwave is running close to capacity on licenses and performance so adding the switches is not really an option at this stage.
I'd like to be able to bulk import data in to airwave, specifically if there was some way to take the output of:
sho ap lldp info neighbors
and import that into airwave so that it appears in the "notes" field,
especially when a WAP has gone off the air for an unknown reason,
i'd be absolutely ecstatic, as it would make fault-finding soooo much easier!
(We've got a LOT of WAPs, so doing this manually one by one isn't an option, we'd not complete that task before the next hardware refresh is due!)
I'm happy with any level of massaging of the data from sho ap lldp that i need to do to accomplish this.
Converting to cli commands, dbc commands, api calls?
Anything, as long as there's a way to do this.
Glen,Sorry for the delay (getting busy with end of the semester/holiday break coming up). I’m not sure how familiar you are with the Airwave CLI or database queries (PSQL), but updating the note is relatively easy. Each monitored device in Airwave has an associated “id” in the database – you’ll see this ID in the URL of the GUI -> ex: https://airwave /ap_monitoring?id=516Caution: I would always make backups before you attempt manipulating the database. I’ve made use of the commands several times without issue – but I’m an amateur and always cautious.
TAC also may be able to help you accomplish this. I had contacted them last year concerning if it was possible to import a CSV contain AP Mac Addresses with Jack #s. They did help me bulk update all the notes - but only to a specific value. They said they could look into building a script to accomplish what I desired - I wanted to take them up on the offer but got busy with other projects. These instructions aren't the best but I'm leaving for a few weeks tomorrow and wanted to give you something to play around with - just be careful as you might end up accidentally overwriting previous notes.
Updating Specific AP Notes based on ID Field:
If I wanted to update the notes of my AP named “Farmhouse” [ID=516] to “Switch7 – Port Gi7/2 – XXX” via the CLI, I would do the following:
Retrieving ID of every AP in Airwave:
Creating the Update Commands (No-Script) – (Probably Not the Best)
There are several ways to do this. A simpler one without needing the AP.ID would be to do a ‘update ap set notes = ‘Switch7 – Port Gi7/2 – XXX’ where ap.lan_mac=’XX:XX:XX:XX:XX:XX’.
At Aruba, we believe that the most dynamic customer experiences happen at the Edge. Our mission is to deliver innovative solutions that harness data at the Edge to drive powerful business outcomes.
© Copyright 2020 Hewlett Packard Enterprise Development LPAll Rights Reserved.