Tenant Statistics

curl http://localhost:8082/api/v1/tenants/stats \
  -H "Authorization: Bearer $TOKEN"

{
  "statusCounts": [
    ["ACTIVE", 42],
    ["PROVISIONING", 3],
    ["SUSPENDED", 5],
    ["PENDING", 1],
    ["FAILED", 2]
  ],
  "tierCounts": [
    ["FREE", 20],
    ["STARTER", 10],
    ["PROFESSIONAL", 12],
    ["ENTERPRISE", 5]
  ],
  "totalStorageAllocatedGb": 15000
}

@Transactional(readOnly = true)
public TenantStatsResponse getStats() {
    List<Object[]> statusCounts = tenantRepository.countByStatus();
    List<Object[]> tierCounts = tenantRepository.countByTier();
    Long totalStorage = tenantRepository.getTotalStorageAllocated();
 
    return TenantStatsResponse.builder()
            .statusCounts(statusCounts)
            .tierCounts(tierCounts)
            .totalStorageAllocatedGb(totalStorage != null ? totalStorage : 0L)
            .build();
}