Description of problem: Setting a filter based on the following causes reporting worker to hit 10GB+ VM Template and Image.Management Events : Dest Ems Cluster Name In customer environment removing the filter allows the report to complete as expected Version-Release number of selected component (if applicable): 5.8.5 How reproducible: Always in customer environment Steps to Reproduce: 1. Go to Cloud Intel > Reports 2. create a custom report with the above filter 3. Actual results: Reporting worker exceeds memory Expected results: Report should complete Additional info:
It looks like the report is downloading all the events in the event stream. Are you really looking for a template that has an event associated with a particular cluster? current: conditions: !ruby/object:MiqExpression exp: CONTAINS: field: MiqTemplate.ems_events-dest_ems_cluster_name value: Recurso I expect it to not to go through events and reference the template.ems_cluster.name. conditions: !ruby/object:MiqExpression exp: CONTAINS: field: MiqTemplate.ems_cluster-name value: Recurso I'll look into optimizing this relationship, but do wonder if it is the report definition at fault.
I played with the expression, and I feel it could possibly be INCLUDES (or EQUAL) instead of CONTAINS. From what I understand, CONTAINS is for tags while INCLUDES/EQUAL is for field values (like cluster name) This regular expression is showing all templates with a cluster name that includes Recurso (or is equal to) Recurso conditions: !ruby/object:MiqExpression exp: EQUAL: field: MiqTemplate.ems_cluster_name value: Recurso
I'll update the customer with the change and will follow up if it works for them.