To successfully delete orphaned Sensor entries from the Database:
- Perform an all tables backup using the steps in article:
KB68723 - How to back up and restore the configuration and all tables on the Network Security Manager.
- Log in to the Manager database:
- Click the Network Security icon in the notification area, and select Stop Manager.
- Click Start, Run, type cmd, and then click OK.
- For NSM 9.1.7.75 and earlier and 9.2.x:
Type cd <$install_directory>\McAfee\Network Security Manager\MySQL\bin\ and press Enter.
- For NSM 9.1.7.77 and later and 10.x:
Type cd <$install_directory>\McAfee\Network Security Manager\MariaDB\bin and press Enter.
- Type the following command and press Enter:
mysql -u<user> -p<password> <database>
For example: mysql -uroot -proot123 lf
- Obtain the <sensor id>:
Type select name,sensor_id from iv_sensor; and press Enter.
- View the output and note the <sensor id> listed.
- Run the following commands, in order, substituting the sensor ID you obtained above:
DELETE FROM iv_vids_nid WHERE sensor_id IN (<sensor id>);
DELETE FROM iv_vids WHERE sensor_id IN (<sensor id>);
DELETE FROM iv_sensor_list_attr WHERE sensor_id IN (<sensor id>);
DELETE FROM iv_sensor_cluster WHERE mastersensor_id IN (<sensor id>);
DELETE FROM iv_sensor_cluster WHERE slavesensor_id IN (<sensor id>);
DELETE FROM iv_sensor_config WHERE sensor_id IN (<sensor id>);
DELETE FROM iv_sensor_port WHERE sensor_id IN (<sensor id>);
DELETE FROM iv_sensor_mgmt_ip WHERE sensorid IN (<sensor id>);
DELETE FROM iv_sensor_names WHERE sensor_id IN (<sensor id>);
DELETE FROM iv_sensor_card WHERE sensor_id IN (<sensor id>);
DELETE FROM iv_ssl_key WHERE sensor_id IN (<sensor id>);
DELETE FROM iv_sensor WHERE sensor_id IN <sensor id>);
- For NSM version 9.2.x or 10.x, run the additional following query:
DELETE FROM iv_intf_group WHERE sensor_id IN (<sensor id>);
