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

[browniebraun]

Mmmm.... I've directly no explanation for that, but the output shows that zlib and gd are not available.

Best regards
-Andreas-

[spayne]

is there a way to have a report only show certain results? for example, i want a traffic report to only show interfaces that had an average of 1MB for the day, all others can be left out of the report.

[Heiko]

Helllo,
i found some more time to pla with the reportit plugin and got the same problem i had some weeks ago.
I created 2 reports, one works fine and the other gives me this messages:

Code: Select all

#   	 REPORTIT WARNING: No values available. Report[11] Data Item[606]
# REPORTIT WARNING: No values available. Report[11] Data Item[607]
# REPORTIT WARNING: No values available. Report[11] Data Item[706]
# REPORTIT WARNING: No values available. Report[11] Data Item[707]
# REPORTIT WARNING: No values available. Report[11] Data Item[708]

Im running the latest cacti and latest reportit.
There are some graphs that dont have data, yet.but many do have data,
but it still reports No values.

I just need a report that says how much traffic an interface did the last month. The report that is working seems to be allright.
My measurand is f_sum*step,
Unit=Bit/s
Rounding is Decimal (base 1000).
The Consolidation function says "MAX"

Am I doing something wrong here?


thx

[browniebraun]

is there a way to have a report only show certain results? for example, i want a traffic report to only show interfaces that had an average of 1MB for the day, all others can be left out of the report.

Currently not. I think it'll be a little bit difficult to extend the filter settings without loosing clearness. Maybe it would be an idea to implement sth. like that in an extra pop up window. Any suggestions?

Best regards
-Andreas-

[browniebraun]

Helllo,
i found some more time to pla with the reportit plugin and got the same problem i had some weeks ago.
I created 2 reports, one works fine and the other gives me this messages:

Code: Select all

#   	 REPORTIT WARNING: No values available. Report[11] Data Item[606]
# REPORTIT WARNING: No values available. Report[11] Data Item[607]
# REPORTIT WARNING: No values available. Report[11] Data Item[706]
# REPORTIT WARNING: No values available. Report[11] Data Item[707]
# REPORTIT WARNING: No values available. Report[11] Data Item[708]

Im running the latest cacti and latest reportit.
There are some graphs that dont have data, yet.but many do have data,
but it still reports No values.

I just need a report that says how much traffic an interface did the last month. The report that is working seems to be allright.
My measurand is f_sum*step,
Unit=Bit/s
Rounding is Decimal (base 1000).
The Consolidation function says "MAX"

Am I doing something wrong here?


thx

Heiko,

your description also contains the explanation why you get these messages: There are 5 interfaces which does not contain anything else than NaN's within the defined reporting period. (And it's not so easy to calculate with them. ) Click on the data item IDs then you'll see the interface descriptions. They will correspond to your empty graphs.

Best regards
-Andreas-

[Heiko]

Hello,
today the report worked, I didnt changed anything.

Is my "Formula" correct to get the complete traffic for the given timeperiod?

cheers

[browniebraun]

Hello,
today the report worked, I didnt changed anything.

Is my "Formula" correct to get the complete traffic for the given timeperiod?

cheers

Only if you change the unit to "Bytes".
Generally interface counters return a value in Bytes - not Bits,
so the values returned by RRDtool are Bytes/s. Multiplied with the step in seconds you'll get Bytes.
If want "Bits" then you have to multiply it with 8.

Unit= "Bits"
Formula = "f_sum*step*8"

Best regards
-Andreas-

[thomasw]

Hello,

today I was asked to resend a report, which was sent out as csv via scheduled e-mail.
the archive - directory holds only xml files and I`m wondering howto transform the xml to csv (the same format the e-mail was sent out). I cannot find any xslt which does the job.
Has anybody experience in transforming the archive xml format to the csv format which is used by reportit?

any help is highly welcome,

thanks in advance,

tom

[browniebraun]

Hi Thomas,

currently I'm working on the extension of the export funtionalities. At first I added the possibility to export a report directly out of the report view to CSV, XML, but I didn't upload it to the SVN yet. (It also takes into account all the filter settings and will allow to export to MS2003 XML (via SpreadsheetML).
The second part will be a kind of an export manager to create files with more than one report. After that v0.6.2 will be released.

Best regards
-Andreas-

[contegixcraig]

Upon installation I found a small bug when dealing with database names containing a hyphen in them. The following patch fixes that:

Code: Select all

diff -Naur reportit.ORIG/setup.php reportit/setup.php
--- reportit.ORIG/setup.php	2008-07-31 19:26:00.000000000 -0500
+++ reportit/setup.php	2008-07-31 19:25:00.000000000 -0500
@@ -426,7 +426,7 @@
 	global $config, $database_default;
 	include_once($config["library_path"] . "/database.php");
 
-	$sql		= "show tables from " . $database_default;
+	$sql		= "show tables from `" . $database_default . "`";
 	$result		= db_fetch_assoc($sql) or die (mysql_error());
 	$tables		= array();
 	$sql		= array();
diff -Naur reportit.ORIG/uninstall.php reportit/uninstall.php
--- reportit.ORIG/uninstall.php	2008-07-31 19:26:08.000000000 -0500
+++ reportit/uninstall.php	2008-07-31 19:26:22.000000000 -0500
@@ -31,7 +31,7 @@
 
 global $config, $database_default;
 
-$sql        = "show tables from " . $database_default;
+$sql        = "show tables from `" . $database_default . "`";
 $result     = db_fetch_assoc($sql) or die (mysql_error());
 $tables     = array();
 $sql        = array();

Cheers,
-craig

[xefil]

Last but not least I added a new function called "f_grd". I wrote it last Saturday evening while I was thinking about a solution for making a trend analysis. It returns the gradient of an estimated straight line by using the method of linear regression. To give you an impression I will add the pictures below. For a better explanation of the results I've drawn 2 straight lines by hand.

Best regards
-Andreas-

Hello!

It's REALLY a GREAT work!
I've tested you example.
One question:
Why I obtain values like: EIC [Bits] -8818120.50 instead of -8M (?)
I've set Rounding as Decimal SI_Prefizes (Base 1000) like other examples.
BTW a documentation explaning it would be great. This thread has helped a lot, of course

Last ReportIt and Cacti version

Simon

[browniebraun]

Hi Simon!

I just reconstructed that issue and it's unfortunately a bug, which I've to fix in the next minor release.
BTW next release will also contain a new feature to export and import report templates.

BTW a documentation explaning it would be great.

I know

This thread has helped a lot, of course

IMO it will be more and more confusing with every new page. It took me a while to find the example you've choosen.

Best regards
-Andreas-

[xefil]

Thank's a lot!

Vielen Dank, suuuper Arbeit

[Jem]

Hi to all,

I tried to install the ReportIt plugin which is something I find great, but I see an error in my logs:

Code: Select all

CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SHOW TABLE STATUS WHERE `Name` LIKE 'reportit_tmp_%' AND (UNIX_TIMESTAMP(`Update_time`) + 300) <= UNIX_TIMESTAMP()"

Has someone the same problem (I made a search in the forum but it doesn't seem so) ?

I think, seeing this message that a command on my system is missing or that the path to access it is wrong...

Where can I change it ?

Best regards,

[browniebraun]

ReportIt v0.6.x requires MySQL 5.0 or higher.
If you're using MySQL 4 you have to patch ReportIt before using it.

The patch is also available under Sourceforge.net

Best regards
-Andreas-