Note that a part does not 'know' where it is used, only assemblies 'know' which parts they contain.
A database or PDM system can potentially show 'used by/in'.
What you seek may be possible via script, perhaps an iterative approach for each part, and check all sub-assemblies for the part. Beyond my limited script skills. I just wanted to get a clearer definition of what you want.