Add workflow data for analytics

[benthomasson]

ISSUE TYPE

• Feature Idea

SUMMARY

In order to support workflow analytics on Automation Analytics we need additional data from Tower. We may need a dump of the workflow relationship table in order to analyze root cause failures.

[Ladas]

• new collection added workflow_job_template_nodes
• new collection added workflow_job_nodes

[Ladas]

@rooftopcellist @ryanpetrello I can do this one, I just need opinion from you:

To get the source_workflow_id (now workflow_job_id), we need to do join to job_nodes

awx/awx/main/models/unified_jobs.py

Line 1161 in 47383e0

if self.spawned_by_workflow:

The join might be quite expensive, since the job_nodes table can be quite big? So we can just send the job_nodes table and do the join on analytics side (in the cloud). What do you think?

---

I'll probably just add workflow_job_template_nodes, workflow_job_nodes we'll do any processing we need on the cloud side

[Ladas]

Implemented by #6204

[wenottingham]

-> #6201

[kdelee]

my mistake, we have tests for this