Edit C:\Program Files (x86)\SolarWinds\Orion SDK\SWQL Studio\SwqlStudio.exe.config and find this piece around line 33:
<setting name="OperationTimeout" serializeAs="String">
And change the "2" to some higher value. It's in minutes. Restart SWQL Studio.
Thanks for this. Next question is how to then apply this in the web interface, as that is also timing out and as mentioned it is not possible to divide up the report into smaller chunks as the purpose of the report is to aggregate traffic over 1 month where total traffic per IP address source is over xGB.
What is the specific timeout error you are hitting? There are multiple levels of timeout between the browser, IIS, and various backend services that contribute to the report.
The NTA report is collating bandwidth consumption across a couple of defined interfaces, with a links to the IP address groups to allow per customer reporting to be performed.
Increasing the SWQL Studio timeout allowed the report data to be returned, but it is still timing out when running via the Report area of the web application, with the following response.
Message: Request timed out.
This timeout is controlled by web.config (C:\Inetpub\SolarWinds\web.config if your website is in the default location). Edit this file (make a backup copy outside the web directory first) and add a <location> element for this page. Like this:
<httpRuntime executionTimeout="600" />
That gives you a 10 minute timeout. If you need longer, increase it.
Sidebar: Can you provide the SWQL that you are running? There may be a way to optimize it.