Monitoring, Management & Location Tracking

Bulk Deleting buildings which do not have Floor plans on VisualRF

To delete all buildings which do not have floors
1. From VisualRF > Setup page set the Enable VisualRf Engine to ‘No’
2. From cli of AMP:
# root
# dbc “delete from visualrf.building a where a.id not in (select b.building_id from visualrf.floor b);”
Will delete all the buildings with no floors.
3. Start VisualRF by enabaling the VisualRF engine from VisualRF > Setup page.

Note : This only applies for AMP version 7.2 or higher.
Note : This will delete all building with no floors, if you do not want this way, please check with support.

Version history
Revision #:
1 of 1
Last update:
‎06-25-2014 01:38 PM
Updated by:
 
Labels (1)
Contributors
Search Airheads
Showing results for 
Search instead for 
Did you mean: 
Is this a frequent problem?

Request an official Aruba knowledge base article to be written by our experts.