title: Sonarqube DB Queries - How to find new issues?
body: <p>I need to find all the issues discovered in a snapshot/scan in Sonarqube. I can't use the web API since the volume can be excessive for new projects on first scan. I have a query that can find the latest snapshot with the project information. I can query issues by project. I can't figure out how to relate issues to a snapshot. There has to be a way since Sonarqube does it - New issues on the Project page. </p>
  
  <p>Has anyone done this or have enough experience with the crazy schema to be able to figure it out? Can't wait for the schema rationalization...</p>
  
  <p>Sonarqube 5.6.3 on Windows 2012 R2 with SQL Server 2012. </p>