SQL query to identify which LGs were used in a test run


How can I Identify which load generators were booked/used in a named test run?


I see there  is a free text list in the field LAB_RUNS.LRN_LOAD_GENERATORS.  


Is there a table that links LAB_RUNS to LAB_HOSTS?


Is there any standard report that provides this?