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:
# 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.