Yeah, its rare for this to happen.

You can just look in the table and remove the largest entry, though ;)

I'll put a tool to remove crazy spikes on the list!

Adam.

Sent from BlueMail

On 25 Jul 2016, 14:02, at 14:02, Tom Laermans tom.laermans@powersource.cx wrote:

Cameron,

There are no spike removal tools for the traffic accounting system - they don't use the RRD files so the pl and php scripts will not have any effect. The only way is basically to remove the erroneous reading from the mysql table.

We haven't heard of a lot of these happening though, as far as I know...

Tom

On 07/25/2016 05:10 AM, Cameron Murray wrote:

...

Guys,

Just following this one up to see if anyone can provide some

assistance?

...

Regards,

*Cameron Murray* Senior Communications Manager

How am I doing? Please click here http://www.techpath.com.au/contact-us/feedback/to rate my work.

*P*1300 033 300 *F* 07 3809 3999 *E* cameron@techpath.com.au mailto:cameron@techpath.com.au

*www.techpath.com.au* http://www.techpath.com.au

Unit 2/55 Tradelink Rd, Hillcrest QLD 4118

Note: This message may contain privileged and confidential

information

...

that is the property of the intended recipient. The information

herein

...

is intended only for use of the addressee. If you are not the

intended

...

recipient, then you are requested to return e-mail to TechPath Pty

Ltd

...

and destroy any copies made. Copying or disseminating any of this message is prohibited. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of

...

TechPath Pty Ltd.

*From:*Cameron Murray *Sent:* Friday, 22 July 2016 11:04 AM *To:* Observium Network Observation System observium@observium.org *Subject:* Traffic accounting Spike Removal

Morning All,

We’ve been trying to remove the spike from a Traffic accounting graph

...

with no success. We have sun through the pl and php scripts however the spike remains:

None of the interfaces this accounts for show the spike.

Regards,

*Cameron Murray* Senior Communications Manager

How am I doing? Please click here http://www.techpath.com.au/contact-us/feedback/to rate my work.

*P*1300 033 300 *F* 07 3809 3999 *E* cameron@techpath.com.au mailto:cameron@techpath.com.au

*www.techpath.com.au* http://www.techpath.com.au

Unit 2/55 Tradelink Rd, Hillcrest QLD 4118

Note: This message may contain privileged and confidential

information

...

that is the property of the intended recipient. The information

herein

...

is intended only for use of the addressee. If you are not the

intended

...

recipient, then you are requested to return e-mail to TechPath Pty

Ltd

...

and destroy any copies made. Copying or disseminating any of this message is prohibited. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of

...

TechPath Pty Ltd.

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

---

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

Hi Cameron,

You can try:

SELECT * FROM bill_data WHERE bill_id = x ORDER BY delta DESC LIMIT 10;

Regards,

-- Eduardo Schoedler

2016-07-25 18:27 GMT-03:00 Cameron Murray cameron@techpath.com.au:

Thanks Tom & Adam. Will go digging for it.

To save the hunt which table should I start at?

Regards,

*Cameron Murray* Senior Communications Manager

How am I doing? Please click here http://www.techpath.com.au/contact-us/feedback/ to rate my work.

*P* 1300 033 300 *F* 07 3809 3999 *E* cameron@techpath.com.au

*www.techpath.com.au* http://www.techpath.com.au.

*From:* observium [mailto:observium-bounces@observium.org] *On Behalf Of *Adam Armstrong *Sent:* Monday, 25 July 2016 11:22 PM *To:* Observium Network Observation System observium@observium.org *Subject:* Re: [Observium] Traffic accounting Spike Removal

Yeah, its rare for this to happen.

You can just look in the table and remove the largest entry, though ;)

I'll put a tool to remove crazy spikes on the list!

Adam.

Sent from BlueMail http://www.bluemail.me/r

On 25 Jul 2016, at 14:02, Tom Laermans tom.laermans@powersource.cx wrote:

Cameron,

There are no spike removal tools for the traffic accounting system - they don't use the RRD files so the pl and php scripts will not have any effect. The only way is basically to remove the erroneous reading from the mysql table.

We haven't heard of a lot of these happening though, as far as I know...

Tom

On 07/25/2016 05:10 AM, Cameron Murray wrote:

Guys,

Just following this one up to see if anyone can provide some assistance?

Regards,

*Cameron Murray* Senior Communications Manager

How am I doing? Please click here http://www.techpath.com.au/contact-us/feedback/ to rate my work.

*P* 1300 033 300 *F* 07 3809 3999 *E* cameron@techpath.com.au

*www.techpath.com.au http://www.techpath.com.au*

*From:* Cameron Murray *Sent:* Friday, 22 July 2016 11:04 AM *To:* Observium Network Observation System observium@observium.org observium@observium.org *Subject:* Traffic accounting Spike Removal

Morning All,

We’ve been trying to remove the spike from a Traffic accounting graph with no success. We have sun through the pl and php scripts however the spike remains:

None of the interfaces this accounts for show the spike.

Regards,

*Cameron Murray* Senior Communications Manager

How am I doing? Please click here http://www.techpath.com.au/contact-us/feedback/ to rate my work.

*P* 1300 033 300 *F* 07 3809 3999 *E* cameron@techpath.com.au

*www.techpath.com.au http://www.techpath.com.au*

Thanks for the help guys – Worked a treat

Regards,

Cameron Murray Senior Communications Manager How am I doing? Please click herehttp://www.techpath.com.au/contact-us/feedback/ to rate my work. [cid:image001.png@01D1E71B.BBA5E600]

P 1300 033 300 F 07 3809 3999 E cameron@techpath.com.aumailto:cameron@techpath.com.au www.techpath.com.auhttp://www.techpath.com.au

Unit 2/55 Tradelink Rd, Hillcrest QLD 4118 [cid:image002.png@01D1E71B.BBA5E600]

[cid:image003.png@01D1E71B.BBA5E600]

[cid:image004.png@01D1E71B.BBA5E600]

Note: This message may contain privileged and confidential information that is the property of the intended recipient. The information herein is intended only for use of the addressee. If you are not the intended recipient, then you are requested to return e-mail to TechPath Pty Ltd and destroy any copies made. Copying or disseminating any of this message is prohibited. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of TechPath Pty Ltd. From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: Tuesday, 26 July 2016 7:42 AM To: observium@observium.org Subject: Re: [Observium] Traffic accounting Spike Removal

phpmyadmin -> bill_data -> order by delta -> delete top row(s) with loltastic values.

adam.

Sent from Mailbirdhttp://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm_campaign=sent-from-mailbird

On 25/07/2016 22:36:26, Eduardo Schoedler listas@esds.com.br wrote: Hi Cameron,

You can try:

SELECT * FROM bill_data WHERE bill_id = x ORDER BY delta DESC LIMIT 10;

Regards,

-- Eduardo Schoedler

2016-07-25 18:27 GMT-03:00 Cameron Murray <cameron@techpath.com.aumailto:cameron@techpath.com.au>: Thanks Tom & Adam. Will go digging for it.

To save the hunt which table should I start at?

Regards,

Cameron Murray Senior Communications Manager How am I doing? Please click herehttp://www.techpath.com.au/contact-us/feedback/ to rate my work. [cid:image001.png@01D1E70F.3AA1E830]

P 1300 033 300 F 07 3809 3999 E cameron@techpath.com.aumailto:cameron@techpath.com.au www.techpath.com.auhttp://www.techpath.com.au. From: observium [mailto:observium-bounces@observium.orgmailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: Monday, 25 July 2016 11:22 PM To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Subject: Re: [Observium] Traffic accounting Spike Removal

Yeah, its rare for this to happen.

You can just look in the table and remove the largest entry, though ;)

I'll put a tool to remove crazy spikes on the list!

Adam.

Sent from BlueMailhttp://www.bluemail.me/r On 25 Jul 2016, at 14:02, Tom Laermans <tom.laermans@powersource.cxmailto:tom.laermans@powersource.cx> wrote: Cameron,

There are no spike removal tools for the traffic accounting system - they don't use the RRD files so the pl and php scripts will not have any effect. The only way is basically to remove the erroneous reading from the mysql table.

We haven't heard of a lot of these happening though, as far as I know...

Tom On 07/25/2016 05:10 AM, Cameron Murray wrote: Guys,

Just following this one up to see if anyone can provide some assistance?

Regards,

Cameron Murray Senior Communications Manager How am I doing? Please click herehttp://www.techpath.com.au/contact-us/feedback/ to rate my work.

P 1300 033 300 F 07 3809 3999 E cameron@techpath.com.aumailto:cameron@techpath.com.au www.techpath.com.auhttp://www.techpath.com.au

From: Cameron Murray Sent: Friday, 22 July 2016 11:04 AM To: Observium Network Observation System observium@observium.orgmailto:observium@observium.org Subject: Traffic accounting Spike Removal

Morning All,

We’ve been trying to remove the spike from a Traffic accounting graph with no success. We have sun through the pl and php scripts however the spike remains:

None of the interfaces this accounts for show the spike.

Regards,

Cameron Murray Senior Communications Manager How am I doing? Please click herehttp://www.techpath.com.au/contact-us/feedback/ to rate my work.

P 1300 033 300 F 07 3809 3999 E cameron@techpath.com.aumailto:cameron@techpath.com.au www.techpath.com.auhttp://www.techpath.com.au _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium