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

[toe_cutter]

Aah, i understand now I guess i figured that reportit would do the math with the steppings automatically when i change the reporting period.

Anyway, it looks alot better now, theres a 17% increase as you predicted

One thing i noticed tho. I copied (:oops:) the trend analysis for the f_grd example on a update news post on a page further back.
On your screenshot of the report the negative values all have suffixes (M,k etc) but mine dont, and its only the negative values.
I checked and all values should be rounded according to the configuration.

Any ideas?

Edit: page 9, news update for v0.4.2
Edit2: thanks for all the help

[browniebraun]

It's a known bug within the rouding function. Please bear with me ...
I'm just working intensively on 0.7 where this bug no longer exists. Hopefully I can start with Beta testing soon, so that the next major release will be published this year. "Graidle" used for creating the charts also has big issues with negative values.
A solution will be in 0.7 - without Graidle .


Best regards
-Andreas-

[toe_cutter]

Aah, ok! Ill stop bugging you then until the beta, a new release is always awesome!

[apperrault]

Maybe i missed something, but i am having problems installing this plugin. I have downloaded it from Sourceforge, expanded it, put it in the plugins directory, and edited the Global.php.

I added the permissions for my user to use the utility, and i am trying to now create a Report Template, but after typing all of the information in (i am trying to generate a Disk Space report, i click save, and it clears the data from the screen, but doesn't create anything. If i go to the Cacti log i see the following:

Code: Select all

11/17/2008 01:26:21 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates ORDER BY id ASC LIMIT 0,30"
11/17/2008 01:26:21 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(reportit_templates.id) FROM reportit_templates"
11/17/2008 01:26:18 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT a.*, b.description AS template_description, c.username, b.locked FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id WHERE a.description like '%' ORDER BY id ASC LIMIT 0,30"
11/17/2008 01:26:18 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(a.id) FROM reportit_reports AS a WHERE a.description like '%'"
11/17/2008 01:26:18 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT b.id, b.description FROM reportit_reports AS a INNER JOIN reportit_templates AS b ON b.id = a.template_id"
11/17/2008 01:26:18 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT a.user_id as id, c.username FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id ORDER BY c.username"
11/17/2008 01:26:17 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates WHERE locked = 0"
11/17/2008 01:26:16 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT id, description FROM reportit_templates WHERE locked=0"
11/17/2008 01:26:16 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates WHERE locked = 0"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT a.*, b.description AS template_description, c.username, b.locked FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id WHERE a.description like '%' ORDER BY id ASC LIMIT 0,30"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(a.id) FROM reportit_reports AS a WHERE a.description like '%'"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT b.id, b.description FROM reportit_reports AS a INNER JOIN reportit_templates AS b ON b.id = a.template_id"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT a.user_id as id, c.username FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id ORDER BY c.username"
11/17/2008 01:26:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates WHERE locked = 0"
11/17/2008 01:26:06 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM reportit_templates ORDER BY id ASC LIMIT 0,30"
11/17/2008 01:26:06 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(reportit_templates.id) FROM reportit_templates" 

I have verified that there are indeed what look to be Reportit tables in the database, but other than that, i dont see anything else.

Any assistance would be greatly appreciated.

app

[browniebraun]

ReportIt requires MySQL 5.0.3 or above. If you want to use it with 4.x then you have to download a patch first, which contains all files that have to be replaced.

• patch_reportit_v061_mysql4.tar
  patch_reportit_v061_mysql4.zip

Best regards
-Andreas-

[jmb]

I'm trying to produce reports based on a data template with 40-odd data items. The report runs and gives a table with 15 1/2 of the measurand columns (the 1/2 being a truncated data item name and "NA" for value). No error messages are generated.

It looks as though this list is being truncated because the MySQL column ds_description in reportit_reports is only VARCHAR(255). SELECTing from it shows a string like item1|item2|item3|... truncated at the same point in the item name as visible in the report. Perhaps this is not the best model to store this information?

What I'd really like to do is wrap these onto multiple lines - just having my measurands across the page. Perhaps that's just a matter of layout that I could tweak in the generation code.

[bonbon]

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-

I second this request by Howie. It would be great to be able to run reports from the web interface based on the data item presets because our interfaces change often and it's very time consuming to keep them up to date by individual data items.

Even better would be able to filter the report by graph tree or by manage plugin sites & groups.

( p.s. kudos on this plugin, its very good )

[browniebraun]

I'm trying to produce reports based on a data template with 40-odd data items. The report runs and gives a table with 15 1/2 of the measurand columns (the 1/2 being a truncated data item name and "NA" for value). No error messages are generated.

It looks as though this list is being truncated because the MySQL column ds_description in reportit_reports is only VARCHAR(255). SELECTing from it shows a string like item1|item2|item3|... truncated at the same point in the item name as visible in the report. Perhaps this is not the best model to store this information?

What I'd really like to do is wrap these onto multiple lines - just having my measurands across the page. Perhaps that's just a matter of layout that I could tweak in the generation code.

Sorry for my late reply, but I was on vacation and spent some time with my family.
You're absolutely right. The string will be truncated and it isn't the best way to save that data. But I never expected a data template with so many data sources.
Currently I'm working on a solution to select the data source items separately within a report template.

Best regards
-Andreas-

[browniebraun]

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-

I second this request by Howie. It would be great to be able to run reports from the web interface based on the data item presets because our interfaces change often and it's very time consuming to keep them up to date by individual data items.

Even better would be able to filter the report by graph tree or by manage plugin sites & groups.

( p.s. kudos on this plugin, its very good )

Honestly I wanted to implement all graph policies in v0.6, but I struggled with the option "Graph Permissions (By Graph)", so that I reduced it to "By Device".
I'll check if it's possible to implement the tree permissions without getting headaches.

Best regards
-Andreas-

[MagicOneXXX]

Hi all:

I'm confused on the f_num function results. I'm trying to report on our Daily WAN activity, and in particular, how many minutes out of the day our WAN is above 95% usage. I added the measurand NOP with f_num as the formula, and ran the report for the last 1 day. The NOP reported was 240, which doesn't seem right: in a 24 hour period, there should be 288 points (24 * 60 minutes / 5 minute averages).

What's really odd is that in the same report, i'm reporting on the Duration over Threshold, and creating another measurand called "points over duration of threshold", which is DOT/100*f_num, to show the number of times the WAN went over the 95%. The PDOT ends up correctly reporting the number of points over the percentage (I can manually count them on the graph to verify), which leads me to believe that the DOT percentage is wrong as well.

Is the value incorrect, or am I missing something?

Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Linux 2.6.16.21-0.8-smp
Web Server - Apache/2.2.0 (Linux/SUSE)
PHP - 5.1.2
PHP Extensions - libxml, xml, standard, SimpleXML, SPL, session, Reflection, date, pcre, apache2handler, gd, ldap, mysql, mysqli, snmp, sockets, zlib
MySQL - 5.0.18
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins

• Thresholds (thold - v0.3.9)
  Device Tracking (mactrack - v1.1)
  Network Discovery (discovery - v0.8.3)
  Network Tools (tools - v0.2)
  PHP Network Weathermap (weathermap - v0.95b)
  Update Checker (update - v0.4)
  Host Info (hostinfo - v0.2)
  PHP Network Managing (PHP Network Managing - v0.6)
  RRD File Cleaner (RRD Cleaner - v0.31)
  Cacti-ReportIt (reportit - v0.6.1)
  Global Plugin Settings (settings - v0.4)

[browniebraun]

Hi all:

I'm confused on the f_num function results. I'm trying to report on our Daily WAN activity, and in particular, how many minutes out of the day our WAN is above 95% usage. I added the measurand NOP with f_num as the formula, and ran the report for the last 1 day. The NOP reported was 240, which doesn't seem right: in a 24 hour period, there should be 288 points (24 * 60 minutes / 5 minute averages).

What's really odd is that in the same report, i'm reporting on the Duration over Threshold, and creating another measurand called "points over duration of threshold", which is DOT/100*f_num, to show the number of times the WAN went over the 95%. The PDOT ends up correctly reporting the number of points over the percentage (I can manually count them on the graph to verify), which leads me to believe that the DOT percentage is wrong as well.

Is the value incorrect, or am I missing something?

Please keep in mind that f_num only returns the number of valid measured values. That excludes NANs which can also occur during the reporting period.
Send me a debug file (clone your report, reduce the number of data items to one, keep report id in mind and run it again in debug mode. CLI: runtime --debug <id> -> debug.txt), so that we can take a look at the interim results of the calculation process.

Best regards
-Andreas-

[MagicOneXXX]

Here is the debug file. What's interesting, is that looking at the RRDFetch, the timestamp is going up by 6 minutes, not 5. That appears to be where the mistake is happening.

I must say, this is a very nice and neat debug file. Kudos!

[browniebraun]

Here is the debug file. What's interesting, is that looking at the RRDFetch, the timestamp is going up by 6 minutes, not 5. That appears to be where the mistake is happening.

I must say, this is a very nice and neat debug file. Kudos!

It's the easiest way to exchange all needful information without screenshots.
Yep, you're right. As you know ReportIt has directly no influence to the resolution, so that the result seems to be correct.

Best regards
-Andreas-

[Heiko]

I would like to create a report for our HP ProCurve switches..
Problem seems to be that there are no seperate data templates,
I onlye the the "Interface - Traffic (bits/sc) " in the HostTemplate but not under "Data Templates".
Therefore I cant select the "Interface - Traffic (bits/sc)" when I create a new graph.

How can I get through this?
I attached a screenshot of the host template.


thx and greetings

[MagicOneXXX]

Yep, you're right. As you know ReportIt has directly no influence to the resolution, so that the result seems to be correct.

What would be causing the 6 minute intervals then?