Customer SQL ALERT query gets override every day


#1

Hey,
our Custom SQL Alert HIGH CPU Rule got overwritten everyday on the daily update check

SELECT *,AVG(processors.processor_usage) as cpu_avg FROM devices,processors WHERE devices.device_id not in (284,993) AND (devices.device_id = ? AND devices.device_id = processors.device_id) AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 HAVING AVG(processors.processor_usage) > 85

and at the morning its
Select all server they are up and running and we have over 200 pages with “false” alerts.


i think he is importing or overwritte the rule from the first page marcos.devices_up the problem is i cannot leave it empty because im not able to save it.


#2

Same problem.


#3

ok i test it its definitly the rule from the MainPage.
this rule get write in the overwrite query line.


#4

/push any update here ?