Query: Freestyle project's last successful build

Description

This query helps you identify the last successful build of each freestyle project in your Jenkins environment, which can assist in tracking project progress and ensuring builds are completing successfully. It is particularly useful for maintaining build quality and identifying issues early by pinpointing the projects where the most recent build was successful.

Query

Tables used in this query:

• jenkins_freestyle_project

SQL