Insight avg cpu by facet not showing all hosts

When doing an Insight avg cpu query by facet, some of the hosts are not showing up.
SELECT average(cpuPercent) as cpu_pct from SystemSample facet hostname since 1 week ago
If i filter by one of the missing hosts, the record shows
SELECT average(cpuPercent) as cpu_pct from SystemSample facet hostname since 1 week ago where hostname = 'foo'
Would be nice if all the host data retrieved

Hi @andrew.t.simpson - You could be running into the Insights query defaults, try adding a LIMIT clause to expand the number of rows returned.

1 Like

Thanks! That appears to be the issue.
LIMIT to see more rows, yikes.
Over a 1000 and no go without convoluted filtering.

1 Like