I worked with support and got the following query
declare @Resource AS nvarchar (25)
set @Resource = 'ENTER ORGANIZATIONAL UNIT HERE'
select
pf.Name as 'Organization group structure'
,i.Name as 'Organizational View'
,r.Name as 'Resource'
,sm.ResourceGuid as 'Guid'
from ScopeMembership sm
join vItem i on i.Guid = sm.ScopeCollectionGuid
join vResourceEx r on r.Guid = sm.ResourceGuid
join FolderBaseFolder f on f.FolderGuid = sm.ScopeCollectionGuid
AND f.ParentFolderGuid NOT IN ('D0E33520-C160-11D2-8612-00104B74A9DF', 'FEC994AE-1787-44C2-B5EC-E94D210838C9', '42441BEE-BC0F-469C-8A66-06288CB1B8AF', 'D8C07867-F25B-41AF-9C6A-82C1086B2179')
join Item pf on pf.Guid = f.ParentFolderGuid
where pf.Name like '%' + @Resource + '%'
Order by pf.name, i.name, r.Name, f.Depth