Device has been deleted but still appears in NCM application and database

Products

• VMware Smart Assurance

Issue/Introduction

One or more of the following conditions may exist in the environment:

• Device has been deleted but still appears in NCM application and database
• After apparently deleting a device from NCM, device still appears in the NCM application and is still present in NCM Database
• Some user access profiles for users configured to allow specific device and/or group access still contain the name of a device which has been deleted from NCM
• Unreferenced device name cannot be removed from the user access profile in Smarts NCM and is causing problems defining new access rules for the affected user accounts
• Cannot completely delete a device completely from Smarts NCM/Voyence

Need to be able to remove this device completely. 

Environment

NCM 10.1.X

Resolution

If you encounter this issue in your environment, do the following:

• On the system with the NCM database, run the following commands in sequence:

su - pgdba
psql voyencedb voyence
select count(*),device_status from cm_device group by device_status;
select device_name,device_idx from cm_device where device_name like  '%<deviceName>%';
\q

• Review the output of the above select commands and verify whether the device is present in the database (see Note statement).
• If the device is still present in the database as confirmed in the select command output, or if you still cannot delete the device completely from Smarts NCM application, do the following:
  • In the Smarts NCM application, go to the following:

Tools > System Administraton > Global > Access > Device Servers > {Device Server Name} > Devices

• • Confirm that all the devices are present on the right hand side panel.
  • Select the device with the desired "device_idx" (in the following Note statement example, this ID is 1104), and click on the Unmanage button.
  • Select the same device entry and click on Remove button.
  • Confirm that the device is completely removed from Smarts NCM application and database.

Additional Information

The following is an example of the output where the device called deviceName is still present in the database:

select count(*),device_status from cm_device group by device_status;

voyencedb=# select count(*),device_status from cm_device group by device_status;
count  |         device_status
-------+--------------------------------
     1 | enum.deviceStatus.unclassified
   154 | enum.deviceStatus.operational
     3 | enum.deviceStatus.unconfigured
 
select device_name,device_idx from cm_device where device_name like  '%<deviceName>%';
voyencedb=# select device_name,device_idx from cm_device where device_name like  '%deviceName%';
device_name     | device_idx
----------------+------------
deviceName  |       1104
(1 row)