Greetings,
I am trying to use the square root function in SQL or WSQL advanced alerts of NPM. It doesn't accept the function. I also tried to build a custom static table of square root conversions with a five digit precision. It doesn't seem to let me build my own table either. This will be used to update a custom property which will help us determine when to send a power generator to remote locations.
It all works fine in Excel. The precision is outstanding. Now I need to add this to SolarWinds. I'm using a quadratic equation for my guestwork and the formula I have to implement will look something like this:
X = (-b - sqrt(b^2 - 4*a*c))/(2*a)
What say you, Thwack?