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

Hi

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?

Thanks.