FEAT: Create devskim.yml (microsoft#87)

sumitmsft · bewithgaurav · web-flow · commit 5be3614f541b · 2025-06-24T10:41:20.000+05:30
### Summary This pull request introduces a new GitHub Actions workflow to integrate the DevSkim static analysis tool into the CI/CD pipeline. The workflow is designed to scan code for security issues and upload the results to the GitHub Security tab. ### New Workflow Integration: * [`.github/workflows/devskim.yml`](diffhunk://#diff-cf9c7e0ae50cd2d73f48fc95d5f4784c87b4932f23c9bf60f2223ef12262c4cdR1-R34): Added a new workflow named "DevSkim" that runs on `push` and `pull_request` events for the `main` branch, as well as on a weekly schedule. It uses the `microsoft/DevSkim-Action` to perform security scans and uploads the results in SARIF format using the `github/codeql-action/upload-sarif` action. ### Issue Reference Fixes: [AB#37674](https://sqlclientdrivers.visualstudio.com/c6d89619-62de-46a0-8b46-70b92a84d85e/_workitems/edit/37674) Co-authored-by: Gaurav Sharma <sharmag@microsoft.com>
diff --git a/.github/workflows/devskim.yml b/.github/workflows/devskim.yml
@@ -0,0 +1,34 @@
+# This workflow uses actions that are not certified by GitHub.
+# They are provided by a third-party and are governed by
+# separate terms of service, privacy policy, and support
+# documentation.
+
+name: DevSkim
+
+on:
+  push:
+    branches: [ "main" ]
+  pull_request:
+    branches: [ "main" ]
+  schedule:
+    - cron: '44 7 * * 5'
+
+jobs:
+  lint:
+    name: DevSkim
+    runs-on: ubuntu-latest
+    permissions:
+      actions: read
+      contents: read
+      security-events: write
+    steps:
+      - name: Checkout code
+        uses: actions/checkout@v4
+
+      - name: Run DevSkim scanner
+        uses: microsoft/DevSkim-Action@v1
+
+      - name: Upload DevSkim scan results to GitHub Security tab
+        uses: github/codeql-action/upload-sarif@v3
+        with:
+          sarif_file: devskim-results.sarif
