SonarQube Instance Level Reporting

Using Sonar 7.4 upgrading to 8.X in the near future.
Each week, I am required to create a dashboard in Excel for all projects reporting in SonarQube, This is time consuming and prone to errors. The information is very basic: Project Name, Pass/Fail of Gate and last scan date.

Ive looked at the APIs that exist for reporting, and I can only find one the reports project by project. Again Im looking at reporting on the entire instance, and with almost 100 projects in Sonar its not easy.

Unfortunately, our request to purchase the Enterprise version was not approved.