How to export list of BUG data to excel or HTML from dashboard

Hi Team,

I am trying to export Bugs list from Sonar dashboard to HTML or excel sheet for reference to track like how many issues we fixed in a week ! Is there any option to pull those detailed information.

Thanks In advance !
Bharadwaj V

Hi @Vana_Bharadwaj and welcome to the community :wave:

If you want to have easy automated reporting on the current status of your project you might want to take a look at portfolios which are available in the Enterprise Edition (:moneybag:) of Sonarqube. These reports can be send via mail from sonarqube in a scheduled way or downloaded on demand.

If you want to build some kind of monitoring and do the generation by hand, you might want to take a look at the API endpoint api/issues/search. here you can query your sonarqube instance for detailed information about the issues that are still open or closed (depending on the parameters) and build your own reporting from these information.
Here is an example query via curl assuming you have a project called test in the default-organization and your sonarqube server is on localhost:9000 with the credentials admin:admin:

curl -u admin:admin "http://localhost:9000/api/issues/search?componentKeys=test&s=FILE_LINE&resolved=false&types=BUG&ps=100&organization=default-organization&facets=severities%2Ctypes&additionalFields=_all"

hope that helps :slight_smile:

1 Like