Skip to content

Lite utilization query fails with CROSS JOIN when server properties missing #533

@erikdarlingdata

Description

@erikdarlingdata

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions