Report plugin ''ReportIt" - v0.7.5a (released 23/12/11)

[merlinthemagic]

Hey,

Just in case some one have the same issue im posting this.
I was trying to get reportit to give me usage on a monthly basis in GB/Month, so we can see who eats up all the bandwidth in a building. All our customers are attached to induvidual ports on Cisco 35XX equipment. But all devices that will give Traffic stats can be used.
This is of course based on the monthly consolidating to 2/hour samples.

Took me forever to get the result right, since months have different days and reportit cant grab sums only values.

Setup a report template:

Consolidation function - Average

Add measurand:

Unit - GB/Month

Rounding - Base(1000)

Calculation Formula - ((f_num/12)*0.0000864)*f_avg

Setup Report:

Sliding Time Frame - Last Month

Down To The Present Day - Uncheck

Create Data Items:

Add all data sources you need in the report (only "Traffic - In/Out - Bytes with Total Bandwidth" sources).

Could just be me thats an idiot, but this should help fellow idiots out there.

Regards,

Martin Madsen

[browniebraun]

Hey,
I'm really delighted to see that there is somebody who prefers to share his realization with the other community members.
Although I'm the author of ReportIt I also need a sheet of paper and a ballpen to find a calculation formula.
(But without doing and checking this I would say "f_num*step/1000000000*f_avg" should result the same)

Best regards
-Andreas-

[merlinthemagic]

yep, that yields the same result, wasent sure what step was. ut it works just the same.

MM

[Adelante]

"f_num*step/1000000000*f_avg"

Thats awesome for working out GB/month, but how do you work out MB/month ?

I've tried

"f_num*step/1000000*f_avg"

But this gives me a wierd result:

on 773MB incoming and 1.96GB outgoing, it displays it as:

0.75 k incoming
1.90 k outgoing

How do I set it to display in MB correctly?

[browniebraun]

Your formula looks right.
"k" stands for 10E3, so ReportIt shows 0.75 * 10E3 * MB/month.
With reference to the "correct" values of your graph you've to use base 10, because I assume that you use base 2 (1024) instead.
That's the reason why the values are a little bit too low.


Best regards
-Andreas-

[Adelante]

Hi Andreas,

I'm not to worried about the values being a bit lower than the graph value, what I want to know is if I can make the value show as 773 and 1950 rather than the 10E3 value?

[browniebraun]

You can turn the rouding off, but then you will see all decimal places too.
Maybe I should expand this feature in v0.6.0 .

Any suggestions?


Best regards
-Andreas-

[apperrault]

browniebraun etc,
Is it possible to use ReportIt to generate reports on Drive space usage? If so, what variables and measurands would i use?

I need to generate a report every week for two of teams of users that exports Drive Letter, Drive Size, and Drive Usage in some sort of tabular format.

Any assistance would be greatly apprecaited.

Thanks

app

[browniebraun]

Generally you can create reports about everything that will be displayed under "Data Template" during the creation of a new report template.
e.g. "Host MIB - Hard Drive Space".
But keep in mind that a report template can always be based on one data template.

Till now I've never monitored my Hard Disk usage, but it should be possible.
(I've only created reports about Memory Usage, Interface Traffic, CPU Usage, Logged In Users, but not Hard Disk usage.)

Anybody here who has done that and who wants to share his experiences?

Best regards
-Andreas-

[browniebraun]

Ok, I've enabled the SNMP service on my Windows PC to test it for you.
Maybe this could give you an idea how to make it. I used the "Host MIB - Hard Drive Space" data template.
For the last two measurands I set rounding to "Base 1000" instead of "Base 1024".

Okay, now I've to go to bed. Here we've half past one in the morning.

Best regards
-Andreas-

[zorrosam]

Hi all,

i have 2 questions,

1) any news of 95percentile function? is ok now?

2) i have a report locked ( ** in process **). what can i do for unlock it?

thanks!

[browniebraun]

Hi Sam!

Normally it should work faultlessly. I've removed some correction factors in the main calculation process of v0.5, because they have been errors in reasoning. But there are different ways how to calculate the 95 percentitle.
Unfortunately you've to edit the MySQL dataset manually to reset the report (table 'reportit_reports' column 'in_process' should be '0').
The reports hangs in that status if the calculation has been interrupted or crashed.

Best regards
-Andreas-

[tbaror]

Hi,

i am trying to set report configuration and i get this error

any idea
Thx

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 79 bytes) in C:\Inetpub\wwwroot\cacti\plugins\reportit\lib_int\funct_html.php on line 276

[browniebraun]

This will happen if the drop down menu should have too many values. The structure of Cacti expects to work with an array that contains all the values. So you should reconsider your definition of this variable. If you really want to show your users so many possibilities to choose you have to increase your memory for PHP (see PHP.ini ->"memory_limit"). But keep in mind that the browser also has to interpret the HTML code - and this takes time!
IMO you should not configure a drop down menu with more than 5000 values.

Best regards
-Andreas-

[tbaror]

Hi,

you where right its where the Variable that caused the pb.

Thanks