Billing Tools Misses important data

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Run PRTG report on 1 month and results are different
2. Run billing tool for 1 month and transfered GB are different

Result: You will lose money using the billing tool as less then consumed is 
charged.

What is the expected output? What do you see instead?
I executed a PTRG report as a test for billing giving 564 GB of transfered 
data, total volume, based on SNMP 1 minute on a server example.

Then I passed the same sensor on the billing tools. The result is 522 GB 
transfered.

This can be because of this:
The PRTG reports is executed with 1 minute interval. The billing tool only 
allows 5 minutes intervals.

But actually the real issue seems to be that PRTG reports for the same data 
will include the 1 first day of the next month.

This means 11/1/2011 to 12/1/2011

The billing tool doest. It has a bug. The result in the report for the same 
date range with the billing tools is:
11/1/2011 to 11/30/2011

Its misses one day. Also, I think the billing tools is not taking hours account 
12:00 AM, etc so for allot of transfered bandwidth this is quite a big loss if 
you happen to use the billing tool.

In my test just with that amount of data and based on 1$ per GB extra you would 
lose 42 GB or 42$ by using the billing tool.

The difference between running PRTG reports and the billing tools should be the 
same. Because if you happen to send the reports to the clients they will differ 
with the billing tool.

Original issue reported on code.google.com by pydotc...@gmail.com on 24 Dec 2011 at 10:08

[GoogleCodeExporter]

The billing tool is working correctly in our tests.
If you collect the data in PRTG from 11/1/2011 to 12/1/2011, this means you 
include everything between 11/1/2011 12:00:00 am and 12/1/2011 11:59:59 pm. If 
you do the same thing for December like 12/1/2011 12:00:00 am to 1/1/2012 
11:59:59 pm you have collected the data for the 1st of December twice.

You might want to try something like this, to get a better overview over your 
data:
Open the sensor, you want to get the data from in the PRTG Ajax Web GUI. Go to 
the tab "Settings". Set "Sensor Display" > "Primary Channel" to "Traffic Out"(I 
suppose, that is the channel you are using for the billing). You won’t lose 
any data by switching the default channel. 
Now open the tab "Historic Data". You will find a button "Last Month" in the 
quick range selection you can use. Set "File Format" to "HTML web page" and the 
"Average Interval" to "24 Hours/1 Day". Now click the "Start Button". The 
created HTML-File will be directly opened in your web browser.
This way, you can see the traffic for the whole month(the last entry in the 
first box on top of the page) and for every single day(the column “Traffic 
Out (volume)” in the table below).
If you compare those values to the billing tool, you will see, that they are a 
match.(Please notice, that all values are rounded up in the billing tool, so 
1.1GB will for example be shown as 2GB)
When you are done with the test, you can change the primary channel in the 
settings back to your original value. This setting was only needed, so the 
report would show the total for the right channel.

I hope my answer was of any help for you.

Original comment by joherrm...@gmail.com on 18 Jan 2012 at 11:19

[GoogleCodeExporter]

Original comment by gerard.f...@gmail.com on 24 Apr 2012 at 10:08

• Changed state: Done