How to export some report like excel files or something by using database?

SonarQube Server / Community Build
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
  • what are you trying to achieve
  • what have you tried so far to achieve this

*version status
sonarqube 7.9.1
sonar-scanner-msbuild-4.6.2.2108
language : C#
DB : Oracle 12c

Good day,
I’ve been testing about exporting some material by using database.
because there is no way to export excel on sonarqube(if there is, please let me know how to export excel file), I’m trying to handle my database.

as you can see below picture,

sonar
sonar1099×547 372 KB

I couldn’t interpret that data(mostly ~_UUID). It seems like be encrypted.

I just wanted to make some report(excel files) about the result of inspection my solutions.

How can I handle this?

2

Greetings,

The SonarQube database should be considered a black-box: the schema isn’t publicly documented and could change between versions without warning.

To get data out of SonarQube into another format, you should use the Web API (documentation linked in the footer of your instance). That being said – we believe the best place to view SonarQube results is in SonarQube itself, where the information has all the necessary context and is actionable.