I've created a report using the following custom SQL;
SELECT Name,MemoryConfigured,ProcessorCount,TotalStorageSize,h.HostName,n.Customer,n.nodeID
FROM SolarWindsOrion.dbo.VIM_VirtualMachines v
INNER JOIN SolarwindsOrion.dbo.VIM_Hosts h on v.HostID = h.HostID
INNER JOIN SolarwindsOrion.dbo.Nodes n on v.NodeID = n.NodeID
This pulls the exact values I need, but when I add the report as a resource in the web interface, I'm unable to filter by the "Customer" node custom property. That value is actually represented by the n.Customer value in the SQL. I'm obviously missing something as none of the filters I've tried work.
