Version
All
Issue
Unnamed sensors appear in Sensors page.
Symptoms
Sensors show '0.0.0.0' for Sensor Version. Computer Name, Computer Domain Name and OS Version columns will be also be empty.
Cause
Issue is caused by a single sensor attempting to register incorrectly. This is a known issue scheduled to be addressed in a future release, tracked with escalation 'CB-14089'.
Solution
Workaround is to manually delete the invalid sensor registrations from the Postgres database. To do this we need to determine the 'os_environment_id' for the affected sensors:
1) With the affected sensors showing in the Sensor page, select Actions-> Export Visible to CSV, this will create a 'hosts.csv' file.
2) Locate the 'os_environment_id' column in the host.csv file.
3) Run following command:
psql -d cb -p 5002 -c "DELETE FROM sensor_registrations WHERE os_environment_id = <os_environment_id>;"
Example:
| psql -d cb -p 5002 -c "DELETE FROM sensor_registrations WHERE os_environment_id = 56;" |
