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

[jeancarlos84]

sorry for my english.
I am sending images to try clarify...


The difference is that the report shows the value in "float" but I need to round the value

[sodium]

[...] "f_xth(95)" means sort all values as a sequence and throw the highest 5% away. In that case ReportIt returns "12" as billable utilization. So we get 288000 (12*8*300*10)

On last question, would it be possible to calculate the same value as can be done with the 95 Percentile HRULE (HRULE: |95:bits:0:max:2|)
To my knowledge is this the same as the reportit f_xth(95) but then on the in+out traffic together.

[browniebraun]

To be honest,
I do not know how the HRULE works. Any ideas?


Best regards
-Andreas-

[sodium]

To be honest,
I do not know how the HRULE works. Any ideas?

I think it sorts all data (in + out) and then does the nth(95) magic. I've got lots of graphs with the 95% HRULE... and according my superficial research it uses the above aproach
so using your own example the first 5 numbers are in-traffic and the last 5 are out-traffic.... HTH

[browniebraun]

Ok,
I also read in the manual about the features of the nth percentile stuff, but
in ReportIt v0.6.1 I do not see a solution how to make a calculation in the same way Cacti does.
Therefore it would be necessary to extend the calculation process.

Best regards
-Andreas-

[thebull]

Hi All,

I tried installing Manage plugin as intructed on the forum but no success.

My configuration

Cacti Version 0.8.7b
Plugin Architecture 2.1
Poller Type CMD.php
Server Info Windows NT 5.2
Web Server Microsoft-IIS/6.0
PHP Version 5.2.6
PHP Extensions bcmath, calendar, com_dotnet, ctype, session, filter, ftp, hash, iconv, json, odbc, pcre, Reflection, date, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, ISAPI, mysql, snmp, sockets
MySQL Version 5.0.67-community-nt
RRDTool Version 1.2.15


Need assistance, am i missing anything.

[browniebraun]

I'm not the author of the Manage Plugin.

Best regards
-Andreas-

[Howie]

I have just installed ReportIt 0.6.1, and found that when I add data items, I get a HUGE list of data sources, with 6 or more of the same item, all with the same checkbox name.

Adding a 'DISTINCT' to the query on line 170 of cc_items.php has improved this, although the 'paging' is still wrong. Unfortunately DISTINCT doesn't affect the COUNT() sql function, so $total_rows is still incorrect.

By the way, it would be great to be able to just press 'just add ALL of these' even if they span many pages - or do something like the scheduled 'auto-data sources' option must already do.

[browniebraun]

I have just installed ReportIt 0.6.1, and found that when I add data items, I get a HUGE list of data sources, with 6 or more of the same item, all with the same checkbox name.

Adding a 'DISTINCT' to the query on line 170 of cc_items.php has improved this, although the 'paging' is still wrong. Unfortunately DISTINCT doesn't affect the COUNT() sql function, so $total_rows is still incorrect.

By the way, it would be great to be able to just press 'just add ALL of these' even if they span many pages - or do something like the scheduled 'auto-data sources' option must already do.

Hi Howie!

Oops, I thought there would be a bug fix for it in 0.6.1, but I've just seen that it is only included in the SVN (Rev. 93).
Please replace (additionally to line 170) line 228:

from

Code: Select all

$total_rows = db_fetch_cell(str_replace('a.local_data_id AS id, a.name_cache','COUNT(a.local_data_id)',$sql));

to

Code: Select all

$total_rows = db_fetch_cell(str_replace('DISTINCT a.local_data_id AS id, a.name_cache','COUNT(DISTINCT a.local_data_id)',$sql));

From my point of view a 'just add ALL of these' - button will invite users to create reports without thinking about what they are doing.
Please note that a single CPU Core will come under stress during the calculation process.

Best regards
-Andreas-

[Heiko]

Hello,
I have generated reports for the last 3 months, and we had the most traffic in september, but the reports say the july had most.
Are we doing something wrong with the settings?
In the attached pic you can see the graph and this are the numbers the reports give us:

Code: Select all

july:
1        3.22 T	1.29 T
2 	51.73 G	224.97 G
Sum	3.27 T	1.51 T

Code: Select all

august:
1       1.46 T	0.52 T
2       5.14 G	34.56 G
Sum	1.46 T	0.55 T

Code: Select all

september:
1      2.35 T	0.85 T
1      15.23 G	65.38 G
Sum	2.37 T	0.91 T

we really depent on these numbers, is there a way to fix this?

MY template has these settings:

Consolidation function MAX

measurand: Bytes/s
Rounding: Binary SI-Prefixes(Base 1024)
Formula: f_sum*step



thx and greetings


Heiko

[browniebraun]

Heiko,

it seems to me that your graph is based on AVERAGE values. Take a look at your graph source.
If I'm right I would suggest to display the max values like a shadow behind the average values. That's the way be use to make it in our company.

Best regards
-Andreas-

[Heiko]

should I use the MAX function and the 1000 Base for generating reports?
My boss ist killing me because we have different results.
We just wanna have the total traffic for one month.


I changed the display optione, but dont think that gave me more info.

[browniebraun]

I would use CF Average and Base1000 to calculate the amount of data.
Do not forget that ReportIt has a debug mode at the CLI.

Best regards
-Andreas-

[toe_cutter]

Hi again!

Im not quite sure i understand the function f_grd. Isnt it supposed to show by how much a graph increased or decreased during the reported period?

Im graphing CPU's from our switches and the highest value from the f_grd function so far is +0.18 during a 2day report period (i'll be making reports over the 28day period, but that only gives a highest of +0.02), what i think is percent at least. But the graphs themselves can have increased from 1% load to 25% or more during the period.

Is it possible to have ReportIt to draw this f_grd line onto the generated graph, for visualization?
Im trying to get the amount the CPU increased/decreased over time since we changed a configuration item for multicast networking.

And yes, you may call me dumb :]

[browniebraun]

Hi again!

Im not quite sure i understand the function f_grd. Isnt it supposed to show by how much a graph increased or decreased during the reported period?

The functions returns the change (increase or decrease) per step (the distance between 2 measured values).

Im graphing CPU's from our switches and the highest value from the f_grd function so far is +0.18 during a 2day report period (i'll be making reports over the 28day period, but that only gives a highest of +0.02), what i think is percent at least. But the graphs themselves can have increased from 1% load to 25% or more during the period.

To get the estimated increase you've to multiply it with the number measured values. Change your formula as follows: "f_grd*f_num"
Regarding your graph you should get an estimated increase of ~17% for a 2day report period.

Is it possible to have ReportIt to draw this f_grd line onto the generated graph, for visualization?

Sorry, but I think I've to pass this question to Gandalf. He's the master of graphs. (As far as I know RRDtool is able to calculate and to draw it on its own.)

Im trying to get the amount the CPU increased/decreased over time since we changed a configuration item for multicast networking.

See above.

And yes, you may call me dumb :]

No, the issue is the missing documentation. But I restarted to write online docs and I pore over the development of ReportIt 0.7.

Best regards
-Andreas-