In the UI, Databricks will list the running endpoints on top. Programmatically you can get information about the endpoints using the REST APIs.
You will likely need to use a combo of the list endpoint to get all the endpoints. The for each endpoint use the get call to obtain the metadata for each endpoint. The get endpoint provides a "state".
API docs: https://docs.databricks.com/sql/api/sql-endpoints.html
