We have a number of files that when opened are missing file references. For example, an assembly cannot find some or all of the parts that make it. When the assembly is opened, the missing part is suppressed and it says "file not found" in the File>Find References.

I am trying to figure out a way to tell me what assemblies have this situation. I do not want to open each assembly just to see if it is missing parts. I would like to know what files we need to correct.

We do have these files in PDM. However, because the assemblies are checked into the vault with the missing references, PDM does not recognize that the references are actually missing. A SQL query (if possible) would do also.