Have you seen an issue with this in 12.3 or greater? When I use this query in a widget in 12.3 or greater it does not display correctly. At the bottom right corner, it does not display the total number of nodes and doesn't show the muted objects. in the newer versions did the functionality for a Union all break? Below is a screenshot of the bottom part of the widget
Should be expecting 125 objects (thats what gets returned in SWQL Studio) instead of 1-0
So interestingly I get an error on both 12.2 and 12.4 Systems which is:
"There was an error processing the request"
Yet both servers respond if I run the query directly in SWQL Studio
did you put an "Order By" at the end? i had to ensure i put that at the end of the query in the widget in order to not get the same error you talked about.
i just threw this in there
Order By [Days Left]
So if there's more than the row limit it displays the widget correctly? Meaning that it shows the total number in the bottom right-hand corner? I noticed that if you go over the limit for the number of rows than it doesn't display correctly. e.g: by default the row limit is 5 if I left it at 5 and there were 10 nodes in maintenance mode the widget would display like the screenshot in my previous comment. But if I change the max rows to 11 than the widget displays correctly. I also noticed that my muted nodes do not show up
Can you show a screenshot of the lower part of the widget like the one i provided?
Ah yes I am able to replicate that issue. When I have less than 5 (As an example) and the "Number of Rows per Page" set to 5 then it works fine. If I then unmanaged some additional devices I get the following issue:
But if I increase the page count to 10 it works fine. EDIT: I noticed this is also showing up in the original query from mesverrum but not in all SWQL Query's I have on my system so it's potentially a code issue rather than a SW Engine issue.
can you test it in the 12.1 environment you spoke of? I have a co-worker who said that this was not the case prior to 12.3 I suspect starting in 12.3 it doesn't like the union all parts of the query, because when you do each query individually in separate widgets the widget behaves as expected.
That was a customer environment that I no longer have access to, I will test it at my next opportunity - If anyone out there can validate if this is working in NPM12.1 we would appreciate it.
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.