Any solution here? I know its a conflict between the account limitation and the SQL query, but I'm at a loss as to where its actually checking or how/why.
IIRC rob.hock had mentioned in a thread once that running custom SQL reports required the user to have administrator rights due to a risk of allowing non-admins to run SQL against the DB. (or something like that)
Have you tried an account with Administrator rights, that still has the account limitation?
Also, with the web report writer, I haven't tested using CTEs yet. Have you attempted this query using subqueries instead? (I know it's not as effective from the SQL perspective, but it's worth the troubleshooting step)
Just some ideas. Hope it get's you in the right direction.
Loop1 Systems: SolarWinds Training and Professional Services
There are two solutions.
- If you create "Web Report" with same SQL query, you can pass over the limitation problem.
- If you write query with CTE (not include "WHERE" and some pattern that I couldn't exactly work out) on Report Writer, you can pass over the limitation problem.
So I choose the number 1 and the problem is over.