# Need help with GitHub, AppVeyor and T-SQL

**URL:** <https://community.sonarsource.com/t/need-help-with-github-appveyor-and-t-sql/43126>\
**Category:** SonarQube Cloud\
**Created:** [May 11, 2021, 6:49pm UTC](https://community.sonarsource.com/t/need-help-with-github-appveyor-and-t-sql/43126 "2021-05-11T18:49:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![marcingminski](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/marcingminski/32/22144_2.png) [@marcingminski](https://community.sonarsource.com/u/marcingminski)\
**Post date:** [May 11, 2021, 6:49pm UTC](https://community.sonarsource.com/t/need-help-with-github-appveyor-and-t-sql/43126/1 "2021-05-11T18:49:21Z")

</div>

Hi, I have a public Open-Source T-SQL and C# projects hosted on GitHub which I would like to analyse in [sonarcloud.io](http://sonarcloud.io).  
I have read the documentation and understand that the automated analysis is not possible with C# and T-SQL. I have had a look at the CLI tools but also not sure whether I should trigger them from my AppVeyor build (Windows VM) or via GitHub Actions.  
I have created a GitHub action but it does not seem to be doing much. So far, the SonarCloud only lists 14 CSS and XML files in total in my Project.

I have also changed the file association and added .sql to T-SQL analyser and removed .sql from the PL/SQL analysers.

The GitHub Project is here: [marcingminski/sqlwatch: SQL Server Performance Monitor (github.com)](https://github.com/marcingminski/sqlwatch)

I have also added [sonar-project.properties](https://github.com/marcingminski/sqlwatch/blob/main/sonar-project.properties)

Link to the Sonar project (public) [sqlwatch - Marcin Gminski (sonarcloud.io)](https://sonarcloud.io/dashboard?id=marcingminski_sqlwatch)

I am a little stuck, any help appreciated. Just FYI I did read the docs and even Googled solutions, but I guess just need a little push into the right direction.

---

<div class="post-metadata">

**Author:** ![janos](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/janos/32/60_2.png) [@janos](https://community.sonarsource.com/u/janos)\
**Post date:** [May 18, 2021, 4:35pm UTC](https://community.sonarsource.com/t/need-help-with-github-appveyor-and-t-sql/43126/3 "2021-05-18T16:35:55Z")

</div>

Welcome to the community! Thank you for the detailed info, very nice first post!

Looking at your project on SonarCloud, I see no source files at all on the main branch and on the few pull requests I opened randomly… This means that the scanner could not find any files to analyze. Getting the right files included in the analysis usually comes down to using the correct scanner, and its configuration. The latter is explained on our [Narrowing the Focus](https://sonarcloud.io/documentation/project-administration/narrowing-the-focus/) page, but I think your real issue is actually with the scanner.

> [@marcingminski](#):
>
> I have had a look at the CLI tools but also not sure whether I should trigger them from my AppVeyor build (Windows VM) or via GitHub Actions.

Where you run the scanner doesn’t matter much from the perspective of SonarCloud. Both should work. But you must use the right scanner.

It looks like you are using the [Sonar Scanner for CLI](https://sonarcloud.io/documentation/analysis/scan/sonarscanner/). This is a generic tool that’s suitable for many cases. C# is a bit more tricky to analyze than other languages, and for it we have a dedicated tool, [SonarScanner for .NET](https://sonarcloud.io/documentation/analysis/scan/sonarscanner-for-msbuild/). Please try using that instead. I think this should get you a bit further. Let us know if you get stuck!

---

<div class="post-metadata">

**Author:** ![marcingminski](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/marcingminski/32/22144_2.png) [@marcingminski](https://community.sonarsource.com/u/marcingminski)\
**Post date:** [May 18, 2021, 4:49pm UTC](https://community.sonarsource.com/t/need-help-with-github-appveyor-and-t-sql/43126/5 "2021-05-18T16:49:08Z")

</div>

but how do I tell it what files to scan? The file inclusion is set to \*

 ![image](https://europe1.discourse-cdn.com/sonarsource/uploads/sonarcommunity/original/3X/f/e/feaec1fe0ffb6f6d808b9b551f6ed332c587d947.png)

---

<div class="post-metadata">

**Author:** ![janos](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/janos/32/60_2.png) [@janos](https://community.sonarsource.com/u/janos)\
**Post date:** [May 19, 2021, 8:04am UTC](https://community.sonarsource.com/t/need-help-with-github-appveyor-and-t-sql/43126/6 "2021-05-19T08:04:10Z")

</div>

When using the SonarScanner for .NET, it should pick up the necessary settings about files to include or exclude based on the .NET project meta data. When using this flavor of the scanner, you should not need to adjust these settings.

When using the Scanner for CLI, it’s not that the files are not included, but the .NET analyzer does not get executed at all, that’s why you don’t see results about relevant files.
