You can certainly do it on an individual asset; select it, right-click, then if the menu item "View Dependent Assets" is greyed out, you know it is not being used by any other assets.
As for a more general search of your whole database for unused assets, I am having trouble devising a search logic for that. Maybe a more nimble minded person will come in with something...