CLI Command to List All Failed/Running DAGs without specificing DAG IDs

[yquaziii]

Description

Currently, retrieving a list of all failed DAG runs across all DAGs requires scripting and iterating through each DAG ID using airflow list_dag_runs[1]. This process is cumbersome and inefficient for users who need a quick overview of failed DAGs. In airflow UI we do have an filter to list down all the Failed/Running DAGs

[1] i.e airflow list_dag_runs --state failed <dag_id>

Use case/motivation

• Quickly identifying failed DAGs for operational monitoring and troubleshooting.
• Simplifying the process for users who are not comfortable with scripting.

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.