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.
as @davidpaper suggests it does the change on a global basis.
I have a work around.
Adding this line to each chart works but what I really need is a global setting.
5000
I have tried this but it makes no difference.