Set a range of values on Universal Poller, or discard values that are out of range

jorge.dargence

One of my Universal Pollers will sometimes get a very high number from the devices it is polling. It could be a bug on the SNMP stack of the device, but in the meantime, it causes our graphs to become invisible when one of these high values is recorded, as the Y Axis gets very tall and the low numbers disappear. We have to export the data to XLS, remove the outlying data point, and graph again.

Is there a way in the Poller transform or formula to set a max value? I know what my values usually are. For example, it will be between 0 and 50, but if the Transform comes up with 3600233 (3 million), then it should ignore that value and not record it. Maybe transform it into a 0.

Is the only solution to map all values to a table? That would require a LOT of data to be entered and without ranges available, it's not worth my time.

mesverrum

If you are using a custom chart resource a relatively quick and dirty solution would be to write a where condition that only includes values between 0-50. Won't help with the native widgets or perfstack though. Can't think of anything that would solve those short of something like a trigger on the table inserts or a recurring sql job but that could have some performance considerations and I hate to leave sneaky things like that in the database in case I forget to explain it to the next admin and it bites them years down the road.