It is impossible to remove a configuration item by design. If you need to remove it from the MDB, you have to check the relation to each table with the configuration item you want to remove and delete it under your own risk. CA Technologies Support cannot assist the remove a configuration item.
It is impossible to remove a configuration item by design.
If you have unnecessary configuration items, you need to change the status from active to inactive with the configuration item.
So, the MDB will continue to store the configuration item in an inactive state.
Also, when the CA Service Desk Manager is migrated like from R11.x to R12.x, the configuration item for which status is 'Inactive' will not be removed by the migration process. So, when a configuration item is created, the data will remain in the MDB.
CA Service Desk Manager does not allow you to remove data for auditing reasons also. This is also meant to preserve database referential integrity.
The configuration item's data will be stored in several tables in the MDB. So, if you would like to remove the data of a specific configuration item from the MDB, you have to check the relationship between tables with the configuration item you want to remove and delete it at your own risk.
CA Technologies Support cannot assist with the removal of a configuration item and we strongly recommend NOT removing it.