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

[hendry]

Thank you very much, but I don't get it yet. What I need is a report showing the same value as in the graph 95 percentile (the red line). It looks like with the example above I cannot get this. Am I doing something wrong here?

[browniebraun]

Another little improvement :

in cc_view_mod.php line 366 replace

Code: Select all

header("Location: ../../graph.php?local_graph_id=$local_graph_id&rra_id=all");

with this

Code: Select all

$data = get_prepared_report_data($_GET['id'],'','','view');
$report_data	= $data['report_data'];
$start = strtotime($report_data['start_date']);
$end = strtotime($report_data['end_date']);
header("Location: ../../graph.php?action=zoom&local_graph_id=$local_graph_id&rra_id=0&graph_start=$start&graph_end=$end");

And you can view the graph related to your report for the right period in the reports tab

Many thanks for your private message. I've just checked your suggestions and IMO it would make sense to integrate them into one of the next minor releases.

Best regards
-Andreas-

[Howie]

BB, thanks for you work on this plugin - it looks very flexible!

I think I must be missing something obvious though. I would like to make a report showing which of my interfaces have a non-zero error rate. I created a Report Template, added the Interface - Errors/Discards data template, and added a measurand called Error Rate. BUT, I don't see where I link this variable to the rra data sources (there are four in this data source). So I get a single column in my report with some value in it, but I don't know which ds names it is using to get the data. Where is the missing link?

Also, is there a way to say "all data source on this host" or "all data source (of this template)" when creating a report (like you would for graph permissions)? As it stands, I need to add a new device to the report when I add it to Cacti, don't I?

Finally, is it possible to filter the resulting report without using the CSV file? I am really only interested in lines with non-zero results. I can do this with a little perl of course...

[browniebraun]

Hi Howie,

be sure that you've disabled the option called "Separate". If it's disabled you should see 4 columns in your report after you've reruned it again. If you try to add a second measurand you should also see the interim results of the first one for all available data sources (screenshot).

>As it stands, I need to add a new device to the report when I add it to Cacti, don't I?
When you are using v0.4.0 you'll have to add it manually. But if you're interested in the next version then take a look at the latest SVN release. It's the inofficial v0.5.1. One of it's new features is called "Auto-Generating RRD List".

>Finally, is it possible to filter the resulting report without using the CSV file? I am really only interested in lines with non-zero results. I can do this with a little perl of course...
At the moment it isn't possible, sorry!

Best regards
-Andreas-

[Howie]

be sure that you've disabled the option called "Separate". If it's disabled you should see 4 columns in your report after you've reruned it again. If you try to add a second measurand you should also see the interim results of the first one for all available data sources (screenshot).

Bingo. Thanks for the quick reply. That's just what I wanted.

>Finally, is it possible to filter the resulting report without using the CSV file? I am really only interested in lines with non-zero results. I can do this with a little perl of course...
At the moment it isn't possible, sorry!

That's cool. It already saves so much time over manually looking through all the graphs.

One other thing though - now that I have the seperate columns, I though that I could sort by the error rate, and the top part of the report would be the info I needed. But when I click on those little arrows, the URL changes to show a sort=error_out__1, but the report doesn't sort. Is that a partial feature, or should it work?

[browniebraun]

>But when I click on those little arrows, the URL changes to show a sort=error_out__1, but the report doesn't sort. Is that a partial feature, or should it work?

You're absolutely right. It's a little bug.
Unbelievable that nobody had posted it before.

[dejavu]

Dear all, i ve installed the reportit and all works fine, the only issue that im having is that i dont have any "Data Items" and i don t know how to create them
Can you please help me?

Regards

[Bazou]

Hello,

Is it now possible to generate Availability reports?

Is the "sorting bug" planned to be resolved soon?

Is it possible to schedule an export?

Where is cc_view_mod.php?

Code: Select all

# slocate -u
# slocate cc_view_mod.php

Nothing...:/


Thanks for your help, and many thanks for this usefull plugin


Gilles

[browniebraun]

Dear all, i ve installed the reportit and all works fine, the only issue that im having is that i dont have any "Data Items" and i don t know how to create them
Can you please help me?

Regards

Mmmh, no response from the reportit users?

Edit your report configuration (under Management/Reports) and click on "Create Data Items" displayed in the top right corner.
Then you should get a list of available data items.

Best regards
-Andreas-

[browniebraun]

Hi Gilles!

>Is it now possible to generate Availability reports?
No. But how do you define "Availability"?

>Is the "sorting bug" planned to be resolved soon?
Based on the number of bugfixes and little improvements I'll try to publish a minor release 0.4.2 at the end of this week.

>Is it possible to schedule an export?
Since v0.3.0!

>Where is cc_view_mod.php?
???

Best regards
-Andreas-

[Bazou]

Hi Andreas,

Thank you for your answers!

As there is an availability value in the "devices" pages, I tought there is a way to calculate this info. But i don't know how

All right for your minor release, it's perfect!

For the file I'm looking for, it's the same malicorne modify in a previous post:

Another little improvement :

in cc_view_mod.php line 366 replace

Code: Select all

header("Location: ../../graph.php?local_graph_id=$local_graph_id&rra_id=all");

with this

Code: Select all

$data = get_prepared_report_data($_GET['id'],'','','view');
$report_data	= $data['report_data'];
$start = strtotime($report_data['start_date']);
$end = strtotime($report_data['end_date']);
header("Location: ../../graph.php?action=zoom&local_graph_id=$local_graph_id&rra_id=0&graph_start=$start&graph_end=$end");

And you can view the graph related to your report for the right period in the reports tab

For the schedule point, i saw that we can schedule a report, i.e the values are refreshed in the "reports" tab. But is it possible to generate the csv file somewhere on the hosting machine automatically? If this is the case, how? :p

Thanks!

Gilles

[Howie]

One other thing in reportit that confused me... I enabled the daily scheduled runs for my reports, but they don't run. In the options for the report it says "Be sure that the correct crontab is running." What is the correct crontab? The README doesn't mention crontab at all...

[browniebraun]

One other thing in reportit that confused me... I enabled the daily scheduled runs for my reports, but they don't run. In the options for the report it says "Be sure that the correct crontab is running." What is the correct crontab? The README doesn't mention crontab at all...

Hi Howie,
to my degradation I've to admit that documentation is my Achilles tendon.
But I started writing an admin guide last weekend.
For scheduled reporting you should take a look at these postings:

for Unix/Linux
for Windows

Best regards
-Andreas-

[Howie]

Hi Howie,
to my degradation I've to admit that documentation is my Achilles tendon.

I know how you feel. I only started writing good (IMHO, anyway) documentation when I got tired of answering the same questions again and again

Thanks for the pointer - that looks like what I need.

[TheWitness]

You guys are not alone