Hi Team, I finally managed to solve this issue. It seems like the issue lies with the NodeJS installation.
When installing NodeJS, there is a checkbox to Install Additional Tools (Visual studio add-ons, python, npx, etc.) which is not selected by default. If this checkbox is not selected, then I find that the SonarQube Lint does not work as expected. But if this checkbox is selected, then it does work.
I came across the issue again when setting up a Brand new PC, where the Sonarqube Lint wasn’t working again. And after sitting around I reinstalled everything again but then noticed this checkbox which sorted everything out