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 »

michaelwjoyner wrote:Do we want to run the cron entries as "cacti" or "root"?
It's recommended to use the same account as used for the poller. It's important that this user is allowed to create archives.

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
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Re: wrong calculation

Post by browniebraun »

mrgenius wrote:Dear Friends

I am trying to use this Plugin to calculate 95th percentile and Total bandwidth.. However i am getting wrong calculation in both cases.... Can someone point out the mistake i am making here??

I am attaching the snaps of all the configuration.. Along with the graph of total bandwidth from regular graph template.. which is doing correct calculation for the same time period.
I can only see the second formula on your screenshots and it's unfortunately wrong. :roll: Keep in mind that every measured value stored in the RRD file represents a value for time frame. If you want to calculate the amount of data then you have to multiply that value with the difference of time between two measurements.
So you it should be: "f_sum*8*step". And keep an eye on the rounding!

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
michaelwjoyner
Cacti User
Posts: 52
Joined: Wed Apr 08, 2009 12:24 pm

Post by michaelwjoyner »

browniebraun wrote: If you want to read out data from RRDs then you have to define following parameters at least beside the name of the RRD file: The consolidation function, the start and the end of the time series.
So, we have to say for example: Give us all the max values recorded during the latest 7 days.
Would we specifiy the CDP or the CF? It is to my understanding that, that in your example, I would want to use the "MAX - DAILY" archive, and get 7 data points.

This is really a RRDTOOL thingy and how cacti structures the RRD. I need to read up from the RRDTOOL side like you mentioned.

Thanks.
memfiz
Posts: 2
Joined: Mon May 11, 2009 1:29 am

Post by memfiz »

Hello,

I'm trying to schedule a report in a crontab but having a problem to insert Data Items in the report dynamically.
Under the "Scheduled Reporting" section I've checked "Auto Generated Data Items" and I'm filtering Data items in "Data Item Presets". But it seems does not work. When I run the report it gets only one host which I'd added manually.

Does it supposed to generate the list of data items dynamically and what I'm doing wrong in that case?

There is written in the report configuration:
Auto Generated Data Items
Enable/disable automatic creation of all data items based on given filters.This will be called before report execution. Obsolete RRDs will be deleted and all RRDs matching the filter settings will be added.
It seems that nothing is called before the report execution in my case.
memfiz
Posts: 2
Joined: Mon May 11, 2009 1:29 am

Post by memfiz »

Oh, sorry...
I've already resolved this issue by increasing "Maximum Record Count Change" under the Reportit Settings...
j-munroe
Posts: 16
Joined: Thu Apr 12, 2007 2:35 pm
Location: Atlantic Canada

Re: Since Reportit 0.7.1 Upgrade Variable "maxValue&

Post by j-munroe »

browniebraun wrote:
Mmmh, I never thought about that. :-( I'll try to allocate some time next weekend to proof which changes are necessary to support that.
I also fixed a bug some days ago which will occur with data source items selected individually. See http://forums.cacti.net/viewtopic.php?p=164770#164770. So 0.7.3 will come.

Best regards
-Andreas-
If you could find some time that would be awesome!!! :D

Many Thanks!!

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

Re: Since Reportit 0.7.1 Upgrade Variable "maxValue&

Post by browniebraun »

j-munroe wrote:
browniebraun wrote:
Mmmh, I never thought about that. :-( I'll try to allocate some time next weekend to proof which changes are necessary to support that.
I also fixed a bug some days ago which will occur with data source items selected individually. See http://forums.cacti.net/viewtopic.php?p=164770#164770. So 0.7.3 will come.

Best regards
-Andreas-
If you could find some time that would be awesome!!! :D

Many Thanks!!


Jim
Hi Jim!

Edit your data template, tick "Use Per-Data Source Value" and put a value in the field that is higher than zero. I know it will be ignored by Cacti, but used by ReportIt if the Ifspeed / IfHighSpeed won't be found during the calculation. Then you can use the maxValue variable within your formula!

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
iharvey
Posts: 42
Joined: Wed Nov 01, 2006 6:10 am

Post by iharvey »

Hi. I installed reportit at the start of the this week and have been going through the 39 pages of this thread, and reading links referred to - I have got to page 22.
I am using ReportIt for my BW utilisation, and I especially need to document the duration of BW over 95% during working hours only.

Everything seems to be working well, and I am creating some fantastic spreadsheets and graphs.

I have set my Report Configurations to have data item presets
working time
08:00
18:00
working days
monday
friday

I noticed in the email that was sent that the data was for
Monday Sunday 00:00:00 24:00:00

When I double checked the output data (by resetting my data item presets to Monday Sunday 00:00:00 24:00:00), I noticed that the information did not change - I had the same values regardless of the settings.
I know that the information should be different because we have backups between office out of hours.

Is this a bug, or is it my misunderstanding of how the data item presets work?

This is a fantastic addition to Cacti, thank you
iharvey
Posts: 42
Joined: Wed Nov 01, 2006 6:10 am

Post by iharvey »

p.s. - I have NOT got a tick in 'Auto Generated Data Items'
iharvey
Posts: 42
Joined: Wed Nov 01, 2006 6:10 am

Post by iharvey »

and my setup is:
Cacti Version - 0.8.7d
Plugin Architecture - 2.4
Poller Type - CMD.php
Server Info - Linux 2.6.26-2-686
Web Server - Apache/2.2.9 (Debian) PHP/5.2.9-4 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g
PHP - 5.2.9-4
PHP Extensions - zip, xmlwriter, libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, session, SimpleXML, sockets, soap, SPL, shmop, standard, Reflection, posix, mime_magic, mbstring, json, iconv, hash, gettext, ftp, filter, exif, dom, dba, date, ctype, calendar, bz2, bcmath, zlib, pcre, openssl, xmlreader, apache2handler, gd, mysql, mysqli, PDO, pdo_mysql, snmp
MySQL - 5.0.51a-24+lenny1
RRDTool - 1.3.1
SNMP - 5.4.1
Plugins
  • Global Plugin Settings (settings - v0.5)
    Large Site Performane Booster (boost - v2.4)
    Cacti Log View (CLog - v1.21)
    FlowView (flowview - v0.5.2)
    Realtime Graph Viewer (realtime - v0.36)
    Thresholds (thold - v0.4.1)
    Update Checker (update - v0.4)
    PHP Network Weathermap (weathermap - v0.96a)
    Host Info (hostinfo - v0.2)
    Host Info (hostinfo - v0.2)
iharvey
Posts: 42
Joined: Wed Nov 01, 2006 6:10 am

Post by iharvey »

Couldn't see ReportIt in hostinfo...

Cacti-ReportIt
Directory: reportit
Version: 0.7.1
Author: The Cacti-ReportIt Team
Home Page: http://sourceforge.net/projects/cacti-reportit/
Status: Active
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

The presets will only be used for new data items, which will be added to the report config. So, edit one data item, update the working time / days and save it. After that select this data item and choose under actions "Copy settings to all".

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
iharvey
Posts: 42
Joined: Wed Nov 01, 2006 6:10 am

Post by iharvey »

Fantastic - I would never have thought to do that! Many thanks for the swift and accurate response, Andreas.

I have also noticed that although I can tick all (4) reports I have created in 'report configurations', it only runs the first one. This is not a problem for me, as I have set them up in crontab, which works properly.

Superb plugin.

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

Post by browniebraun »

iharvey wrote:Fantastic - I would never have thought to do that! Many thanks for the swift and accurate response, Andreas.

I have also noticed that although I can tick all (4) reports I have created in 'report configurations', it only runs the first one. This is not a problem for me, as I have set them up in crontab, which works properly.

Superb plugin.

:D
Yes, it's limited to run only one report at all. That's a relict built in the first version. During the calculation process ReportIt will increase the utilization of a single CPU up to 100% and I wanted to avoid that users can stress a small Cacti server.
If you have other hints and ideas post them all, please. I will try to discuss them with Reinhard and Thomas at the upcoming 4CCC.

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
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Back from UK

Post by browniebraun »

Hi Cacti Community!

I used the first days of my vacation for a short trip to London. There I met my friend Vlad (vladah) who works with Cacti on Solaris.
Unfortunately we didn't have a WII for a quick fight. ;-)
The weather was really good and I've to say that London is one of the most impressive cities I've have ever seen.
Here people know how to make good parties.

During the next days I will have some time left to build a prototype of ReportIt 0.8.0 supporting DSSTATS, THOLD metrics and Chart Director.

Best regards
-Andreas-
Attachments
DSCF3011.jpg
DSCF3011.jpg (104.86 KiB) Viewed 5523 times
DSCF3022.jpg
DSCF3022.jpg (112.69 KiB) Viewed 5523 times
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