Resource Report - Extract all resources and their owner

Resource Report - Extract all resources and their owner

Hoping someone can help me form an SQL query for a resource report. I need to extract all resources of a certain 'resource type' and need a column with the owner of the resource also.

I managed adapt an existing default report to get the resource but am unsure of the method to add their owner.

Thanks in advance

                  New to ADSelfService Plus?