I have an SWQL query that takes 9+ minutes to run in SWQL studio, However when I try to move it to the report I keep getting invalid error. My personal belief is there is a configuration timeout setting I need to adjust somewhere, or a size configuration in EOC, but I cannot seem to find it. I opened a case with support and they suggested I bring this up in the forum.
Is anyone running large SWQL reports that hit multiple sites and minimum 4 tables? There is +- 6000 lines of SWQL including comments and ISNULL calculations.
If anyone has any idea where I can look to help solve this problem or Ideas I really would appreciate it. Right now, I am running them manually every day and moving them to a folder.
By EOC, do you mean that your making it a resource on the page? One thing I've noticed is if you don't have a sort order clearly defined you get strange errors.
Can you just run this as a scheduled report in the Web Report writer or something?
I wasn't clear. The SWQL runs in SWQL studio, it fails when taking that SWQL and creating a new report Custom->Table->Advanced Database Query (SWQL) in the EOC. The amount of tables I used for these reports and the joins I was unable to use any of the other methods. I have smaller reports that use the same Base SWQL, but for a lack of better term the larger reports have 11 modules of conditions, the smaller ones have maybe 3, as the other 8 don't apply.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.