Cactiquery [Cacti Query tool]

[pestilence]

Ok boys and girls the csv output plugin has been finished today.
I will be releasing it in a while because currently i am waiting for an answer from the cactistoric author (Bruno).
The plugin is called Cactiquery and is merged with the cactistoric plugin of Bruno (this was done since lots of users including me are using Bruno's plugin and i didn't want to break it).
The plugin gives you the abillity to query rrd's on specific time peridiods (like cactistoric) and returns you the raw stored values formated in human readable format.
It also gives you the abillity to store those values inside a csv file (compatible with excell) which you can manipulate in a spreadsheet program as you like.

For those who are in need of such a tool i attach a screenshot...

[Mika]

That is great Pestilence.
When we can expect that plugin to see for public use?
That's the thing I planed to do in a near future


Best regards,
Mika

[pestilence]

As soon Bruno replies to my email (i asked him if it ok with him to distributed cactiquery tarball with the cactistoric plugin as well) i will be ready to submit the plugin for public use.
Current version was created for 0.8.5a cacti...but i have also a 0.8.4 version as well somewhere on my system...

[dres1978]

hi pestilence, cactiquery is a nice tools
one question
i have installed cool zoom/history feature, but a want to install only cactiquery, it is possible?
I suppose that cool zoom and cactistoric is a similar tool

[jrewing]

Hi Pestilence,

thank you for your great tool. But i can't get data when graph si created from more sources( rra). I get always only from the first file.

Also i can't get data from any other interval then past 24 hours from current time.

Any ideas ?

Thanks

I use cacti 085a & rrdtool 1.48 & RH 8.0

[pestilence]

[TheWitness]

Pestilence,

Really need your help in the bea program. This is just one example. In the conference call, I want to bring up the integration with Bruno's tool. We may have to delay the release if several people have integrated since we have not.

TheWitness

[Didier]

Where can I get this tool ?
I'm interested to do the following in Cacti, I think it is quite similar.
Thanks


Statistics report table in Cacti
=====================
Hello I'd like to have a "statistics report table in Cacti".
Has anobody already work on such an add-on for Cacti ?


My idea is the following.
For the time I don't have time to make any implementation, but if someone can help me I will be great.



Format of report
============
Selection period: YYYY MM DD HH:MM:SS to YYYY MM DD HH:MM:SS
min average
max
graph_name1 legend_curve_11 x x x
graph_name1 legend_curve_12 x x x
....
graph_name2 legend_curve_21 x x x
graph_name2 legend_curve_22 x x x
graph_name2 legend_curve_23 x x x



where
-The graph1 has a name "graph_name1". On this graph we have 2 curves
displayed. The legend of the fisrt one is legend_curve_11
The legend of the second one is legend_curve_12
-The graph2 has a name "graph_name2". On this graph we have 3 curves
displayed. The legend of the fisrt one is legend_curve_21
The legend of the second one is legend_curve_22, the third one is
legend_curve_23

- The graphs selected will be the graphs selected in the "List View" tab
For each curve the minimum, average and maximum are displayed

- The minimum, average and maximum are computed from the chosen selection
period YYYY MM DD to YYYY MM DD

- The graph will be a simple table in ASCII format.
This ASCII format and the lines above will allows us to make copy &
paste of the information we want into Word, Excel, .... in order to make
reports

For instance in particular I plan to make an availability curve whom values
are either 0 or 100, therefor the "availability" column will be a percentage
of availability of the device in the month




Some elements to help in doing it
=======================
- For the selection period, I would use a mecanism similar to the one
proposed in "Cactistoric" from Bruno PRIGENT
I have made proposal of modifications of the Message Board "Scripts
and Other add-on for Cacti / Cool zoom/history feature for cacti " to
zoom on all the selected graphs in Tree or List mode ==> User
"Didier" at the end of all submissions. I'll use the same mechanism
than in the preview mode.


- To know which curve are displayed in a graph, an idea can be to detect
in the rrdtool graph all the LINE 1, LINE2 or LINE3
instructions
And then will have all the information (the name of the variable +


- To compute the minimum, maximum and average I would use
the same rrdgraph used to graph on which
I would remove LINE1 LINE2 LINE3 GPRINT
For each LINE1, LINE2 or LINE3 I would have
rrdtool graph --start <start_of_selection_period> --end
<end_of_selection_period> PRINT <variable> : MIN : %s
rrdtool graph --start <start_of_selection_period> --end
<end_of_selection_period> PRINT <variable> : AVERAGE : %s
rrdtool graph --start <start_of_selection_period> --end
<end_of_selection_period> PRINT <variable> : MAX : %s

The PRINT instruction of rrdtool graph displays the results
in sttdout so I think it should be feasable to have it displayed on an
HTML window
I would separate the computation of min, average and max in order
to put them in the corresponding cell.

- To access this statistics view if possible I would make a tab
"STAT"
The "List Mode" will allow you to select the graphs, when clicking o
view you go to the "Preview Mode" for the selected graphs, if after you
select the "STAT" tab you would access to this statistic report


Didier

[JoeNetwork]

/bump

Will something like this work in 0.8.6 or 0.8.6a?

[DeathFromAbove]

Ditto

I am currently having a look at integrating the old version with 0.8.6