FCP Media Management

I'm working on a production of 40 episodes split amongst 4 editshare workspaces on a network. We have media divided over various different locations which is quickly becoming a challenge to manage. The long and the short of it is whether I can find a way to see if media is being used by a particular FCP project?

In the same way that you can track back to a source clip through 'reveal in finder' through Final cut. Is there a way, or a piece of software that allows you to track in the opposite direction and see if a piece of media is being referenced by a particular FCP project?