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.