Smarts NCM/Voyence: How can I completely remove a device from NCM/Voyence?; Device has been deleted but still appears in NCM application and database

Products

• VMware Smart Assurance

Issue/Introduction

Symptoms:


This article explains how to complete the following tasks in your product environment:

• How to completely remove a device from Smarts Network Configuration Manager (Smarts NCM)/Voyence
• How to remove a previously deleted device from Smarts NCM/Voyence

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

• Device has been deleted but still appears in Smarts NCM application and database
• After apparently deleting a device from Smarts 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

Environment

VMware Smart Assurance - NCM

Resolution

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

1. 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

 

2. Review the output of the above select commands and verify whether the device is present in the database (see Note statement).
3. 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:
   1. In the Smarts NCM application, go to the following:

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

2. Confirm that all the devices are present on the right hand side panel.
3. Select the device with the desired "device_idx" (in the following Note statement example, this ID is 1104), and click on the Unmanage button.
4. Select the same device entry and click on Remove button.
5. 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 JTI-L1-4507R-1 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  '%JTI-L1-4507R-1%';

device_name     | device_idx

----------------+------------
JTI-L1-4507R-1  |       1104
(1 row)