To anyone else who'd like to know this info:
FROM [SolarWindsOrion].[dbo].[ResourceProperties] a
join SolarWindsOrion.dbo.Resources b on a.resourceid = b.resourceid
join SolarWindsOrion.dbo.Views c on b.viewid = c.viewid
where PropertyValue like 'Nodes.Custom%'