Reporting: Top Talkers, busiest servers - PLUGIN AVAILABLE

[bradley]

cigamit,

I've made various fixes to runReports.pl - its CDEF/DEF generation wasnt
quite right all the time.

I've also made fixes to report_view to make it handle negative numbers
(The Bandings only banded positive values, so no negative values were not being displayed - this may be why you werent getting any results???)

Try download again and let me know if it fixes your issues.

Regards
--
Brad.

[rony]

This is an addon now, not a feature request, moving to addons

[knobdy]

So how about a plugin version?

[bradley]

Cigamit has made it into a plugin - I've asked him to post the code
but he hasnt yet - I think he's trying to resolve some other issues first.

Regards
--
Brad.

[bradley]

Hi all,

I've converted this into a plugin now.

Let me know if there are any issues.

Regards
--
Brad.

[Attachement removed. Please see:

http://forums.cacti.net/viewtopic.php?p=65008#65008

]

[knobdy]

This is AWESOME - and easy to implement.

Just to keep the conversation (and thereby hopefully development) going, I'd like to see and hear about other reports this plugin can do - or what the limitations of this plugin currently are (only does inbound/outbound traffic reports)....

The ONLY problem I have with it is the name of the plugin being "reports" - since that is the same as another plugin I already had. I went ahead with this one since I couldn't get the other to work completely - but the most useful feature of the other one is the ability to e-mail reports... that would be nice here too!

Other ideas:
Ability to delete old reports - will they currently be there forever?
Ability to report on other things - a complete reporting system for cacti (and this is the most complete version of one I've seen so far).

[egarnel]

Hi,

I am testing this out on 8.6.h (cacti cd)
and I am getting the following

Code: Select all

perl runReports.pl 2
DBD::mysql::st execute failed: Table 'cacti.plugin_report_definitions' doesn't exist at runReports.pl line 620.
Could not execute SELECT

a 'show tables' in mysql reveals no such animal. I've read the README, but I seem to be missing any db modifications that may be required.

[chadd]

What's the word on getting this in official plugin form (minus the extra cron job)? Cigamit, will you be posting this on cactiusers.org? This looks very interesting! Cacti is getting more and more useful every day, great job everyone! Great plugin Brad, I can't wait to try it!

[bradley]

Chadd, I have already made this into a plugin (it was originally a patch).

Download the .zip file attached and follow the (now updated) readme
in one of my earlier posts. (The README is included in the .zip file too)

Egarnel, after installing the plugin, you need to configure your reports
using your web browser first - the first time this happens it will create
the tables you require.

--
Brad.

[egarnel]

Ok, I moved the old reports plugin out of the way and renamed the new one from topten back to reports.
I now see the tab in cacti and reports settings under console. I do not have the option under reports settings to add a report, only delete & duplicate.

when I run the runReports.pl via the command line, I get the following:

Code: Select all

No report definitions found for RRA ID 1 at runReports.pl line 121.

I see the tables in mysql, but they are empty

[bradley]

egarnel, The "Add" link should be at the top-right corner of the screen.

--
Brad.

[bradley]

knobdy, reports are already periodically deleted. Daily reports last for 2 weeks, weekly reports last for 2 months, monthly reports last for 2 years, and yearly reports last for ever.

The way the reports work, is that it reports any item that is plotted on a graph - in other words the reports are based on the data templates and graph templates that you set up, including any CDEF's etc that are used on the graphs themselves.

This means that you can report on ANY THING that you can graph, so its not just limited to internet traffic.

Using the Start/End Day/Time in the Report Settings it is possible to make the report only consider data during (for example) Monday-Friday between 9am and 6pm.

With regards to emailing the reports out, would it suffice to just send an email with a link to the actual report?

Another thing I'm considering is the ability to "track" reports over time, which would make it possible to compare one report against the previous, for example to compare internet traffic week-by-week. I dont know if I'll ever have time to do this tho. Not sure how the user-interface for this would work either.

The last idea that I had (which would actually be quite easy to implement) would be to include thumbnails on the report itself. They would need to be kept quite small tho to prevent the screen from looking overcrowded and one could always click on the link to see the graph for the time-period any way.

--
Brad.

[egarnel]

Dohhh, it is either old age or too much crack that is getting to me. I got it working now.
It is a much appreciated add on. Thanks again for coming up with it.

[twelzy]

bradley,

Which options must I use in Start/End Hour to get a report of a full day (00:00h to 23:59h)?!

Thanks in advance!
(...and sorry for my poor English!)

[bradley]

Use 00:00 and 23:00.

Its perhaps a bit misleading at the moment because it is INCLUSIVE of these hours
(It doesnt use the minutes part).

--
Brad.