Hello,
Recently i have began to add Customer Line to the billing module to monitor the consumption of the line.
I have then created an alerting rule to send a mail when the quota of CDR reach 75% .
So i have just selected the collection rule and selected the circuit i want and the transport email.
This is the SQL code in advanced
SELECT * FROM devices,ports,bill_ports,bills WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = bill_ports.port_id AND bill_ports.bill_id = bills.bill_id) AND (((bills.rate_95th / bills.bill_cdr)*100) && bills.bill_type = "cdr") >= 1
When i check in the bill windows, quota is clearly under the 75%, even the predicted
But this still trigger me the alert in my dashboard and send an email
Do i need to associate another condition on the rule or is it my comprehension of the billing module who is wrong ?
Thanks in advance.
William