Is it possible to fetch list of failed and terminated workflows using a script or tctl ? I know how to fetch using SDK but checking if there is a simple script or tctl command to retrieve these ?
You can use the tctl workflow list command, for example:
tctl workflow list -q 'ExecutionStatus="Failed" OR ExecutionStatus="Terminated"' -m
if you have Elasticsearch enabled.
If not, you need to run two separate commands to list workflows by status:
tctl workflow list --status=failed tctl workflow list --status=terminated