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

zarahel · Post by **zarahel** » Wed Mar 18, 2009 1:24 pm

Ok

I figured it out...I didn´t had configured builtin Authentication, and Reportit requires it to work.

Post by **browniebraun** » Wed Mar 18, 2009 1:31 pm

The description of ReportIt's realm permissions is slightly misleading.
If you are a report admin (super user) then you have to check them all. Please take a look at my little introduction.

Best regards
-Andreas-

Dwarf · Post by **Dwarf** » Thu Mar 26, 2009 3:56 am

Hi Browniebraun,

I took a look at your 'introduction' to Reportit and I can now understand a little bit more how to the different parts interact between them.

Your doc mentions the feature 'Creation of Top 10 charts', but this section seems not to be written yet.

Could you explain briefly how to create such kind of report or top10 ??

I need to create some 'standard' reports for my customers like :

- Top 10 of CPU Usage for XXX Servers
- Top 10 of Memory usage for XXX Servers
- Top 10 of Bandwitdh usage on interwitch links over my networks

Thanks a lot for your answer

Dwarf

dononeil · Post by **dononeil** » Fri Mar 27, 2009 12:28 pm

I just installed ReportIT from the current sourceforge tree... nice tool.

However, I found a 'bug' of sorts, maybe just an oversight...

We have many 10G links, which requires 64 bit interface stats. We collect them that way and they graphs ok, but when they're reported in Reportit they come back as 4.29G links (the 32 bit max).

Just thought you should know for the next rev!

Post by **browniebraun** » Sat Mar 28, 2009 12:46 am

Dwarf wrote:Hi Browniebraun,

I took a look at your 'introduction' to Reportit and I can now understand a little bit more how to the different parts interact between them.

Your doc mentions the feature 'Creation of Top 10 charts', but this section seems not to be written yet.

Could you explain briefly how to create such kind of report or top10 ??

I need to create some 'standard' reports for my customers like :

- Top 10 of CPU Usage for XXX Servers
- Top 10 of Memory usage for XXX Servers
- Top 10 of Bandwitdh usage on interwitch links over my networks

Thanks a lot for your answer

Dwarf

At the moment you can only sort your results per measurand per data source and limit the number of rows to 10.
If you've a good approach how to improve that function then post it or put it in a feature request. I'm always happy to get ideas and suggestions from the community.

Best regards
-Andreas-

Post by **browniebraun** » Sat Mar 28, 2009 12:54 am

dononeil wrote:I just installed ReportIT from the current sourceforge tree... nice tool.

However, I found a 'bug' of sorts, maybe just an oversight...

We have many 10G links, which requires 64 bit interface stats. We collect them that way and they graphs ok, but when they're reported in Reportit they come back as 4.29G links (the 32 bit max).

Just thought you should know for the next rev!

The calculation of 10 G links will be suppport by the next release. At the moment only one feature (export to paths) is missing before 0.7.0 will be published.
Feel free to test the upcoming features! You can download a tarball here http://cacti-reportit.svn.sourceforge.n ... z?view=tar. But keep in mind the following requirements: Cacti 0.8.7 + PIA 2.x and MySQL 5

Best regards
-Andreas-

dononeil · Post by **dononeil** » Mon Mar 30, 2009 10:44 am

Thanks for the latest build, I'll give that a shot....

Can you tell me what processes run in the background and how to monitor them on reports that take more than a few minutes to run?

I started a report, very similar to your example int he guide, for 20,000 or so links so we can generate a top 10 list... I started the report 3 days ago, and the system still says it's running. I'd like to be able to see what's going on, as I'm not seeing much system load, and no processes 'jumps' out to me.

Also, I've been trying to track down info on the PHP-RRDtool extensions... how much faster is this method vs. the standard method? There's nothing in the docs that talks about that.

Thanks!!!

Post by **browniebraun** » Mon Mar 30, 2009 11:22 am

Oh dear! 20000 data items in one report? Wow.
In that case I assume that the report ran out of time.
Go to Console->Cacti Settings-> Reports and increase the maximum execution time. After that rerun your report from the CLI:

Code: Select all

php runtime.php <report_id> -v

Using the php bindings instead of the other methods will increase the report calculation by a minimum of 100%.

Best regards
-Andreas-

dononeil · Post by **dononeil** » Mon Mar 30, 2009 2:16 pm

Thanks... running it from the command line did the trick:

03/30/2009 11:58:26 AM - PLUGIN: Poller[0] REPORTIT STATS: ID:1 Time:3408.9 Reports:1 Emails:0 Exports:0

I did however edit the setup.php file to allow for 6 characters in the timeout setting, just in case, lol.

That's my biggest report, so hopefully none of my other ones will go that long!!!

Are there any other resources for 'how to' besides your one sample doc?

I'm going to try to hack my way through setting up some reports, but a few more examples would be nice to be able to refer to.

Thank!

dononeil · Post by **dononeil** » Mon Mar 30, 2009 2:35 pm

One other thing.....

I ran the report with your pre-release v.70.... and the 10G interfaces are still showing up as 4.3.

Now, the report config was created with the .61 code before, and all the data sources added under .61 as well... Do I need to re-add, or completely re-create the report config under .70?

With the completeness of what you have right now, maybe you should consider releasing v.70, and make the last feature a v.71 version? I'm sure there are lots of people out there that would love it!

dononeil · Post by **dononeil** » Mon Mar 30, 2009 3:40 pm

Wow... I'm full of questions today!!

Is there some way to select multiple data sources for a report?

For example, we have several different types of routers, and each one returns temperature via a different data source (not the same OID, so there are multiple data sources).

I'd like to be able to generate one report from all of the temperature data sources. Can this be done?

dononeil · Post by **dononeil** » Mon Mar 30, 2009 6:04 pm

Here's a bug report for ya on v.070:

When I try to search the data items in a report, I can't do any wildcard searches....

My data items list contains names such as:

0037-RTR-F1 - Traffic - 10.240.1.82 - Se0/0.1
0037-RTR-F1 - Traffic - 10.240.101.82 - Se0/0.2

and so on....

When I put in 0037* or 0037% or 0037 in the search, NOTHING comes up, so there is no partial matching working.

dononeil · Post by **dononeil** » Mon Mar 30, 2009 6:14 pm

One final thing for today.... v.070:

Why do the reports results listed show different values from the graph that is generated?

See the attached images.

Post by **browniebraun** » Tue Mar 31, 2009 1:03 am

dononeil wrote:One final thing for today.... v.070:

Why do the reports results listed show different values from the graph that is generated?

See the attached images.

Damn! I spent so much time for testing and didn't fetch that issue.
Seems to be a bug within the extended calculation cache. I'll have to make a debug session tonight.

UPDATE: A bug fix can be downloaded here

dononeil · Post by **dononeil** » Tue Mar 31, 2009 11:06 am

How about my other questions:

1) Is there a way to report against multiple data sources from different devices
2) What about the search function, how is it done, are there wildcards, etc...
3) When I migrate from .61 to .70, will I have to re-generate the reports in order to properly support 10g interfaces
4) Can you make the timeout field at least 5 chars... I've got big reports!

Thanks!

Cacti

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

How to create Top10 reports ?

Re: How to create Top10 reports ?

Who is online