Unable to remove Site from the UI

[#1]

Version

This solution applies to all Carbon Black versions.

Issue

From Administration -> Settings -> Sites, there is no method to delete a "Site" from the UI.

Solution

The Site object needs to be removed manually by updating the Postgres database on the Carbon Black server. To do this perform the following:

1. 1. Collect the <id> of the relevant site that needs to be removed:
   

   psql -d cb -p 5002 -c "select * from sensor_sites;"

2. Remove the Site by the ID above:
   

   psql -d cb -p 5002 -c "delete from sensor_sites where id=<id>;"

There is no need to restart anything. Refresh the page in the UI and confirm the Site no longer exists.  Engineering is aware this functionality does not exist within the UI.