Automate aggregate

[jeanm]

Mmh.. OK, I've done that but unfortunately it is still not working. The first two items should sum up but the graph debug gives:

Code: Select all

...
CDEF:cdefec=ec,0,* \
CDEF:cdefed=ed,0,* \
CDEF:cdefee= \
CDEF:cdefei= \
AREA:cdefa#00BF47FF:""  \
AREA:cdefb#00FF00FF:"":STACK \
...

Thanks for your help. I'm thinking in go for other solution... using a specific data source for each aggregate I'd like to do. That data comes from external script that would do the automatic aggregation. For now I don't see other "clean" way of doing this.

[skatter]

Any chance that this will get merged into autom8?

[artiflo]

Hello,

Where I could find the last version (>0.35) of autom8 ?

This bug speak about v0.36 or v0.37.

[gandalf]

Any chance that this will get merged into autom8?

Please develop based on the SVN code that's cutrrently available. Then post the diff's and I'll see what I can do.
R.

[Kiarlo]

Need help:

I'm working on Cacti 0.8.8b, uploaded plugins autom8 main@rev 2076 and aggregate trunk@rev 2069.
I applied patches in bug reports: #2171 for autom8 and #2169 for aggregate.

When I try to create a Rule Item under an Aggregate Rule it always shows me "There are no matching rows for this Filter Rule" whatever Field name and matching pattern I use.

If I set logs to DEVELOP I get:

Code: Select all

10/09/2014 12:39:34 PM - AUTOM8 TRACE: Poller[0] build_aggregrate_rule_query returns: SELECT * FROM (SELECT host.*, host_template.name, graph_templates_graph.title, graph_templates_graph.title_cache , MAX(CASE WHEN field_name='Index' THEN field_value ELSE NULL END) AS 'Index', MAX(CASE WHEN field_name='desc' THEN field_value ELSE NULL END) AS 'desc', MAX(CASE WHEN field_name='ifname' THEN field_value ELSE NULL END) AS 'ifname', MAX(CASE WHEN field_name='ifalias' THEN field_value ELSE NULL END) AS 'ifalias', MAX(CASE WHEN field_name='iftype' THEN field_value ELSE NULL END) AS 'iftype', host_snmp_cache.snmp_index AS snmp_index FROM host_snmp_cache LEFT JOIN host ON (host_snmp_cache.host_id=host.id) LEFT JOIN host_template ON (host.host_template_id=host_template.id) LEFT JOIN graph_local ON (graph_local.host_id = host_snmp_cache.host_id AND graph_local.snmp_query_id = host_snmp_cache.snmp_query_id AND graph_local.snmp_index = host_snmp_cache.snmp_index) LEFT JOIN graph_templates_graph ON (graph_local.id = graph_templates_graph.local_graph_id) WHERE graph_local.snmp_query_id=15 AND graph_local.graph_template_id=52 AND ( host.description LIKE '%ca%') GROUP BY graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index ORDER BY description, host_snmp_cache.snmp_index) AS a WHERE ( 1!=1 )

Thanks in advance for any suggestion.