Does versions of Solarwinds Platform , 2023+, can evaluate mathematically (SUM, AVG, ...) numbers coming from custom properties (status field) using strictly SWQL requests ?
I found the issue. The answer is no, based on the status field (nvarchar datatype). I must evaluate, instead, the field RawStatus from Orion.NPM.CustomPollerStatistics which is of type real.
Yes. github.com/.../SWQL-Functions
Did you try it from the status field as asked ? Those fiels (Orion.NPM.CustomPollerStatistics.Status) contains strings and numbers for custom pollers values. If you know how to convert values stored as string, I will appreciate greatly.
SWQL doesn't have a cast function to force the data type, but you can do some tricks to make it happen such as:
Select 0+myField from someTable
^ Doing mathy things before the column name gives SWQL the expectation that we are working with numbers. You'll need to make sure your where condition does a good job of filtering so our column isn't going to end up with random strings in it, but if you can ensure that you are golden.
