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

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

TFC wrote:
TFC wrote:I installed the plugin. But plugin and presentaiton are different i think.
First, when I try to create new template, two sub-choices are shown Create anew variable and create a new measurand.
There is three field to fill max and min values and default value (what are they?) Another one is Stepping (what is it?)
Lets go to create a new measurand. Some fields here. Calculation formula, unit, etc. (I have no idea. Becouse I am newbie about this plugin)
Anyway i achieve to create template for just test and seeing how is this plugin. Go to report config. and select add (Test selected)
I click to next button. Report config shoes some field again: Name and etc. But there is a strange raw here called subhead. but thereis no checkbox or field after subhead.
I dont know. Somethnig strange but what are they :)
Can anybody hep me about that?
P.S: There is no sql file in plugin tar files. is it missing ot this is normal?
any comment about that?
Take a look at http://forums.cacti.net/viewtopic.php?p=96605&highlight=#96605 for an example how to define a measurand.
Under the following link you will find an example for using variables:http://forums.cacti.net/viewtopic.php?p=102967&highlight=#102967

The rest is mostly simular to the PPT.
ReportIt generates its tables automatically, so that a sql file is not necessary.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
User avatar
TFC
Cacti Pro User
Posts: 739
Joined: Wed Apr 09, 2003 2:17 am
Location: Izmir/Turkey

Post by TFC »

Thank you. I start to understand but still complex for me :)
Is there any way to calculate circuit (i mean traffic) percentage that passing over given average value.
For example Our traffic must be under %70. And we want to report that ratio whole day over over treshold value.
Mathematically i want that:
288 sample taken from cacti (per 5 min* 24 hrs)
3 times traffic reaches over %70
Percentage (over treshold value)=(3/288)*100 = %1,04
if I can do this.I can do others.
Can you help me to do it?
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

TFC wrote:Thank you. I start to understand but still complex for me :)
Is there any way to calculate circuit (i mean traffic) percentage that passing over given average value.
For example Our traffic must be under %70. And we want to report that ratio whole day over over treshold value.
Mathematically i want that:
288 sample taken from cacti (per 5 min* 24 hrs)
3 times traffic reaches over %70
Percentage (over treshold value)=(3/288)*100 = %1,04
if I can do this.I can do others.
Can you help me to do it?
Hi TFC!
Sorry for my late answer. I was absolutely busy during the last days.
Create a new template and choose "Average" as CF. After that create a new variable to make it flexible:
Name: Threshold
Description: blablabla...
Maximum: 100
Minimum: 50
Default: 70
Type: "DropDown"
Stepping: 1

Click on "create" and then you see in the overview the internal name given to that variable.
Create a new measurand:
Name: Percentage over threshold
Abbreviation: POT
Unit: %
Visible: Yes
Separate: No
Rounding: Base 1000
Calc Formula: f_dot(maxValue/8*"Internal name of the variable"/100)

If you don't want to use a variable, you can also use:
f_dot(maxValue/8*0.7)

That's it!


Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
thomasw
Posts: 33
Joined: Thu Nov 10, 2005 6:11 am

060 alpha: csv export no longer available on filesystem?

Post by thomasw »

Hello,

today I checked out the latest version from sourceforge svn ( 0.60 alpha?) and installed it on my testsystem. Everything went fine so far, the plugin seems to be fully functional. BTW, I like the new graphs (limited to top X)!
Nice work!

But I`m missing the csv export file on the filesystem. In the last version 0.51 there was a folder exports, which holds the file. Are there any plans to go without storing the file?

From reading the posts in this forum my understanding was, that there will be a scheduled export of the csv file. Am I wrong on that?

Can you please share the plans for the export functionality?

Thanks in advance,

tom
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Re: 060 alpha: csv export no longer available on filesystem?

Post by browniebraun »

thomasw wrote:Hello,

today I checked out the latest version from sourceforge svn ( 0.60 alpha?) and installed it on my testsystem. Everything went fine so far, the plugin seems to be fully functional. BTW, I like the new graphs (limited to top X)!
Nice work!

But I`m missing the csv export file on the filesystem. In the last version 0.51 there was a folder exports, which holds the file. Are there any plans to go without storing the file?

From reading the posts in this forum my understanding was, that there will be a scheduled export of the csv file. Am I wrong on that?

Can you please share the plans for the export functionality?

Thanks in advance,

tom
Hi Thomas!
Many thanks for your feedback. The current SVN release works, but it does not use the defined presets. Manual exports to CSV or XML won't be saved to the harddisk any longer. The new email functionality is still missing, but it's planned to use it for sending exports automatically.
After this, some little changes and one other new little feature has been finished v0.6.0 will be released.
With a view to the current feature requests under sourceforge and my own ideas, I'll apply myself to expand this exporting section in v0.7.0 by developing a lot of new features. (e.g. It's definitely planned to introduce open XML documents to export a list of reports in one file)

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
tephra
Posts: 26
Joined: Sun Dec 09, 2007 8:11 pm

Post by tephra »

Hey Andreas,

Any chance of a quick walk-through on how this works?

I have no idea what I am doing - everything is very foreign to me! :(

Cheers
David
tephra
Posts: 26
Joined: Sun Dec 09, 2007 8:11 pm

Post by tephra »

ahh ok worked out some stuff on my own :)

couple of questions:

1) can I aggregate two datasources, ie two interface statistics which represent an aggregated uplink interface?

2) regarding csv export, can I change the default delimiter from ";" to ","

Cheers
D.
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

tephra wrote: 1) can I aggregate two datasources, ie two interface statistics which represent an aggregated uplink interface?
No - not directly. But maybe you can use a multilink instead.
tephra wrote: 2) regarding csv export, can I change the default delimiter from ";" to ","
To change the user-specific settings go to "graphs->settings".

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
tephra
Posts: 26
Joined: Sun Dec 09, 2007 8:11 pm

Post by tephra »

browniebraun wrote:
tephra wrote: 1) can I aggregate two datasources, ie two interface statistics which represent an aggregated uplink interface?
No - not directly. But maybe you can use a multilink instead.
tephra wrote: 2) regarding csv export, can I change the default delimiter from ";" to ","
To change the user-specific settings go to "graphs->settings".

Best regards
-Andreas-
1) what do you mean by mutlilink?

2) sorted - thanks :)

3) Will automatic email of csv repots be implemented?

4) In the csv, start_day and end_day seem to be broken? I chose a daily report and my start day is Monday and end day is Sunday.

Cheers
D.
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

Sorry,
1)"Multilink" was the wrong keyword, but if you have defined e.g. a Gigabit Ethernet Channel then you can integrate that in Cacti too.
2) :wink:
3) Yes (for scheduled reporting)
4) These fields only return your configuration of defined working days. The default is start_day = "Monday" -> end_day = "Sunday", or with other words: All days of a week are included.
e.g. You define Monday till Friday and you want to start your calculation for the last day on a Monday morning, then you will get no result, because the last day will be a Sunday and that's not part of your working days.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
tephra
Posts: 26
Joined: Sun Dec 09, 2007 8:11 pm

Post by tephra »

1) yeah so as long as its a datasource then it can be reported on, just can't use 2 datasources together!

3) Cool - can't wait

4) I will have to take another look, don't really know what you mean :)

Lastly when scheduling reports what do I need to put into the crontab?

Cheers
D.
Kamyk
Posts: 6
Joined: Tue Apr 01, 2008 4:08 am

Post by Kamyk »

Hello,

After install that plugin i have problem :(

That -> Fatal error: Call to undefined function safeguard_xss() in /usr/share/cacti/site/plugins/reportit/cc_view.php on line 34

Some advice?

Br,
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

Kamyk wrote:Hello,

After install that plugin i have problem :(

That -> Fatal error: Call to undefined function safeguard_xss() in /usr/share/cacti/site/plugins/reportit/cc_view.php on line 34

Some advice?

Br,
Normally a bug report should contain a minimum of information. So what about the version of Cacti, PIA and ReportIt?
The function you mentioned is defined in /reportit/lib_int/funct_validate.php and the script called "cc_view.php" will automatically include the library on line 25. Check if that library is available and type in

Code: Select all

echo $config["base_path"] . '/plugins/reportit/lib_int/funct_validate.php';
one line after

Code: Select all

include_once('./include/auth.php');
to validate the path to that library.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
tephra
Posts: 26
Joined: Sun Dec 09, 2007 8:11 pm

Post by tephra »

Hey Mate,

Just quickly what do we need to put into the crontab so that reports scheduled work?

Cheers
D.
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

tephra wrote:Hey Mate,

Just quickly what do we need to put into the crontab so that reports scheduled work?

Cheers
D.
Take a look at http://forums.cacti.net/viewtopic.php?p=87970#87970

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests