So, this is not original to me, and I did not note down who originally posted it, but I believe it was in response to a similar request I made, and I saved it.
What this does is create a list in CM of assets with have no dependents. Since there are no dependents, they can be safely deleted. What I have often done is sort them by author and export them to CDPs before deleting. Read carefully and note the reference to the "Asset KUID" field at the top of CM (not the column) when you are doing this:
What this is doing: the first six steps are creating a list of assets that ARE dependencies of other assets. The last three steps are basically saying OK, now give me everything that is NOT on that list.
To identify assets that have no dependents:
• Open CM on default "Installed" filter
• Select one random asset
• Hit Ctrl+A
• Right click and select "List Dependencies Recursively"
• Click anywhere in "Asset KUID" field list at top
• Hit Ctrl+A then Ctrl+C
• Close the window
• Create a new custom filter: Installed=True, AND NOT, Asset KUID
• Click "Asset KUID" field
• Hit Ctrl+V
CM now lists all assets that are not a dependency of any other assets.