Thanks for all the replies and suggestions. I was hoping there would be something more simple, like SolidWorks' File>Find References which finds all upstream & downstream files which are referenced to the file in question (be they assemblies, drawings or other parts), but it would appear not.
We will getting Teamcenter sometime soon, so hopefully that'll help things!
Cheers,
Simon