Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Report plugin ''ReportIt" - v0.6.1 (released 05/29/08)
Goto page Previous  1, 2, 3 ... 25, 26, 27, 28, 29, 30  Next
 
Post new topic   Reply to topic    Cacti Forum Index -> Plugin General
Author Message
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
PostPosted: Fri Jun 27, 2008 1:25 pm    Post subject: Reply with quote
Mmmm.... I've directly no explanation for that, but the output shows that zlib and gd are not available.

Best regards
-Andreas-
Back to top
spayne



Joined: 12 Apr 2006
Posts: 3
PostPosted: Fri Jun 27, 2008 2:43 pm    Post subject: filter results Reply with quote
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.
Back to top
Heiko



Joined: 23 Apr 2008
Posts: 25
PostPosted: Mon Jun 30, 2008 10:08 am    Post subject: Reply with quote
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:
#       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
Back to top
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
PostPosted: Mon Jun 30, 2008 12:19 pm    Post subject: Re: filter results Reply with quote
spayne wrote:
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-
Back to top
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
PostPosted: Mon Jun 30, 2008 12:30 pm    Post subject: Reply with quote
Heiko wrote:
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:
#       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-
Back to top
Heiko



Joined: 23 Apr 2008
Posts: 25
PostPosted: Tue Jul 01, 2008 1:54 am    Post subject: Reply with quote
Hello,
today the report worked, I didnt changed anything.

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

cheers
Back to top
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
PostPosted: Tue Jul 01, 2008 3:17 am    Post subject: Reply with quote
Heiko wrote:
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-
Back to top
thomasw



Joined: 10 Nov 2005
Posts: 25
PostPosted: Tue Jul 08, 2008 3:17 am    Post subject: reportit 0.60: archive xml to csv Reply with quote
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
Back to top
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
PostPosted: Tue Jul 08, 2008 5:18 am    Post subject: Reply with quote
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-
Back to top
contegixcraig



Joined: 31 Jul 2008
Posts: 1
PostPosted: Thu Jul 31, 2008 7:35 pm    Post subject: Bug with database names containing a hyphen Reply with quote
Upon installation I found a small bug when dealing with database names containing a hyphen in them. The following patch fixes that:

Code:
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
Back to top
xefil
Cacti User


Joined: 20 Jun 2006
Posts: 64
Location: Italy
PostPosted: Tue Aug 19, 2008 9:20 am    Post subject: Reply with quote
browniebraun wrote:

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

example.jpg
 Description:
 Filesize:  62.5 KB
 Viewed:  954 Time(s)

example.jpg
Back to top
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
PostPosted: Tue Aug 19, 2008 12:51 pm    Post subject: Reply with quote
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.

Quote:
BTW a documentation explaning it would be great.

I know
Quote:
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-
Back to top
xefil
Cacti User


Joined: 20 Jun 2006
Posts: 64
Location: Italy
PostPosted: Wed Aug 20, 2008 3:24 am    Post subject: Reply with quote
Thank's a lot!

Vielen Dank, suuuper Arbeit
Back to top
Jem



Joined: 12 Apr 2005
Posts: 22
PostPosted: Wed Aug 20, 2008 4:56 am    Post subject: Reply with quote
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:
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,
Back to top
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
PostPosted: Wed Aug 20, 2008 8:01 am    Post subject: Reply with quote
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-
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Plugin General All times are GMT - 5 Hours
Goto page Previous  1, 2, 3 ... 25, 26, 27, 28, 29, 30  Next
Page 26 of 30

 



Powered by phpBB © 2001, 2005 phpBB Group