All Apps and Add-ons

Dashboard 1000 results limitation

RAYK47
New Member

Hello all

I am using the below SQL query to display data from a SQL view and I cannot find out how to get around the 1000 limit. There are about 4000 rows when run in the search but always limits to 1000 in the dashboard.

| dbquery "SQL Server" limit=1000000 "select [date], [%iowait], [%util]  from dbo.vwora01cpulastmonth "  | eval new_time=strftime(date, "%Y-%m-%d %H:%M")|table new_time, %iowait, %util

Any help would be appreciated as I am pulling out what little hair i still have.

Tags (1)
0 Karma

linu1988
Champion

You are looking at one of my favorites.

Max Data on Dashbaord

Thanks

linu1988
Champion

as @davidpaper suggests it does the change on a global basis.

0 Karma

RAYK47
New Member

I have a work around.

Adding this line to each chart works but what I really need is a global setting.

5000

0 Karma

RAYK47
New Member

I have tried this but it makes no difference.

0 Karma
Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...