I need to create an Insight report that shows data from RQM and RTC. Specifically, I need to show the ID, Summary, Due Date, etc of Defects created when running TestScripts in RQM, where a Tested By cross server link is set up between RTC and RQM.
I assume this information is in the COMMON_SNAPSHOT.LINKS we used in BIRT (I might be wrong, never created a report for cross-server links). This table as it appears in BIRT can be seen in this screenshot:

http://img825.imageshack.us/img825/3499/birtlinkstable.jpg

But when accessing RTC data from Insight Metadata Wizard, that table is not available in COMMON_SNAPSHOT, as you can see in the next screenshot:

http://img600.imageshack.us/img600/9312/insightlinkstable.jpg

I'm not sure why that table is not appearing. Even if it were there... is that the right table to use for accessing cross-server links like the ones I need to report on? (RQM ScriptStep related to a Defect stored in RTC using cross-server links like "Tested By").

Any help would be appreciated.

Thank you!

(Re-posted here from https://jazz.net/forums/viewtopic.php?t=13803)