Apply NCM 9.2.2a patch 1 to NCM and Report Advisor.
Once the patch is installed go to the following directory:
/opt/smarts-ncm/tools/DeviceDeletion/
source /etc/voyence.conf
and run the following script:
perl DeviceDeletionDaemon.pl > DeviceDeletionDaemon.log &
Once the device is deleted correctly, run the adhoc report in Report Advisor, the devices should no longer exist.