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

[browniebraun]

2 nice features would be:
1) run report even if no data items are assigned to auto-add filtered new data items
when all data items are deleted, at the moment the report stops before adding new data items with an error. instead it should add the new data items even if the report is not generated
To be honest: That is not a feature - it's a bug.

2) allow auto-creation of data items for non-scheduled reports
at the moment the option to auto create data items is only available for scheduled reports. imho it would make sense to allow this also for manually run reports
Yep, I agree. Good catch!

Best regards
-Andreas-

[browniebraun]

Additional 2 qeustions regarding exporting reports...
Filename Format in settings , what should be the name of the variable to use the Report Description? i.e. <report_desc> ? And can I also use the date?
Next feature request ...
And when using Auto-Export (I havn't tested yet) what export format will be used and can it be changed ?
You can choose on of three export formats: CSV, XML or Excel2003(SML).

BR
Albundy

Best regards
-Andreas-

[brylant]

stupid me... did not set-up export format...
solved. can be removed...

Hi,

I'm trying to enable Auto Exporting (I have scheduled reporting enabled which works fine - reports are generated) but I can't get it working (I think).
The path is writeable by cacti (user that runs runtime.php)
Does exporting need Auto Archiving to be set (I don't have that set)...
Any other idea why it's not working?

Thanks,

[browniebraun]

stupid me... did not set-up export format...
solved. can be removed...

Hi,

I'm trying to enable Auto Exporting (I have scheduled reporting enabled which works fine - reports are generated) but I can't get it working (I think).
The path is writeable by cacti (user that runs runtime.php)
Does exporting need Auto Archiving to be set (I don't have that set)...
Any other idea why it's not working?

Thanks,

No, "Auto-archiving" can be disabled, so let's have a quick check-up for the default settings:

Go to "Console"->"Configurations"->"Settings"->Tab: Reports-> Section: Auto Exporting. Tick checkbox "enabled" and leave export path blank.
Edit your report template and ensure that "Export Path" is empty. Then switch to your report config and check whether "Scheduled Reporting" is enabled.
Choose the file format you want to have under "Auto Generated Exports" and keep your report ID in mind (see URL ...action=report_edit&id=1...).

Using the CLI rerun the report with: "php runtime.php <report_id> -v".
e.g.

Code: Select all

../../../php/bin/php runtime.php 1 -v

The output messages displayed at the end of the calculation process should look similar to these ones:

Code: Select all

02/04/2010 09:40:30 AM - REPORTIT NOTICE: Export folder '/proj/netops/cacti/cacti-0.8.7e/plugins/reportit/exports/1/' does not exist.
02/04/2010 09:40:30 AM - REPORTIT NOTICE: New export folder '/proj/netops/cacti/cacti-0.8.7e/plugins/reportit/exports/1/' created.
02/04/2010 09:40:30 AM - REPORTIT NOTICE: Export folder '/proj/netops/cacti/cacti-0.8.7e/plugins/reportit/exports/1/1/' does not exist.
02/04/2010 09:40:30 AM - REPORTIT NOTICE: New export folder '/proj/netops/cacti/cacti-0.8.7e/plugins/reportit/exports/1/1/' created.
02/04/2010 09:40:30 AM - PLUGIN: Poller[0] REPORTIT STATS: ID:1 Time:1.1 Reports:1  Emails:0  Exports:1

So the report has been exported to /reportit/exports/1/1/ (/reportit/exports/<template_id>/<report_id>/).

Code: Select all

-rw-rw---- 1 cacti cacti 32826 Feb  4 09:40 2010-02-03_2010-02-03.xml

Best regards
-Andreas-

[andy.hester]

I tried several things and just couldn't seem to get the CSV report to omit the time range items that show up between the data source and the values.

I edited /lib-int/funct_export.php like so:

at line 144, I removed 'for($i = 1; $i < 8; $i++)'

and I commented lines 168-173.

Now my report for interface bandwidth utilization lists the interface and then the values. There is still a time range in the report header section.

-Andy

[brylant]

Small patch that will set maxValue to "maximum Value" defined for each data source if snmp retrieved ifSpeed == 0. I have lots of logical interfaces that return 0 ifSpeed - that makes my reports unreadable. I wanted to set "maximum Value" for data source maunally but that was not working with reportit (as snmp ifSpeed was always reported as 0). The patch will look at "maximum Value" for each data source if snmp ifSpeed = 0.

In lib_int/funct_runtime.php update code at line 45

Code: Select all

        $sql = "SELECT d.rrd_maximum as maxRRD, c.field_value as maxValue, a.*
                        FROM reportit_data_items as a
                        LEFT JOIN data_local as b
                        ON (b.id=a.id)
                        LEFT JOIN host_snmp_cache as c
                        on (c.host_id=b.host_id AND
                        c.snmp_index=b.snmp_index AND
                        c.snmp_query_id=b.snmp_query_id AND
                        c.field_name='ifSpeed')
                        LEFT JOIN data_template_rrd as d
                        on (d.local_data_id=a.id AND
                        d.data_source_name LIKE 'traffic_in')
                        WHERE a.report_id = $report_id
                        ORDER BY a.id";

and in runtime.php add this at line 437

Code: Select all

               $maxRRDValue            = $report_definitions['data_items'][$i]['maxRRD'];

and update this in line 627

Code: Select all

        //----- Update variables and create calculating parameters -----^M
        if($maxValue !== NULL) {^M
            if($maxValue > 0 & $maxValue < 4294967295)
                $variables['maxValue'] = $maxValue;
            elseif($maxValue == 4294967295 & $maxHighValue !== Null)
                $variables['maxValue'] = $maxHighValue*1000000;
            elseif($maxValue == 0 & $maxRRDValue != 0)
                $variables['maxValue'] = $maxRRDValue;
            else^M
                $variables['maxValue'] = $maxValue;^M
        }else{^M
            $variables['maxValue'] = $maximum;^M
        }^M

Works for me...

[drh]

When (temporarily) disabling the 'Scheduled Reporting' in the 'Admistration' section of a report, the fields below it are cleared and set to the defaults.
Enabling it back does not bring the previous settings back.
Is this a bug/feature?

I'd prefer to see my previous settings remembered.

PS. This plugin realy needs its own forum.
I went thru the whole thread (duh! ) which took me some serious time.

PPS. Great plugin BTW. I do want to see some serious number rounding feature apart from those scientific ones. Why is the report export able to round on two digits after the decimal, but the report itself not?

[browniebraun]

When (temporarily) disabling the 'Scheduled Reporting' in the 'Admistration' section of a report, the fields below it are cleared and set to the defaults.
Enabling it back does not bring the previous settings back.
Is this a bug/feature?

I'd prefer to see my previous settings remembered.

PS. This plugin realy needs its own forum.
I went thru the whole thread (duh! ) which took me some serious time.

PPS. Great plugin BTW. I do want to see some serious number rounding feature apart from those scientific ones. Why is the report export able to round on two digits after the decimal, but the report itself not?

No, it is not a bug. I never thought about that. No problem, I can change it. At the moment I'm still working on the new layout of 0.8.0

PS: You're absolutely right. More than 650 replies in one single topic.
That is too large.

PPS: I will see what I can do to make it more user friendly.


Best regards
-Andreas-

[jumbo]

Hello,
Big thanks for the plugin works great for me (although spend like 10 hours reinstaling whole Cacti on debian with Plugin Architecture etc.) and another 10 hours reading this thread. I have couple questions:


Can somebody tell me how can I add more then 25 data items in a row into the report (using the "Add" button). For some reason the setting for changing "number of rows in ReportIT data items" is nowhere to be found.

Its kind of manual intensive to add 5000 data items into one report.....

Thanks,
jumbo

[browniebraun]

Hi Jumbo!

Click on tab "graphs" and then on tab "settings" in the right upper corner.
Scroll down to the section "REPORTIT General Settings" and increase the value for "Rows Per Page".

That's all.


Best regards
-Andreas-

[White Horse]

Tx a lot brylant you sloved my problems. In my case i need that reportit takes maxRRDvalue always and not just when "ifspeed =0" so for this i just paste-ed yours modification and and updated code on line 627.

Code: Select all

 //----- Update variables and create calculating parameters ----- 
        //if($maxValue !== NULL) { 
           // if($maxValue > 0 & $maxValue < 4294967295) 
                //$variables['maxValue'] = $maxValue; 
            //elseif($maxValue == 4294967295 & $maxHighValue !== Null) 
               // $variables['maxValue'] = $maxHighValue*1000000; 
            //elseif($maxValue == 0 & $maxRRDValue != 0) 
                $variables['maxValue'] = $maxRRDValue; 
            //else 
                //$variables['maxValue'] = $maxValue; 
        //}else{ 
            //$variables['maxValue'] = $maximum; 
        //} 

[matej_v]

Hello

Is it currently possible to include multiple time ranges in one report?

I'd like to make a report that would show total data transferred over an interface for the previous six months, but grouped by month, something like:

Code: Select all

                 Oct  Nov  Dec  Jan  Feb  Mar
Data source 1    xGB  yGB  zGB  ...
Data source 2    ...

Some wizardry with measurands perhaps?

[Roke22]

When i create a variable with a static value i see that is create a registry in reportit_variables and reportit_rvars but when i edit this variable for change the value it only make changes in reportit_variables.

When i execute the report it takes the values from reportit_rvars and is not up to date so i have to delete the variable and create new one with the new value.

Is a bug? there is a way to force a update the reportit_rvars table?

Best Regards.

[browniebraun]

When i create a variable with a static value i see that is create a registry in reportit_variables and reportit_rvars but when i edit this variable for change the value it only make changes in reportit_variables.

When i execute the report it takes the values from reportit_rvars and is not up to date so i have to delete the variable and create new one with the new value.

Is a bug? there is a way to force a update the reportit_rvars table?

Best Regards.

Sounds like a bug. I will have to check that. Could you open a ticket under http://sourceforge.net/tracker/?func=add&group_id=201406&atid=977435, please? Looking to the number bugs and patches I will try to release a new minor release 0.7.2 at the end of this month. For all people waiting for the next major release: ReportIt 0.8.0 will published after the release of Cacti 0.8.8, because it is not compatible to 0.8.7x any longer. At the moment it is still in development. I'm really sorry for that, but my job is getting me down at the moment.

Best regards
-Andreas-

[istein001]

Hi,

Has anyone else had their maxValue variable under measurands disappear? It was there before but since upgrading I've noticed it no longer is available?

Anyone else seen this...or more importantly know how to fix it?

Did you change the maximum value of your data template?The variable "maxValue" will only be available if "maximum" is neither empty nor zero.
Are there error messages listed in the Cacti log?

Best regards
-Andreas-

Seeing this same issue... upgraded to 0.7.1, maxValue is no longer there. I've checked and unchecked Maximum for the data template, as well as tried it with a value and without. Anyone figure this one out?