Once you have setup your SonarQube servers, you just need to use the SonarQube Connector CWE Top 25 Macro, with this Macro you will display Top 25 Most Dangerous Software Weaknesses list for configured projects.
You have to complete these parameters:
...