Listing projects where last Pipeline failed

Listing projects where last Pipeline failed

As Administrator I need to see list of Projects where last Pipeline (in each project) failed.
I already made simple gitlab-runner script, that provides such information:

• see also: reports/last_failed_builds.rb · main · Henryk Paluch / gitlab-scripts · GitLab

latest_pipelines = Ci::Pipeline.select("project_id, max(id) as id").group("project_id")
latest_pipelines.each do |k|
        pi = Ci::Pipeline.find(k.id)
        next if pi.finished_at.nil? # is it correct?
        next if pi.status.eql? 'success'
        proj = Project.find(k.project_id)
        puts "Project: #{proj.full_path} pipeline failed: status: #{pi.status} at #{pi.finished_at}"
end

However it would be nice to have such information directly in GitLab. Is it there such page available?