1 of 1 people found this helpful
I am not sure if the following will work as I didn't test it myself:
* Create a query that shows the soft deleted devices.
* Place this query as a shortcut under the "Administration" tab for example.
* Double click on the query to run it and then select all of the records.
* Right click and then select Remove.
* Try importing the devices one more time.
Thank you for the reply. I thought of that also but I run into an error when displaying a query with soft deletion. I posted another question on that. Query with soft deletion returns and error "Object reference not set..."
In that case, I would jump into the SQL server and create a query that shows the soft deleted items under the table cf_config_item and then delete them.
Make sure to backup your database prior
I tried deleting items from cf_config_item but there is a reference constraint.
"The DELETE statement conflicted with the REFERENCE constraint "fk$_Workstat$Paren$642258BF". The conflict occurred in database "#####", table "dbo.usr_workstation", column 'cf_guid'."
I was able to delete cf_config_item after delete all assets. Seems like it is all or nothing.
I ran the following
Then I deleted all data from a few additional tables. I do have a backup before these deletions but so far it looks ok. Thanks for the help!
Glad you managed to solve it