cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Compare a column from 2 different executions of the same query capture value of any new ones

rseibert1
Contributor

I have a workflow that has the below DQL task, I want to run and compare executions of this and create a list (of new unhealthy workers).

fetch logs
| filter contains(log.tag, "octopus_workers")
| parse content, "JSON:json"
| fieldsFlatten json
| expand json.content
| fieldsFlatten json.content
| expand json.content.alertText
| fieldsFlatten json.content.alertText
| fields timestamp, Id=json.content.alertText.Id

 

The table looks like:

rseibert1_0-1733824360988.png

The timestamps are only currently ever 12hrs, (via the task that ingests the logs) but I will eventually ingest logs  every 5min from workflow.

So the ability to compare Id's from previous 5min and capture Ids that are recently added.

 

1 REPLY 1

rseibert1
Contributor

Think maybe more than one way to do this, looking for the simplest, think if it ingests logs every 5min, I could compare the Id column from one execution to another and grab any unique ones. OR could make one DQL query that compares logs from the different times (now and -5min) but not having luck finding any examples of what I want to do.

Thanks 

Featured Posts