Hello community,
I'm trying to do something with DQL, but I'm not even sure it's possible. To give you some context, I have a DQL query to display Control-M jobs that are retrieved using the following extension:
timeseries { avg(controlm.job.status), value.A = avg(controlm.job.status, scalar: true) }, by: { `dt.entity.controlm:job` }
| lookup sourceField:`dt.entity.controlm:job`, lookupField:id, [
fetch `dt.entity.controlm:job`
| fieldsAdd application, description, subapplication, orderdate
]This query displays the status of the jobs as a percentage. For example, a job waiting to pass is at 25%, a job OK is at 100%, etc.
The problem is, there's no field that contains the information about when the job executes and passes (OK or KO). I only have the graph showing the percentage change:
My question is: is it possible to "store" the hour and minute when the value changed from 25% to 100%? The goal is to have a table, not a graph, displaying the job status and time of each job (like the one below, but with an additional column showing the exact time of each job):
If you have any suggestions, I'd appreciate them.
Best regards,
Red
Featured Posts
