16 May 2024 09:03 AM - last edited on 16 May 2024 11:01 AM by MaciejNeumann
Hey All,
I'm trying to grab the names or URLs of all the workflows that ran today from 'dt.system.query_executions'. The trouble is, the data in 'client.source' doesn't have what I need - like the workflow_id. So, I'm struggling to connect the dots between the query_id and the Workflow_id.
Any ideas on how I can bridge that gap? It'd help me track down the user who's been using the most DDU and see which Workflow they've been running.
Here's the query I'm using:
fetch dt.system.query_executions, from: now()-1d
| filter status == "SUCCEEDED"
| fieldsAdd tb = toDouble(scanned_bytes) / 1099511627776
| fieldsAdd formatted_date = formatTimestamp(timestamp, format:"MM-dd-YYYY")
| filter client.application_context == "dynatrace.automations"
Thanks for any tips you can give!
16 May 2024 02:12 PM
@PacoPorro
Thanks for Your reply but in the query you provided
there isn’t how many scanned_bytes the workflow used
and there isn't query_id
so I can't get how many scanned_bytes the workflow used
and who created the workflow
16 May 2024 03:25 PM
I'm trying to find the link between both tables but unfortunately, I can't see anything matching both