Database Clean Up

Hello all,

I'm new to ManageEngine and have recently started working on the Asset Management module. I was in a hurry to import our Asset Management information (From an old Service Desk and several Excel sheets) before I fully understood the relationships and the impact our AD information would have.

Since then I have learnt how to correctly implement the Asset Management and I have cleaned up our AD details for the correct 'Sites' and 'Departments'. We now have a large amount of 'Sites' 'Departments' including things like 'Product Types' that need to be removed. Some have been removed with ease but others are saying they are in use by another module.

I have seen several posts regarding this solved by the use of some SQL but we're using the On Demand service. I have tried manually looking for relationships across the modules and sometimes I manage to get lucky and can remove previous attributes that were stuck.

Is there a better way to clean up ManageEngine even if its just a simple way to identify the relationships and objects that still use the attributes I'm trying to remove?

Many thanks for your time and I hope someone can help.

Kind Regards,

Chris