Bug
The Lite FinOps utilization query uses CROSS JOIN server_info s to join server properties. When v_server_properties has no data for a server, the CTE returns 0 rows and the CROSS JOIN eliminates all utilization data — resulting in an empty tab even when CPU/memory data exists.
Impact
Utilization tab shows nothing for servers that have utilization data but no server properties row.
Root cause
CROSS JOIN with an empty CTE produces 0 rows, killing the entire result set.
Fix
Change CROSS JOIN server_info s to LEFT JOIN server_info s ON true in LocalDataService.FinOps.cs.
Bug
The Lite FinOps utilization query uses
CROSS JOIN server_info sto join server properties. Whenv_server_propertieshas no data for a server, the CTE returns 0 rows and the CROSS JOIN eliminates all utilization data — resulting in an empty tab even when CPU/memory data exists.Impact
Utilization tab shows nothing for servers that have utilization data but no server properties row.
Root cause
CROSS JOINwith an empty CTE produces 0 rows, killing the entire result set.Fix
Change
CROSS JOIN server_info stoLEFT JOIN server_info s ON trueinLocalDataService.FinOps.cs.