CodeScanningAlertInstances
Lists all code locations where a specific code scanning alert occurs.
View-Specific Information
Select
The connector uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- AlertNumber supports the '=,IN' comparison operators.
- Ref supports the '=' comparison operator.
- PullRequestNumber supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [CodeScanningAlertInstances]
SELECT * FROM [CodeScanningAlertInstances] WHERE [AlertNumber] = 123
SELECT * FROM [CodeScanningAlertInstances] WHERE [Ref] = 'Val1'
SELECT * FROM [CodeScanningAlertInstances] WHERE [PullRequestNumber] = 123
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | OrderBySupport | Description |
| AlertNumber | Int |
CodeScanningAlerts.Number | The security alert number. | |
| Ref | String | The Git reference (e.g., refs/heads/main, refs/pull/123/merge). | ||
| AnalysisKey | String | Identifies the configuration under which the analysis was executed (e.g., workflow filename and job name). | ||
| Environment | String | Identifies the variable values associated with the environment (e.g., language analyzed). | ||
| Category | String | Identifies the configuration under which the analysis was executed (e.g., language or code section). | ||
| State | String | State of this instance. | ||
| CommitSha | String | The commit SHA where this instance was detected. | ||
| MessageText | String | The message text associated with this instance. | ||
| LocationPath | String | The file path where the alert was detected. | ||
| LocationStartLine | Int | Line number at which the alert starts in the file. | ||
| LocationEndLine | Int | Line number at which the alert ends in the file. | ||
| LocationStartColumn | Int | Column at which the alert starts in the file. | ||
| LocationEndColumn | Int | Column at which the alert ends in the file. | ||
| HtmlUrl | String | The GitHub URL of this instance. | ||
| Classifications | String | Classifications applied to the file (e.g., source, generated, test, library). | ||
| PullRequestNumber | Int | The number of the pull request for the results you want to list. |