[SOLVED] Lower limit and upper limit variable support

[llow]

It would be nice to be able to dynamicaly set the lower and upper limits through query or other variables.

The database structure would probably need to change lower_limit and upper_limit to a varchar(255).

I can work up a patch for 0.8.7 for this if anyone else thinks its a good idea.

[rony]

Yep, it would be nice.

The only problem, and the reason it has yet to be implemented, is that updates to the RRDTool file are not made by Cacti once the file is created.

But to be honest, if you are going have dynamic variables, I would only want to apply them to the graph output.

Let's think of this, what if a max value where to be passed and applied to the data source, then the RRDTool file was updated, but this value was below past maximum values in the RRDtool file. Would those maximum values be retained or trimmed in the RRDtool file?

FYI, I want you to write this patch, I want to see what you come up with. But I want you to think about the above issues.

Thanks for reading my ramblings!

[llow]

I'll put something together. I am only planning on such functionality for the graphing portion as I would think most people would be using them for thresholds.

[llow]

Here is the patch.

Will need to increase varchar size as well to be useful...
ALTER TABLE graph_templates_graph MODIFY lower_limit VARCHAR(255);
ALTER TABLE graph_templates_graph MODIFY upper_limit VARCHAR(255);

[rony]

Please post a bug/feature for this, it easier for us to track.

[gandalf]

Implemented in SVN, targeted release is 088
Reinhard