1 of 1 people found this helpful
There are multiple ways doing it, I prefer using pentaho spoon client if you are familiar with it. You can do CMDB look up and get output of all the CI's which have relations and then edit your existing spreadsheet deleting the once which have relations from the spreadsheet and then delete the remaining once from system.
You can also generate a report from BO or smart reporting and than do the same.
Please let me know if you have more questions