SecretScanningAlertLocations
Lists all locations where a secret scanning alert was detected.
View-Specific Information
Select
The connector uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- AlertNumber supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [SecretScanningAlertLocations]
SELECT * FROM [SecretScanningAlertLocations] WHERE [AlertNumber] = 123
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | OrderBySupport | Description |
| AlertNumber | Int |
SecretScanningAlerts.Number | The security alert number. | |
| Type | String | The location type where the secret was found. | ||
| Path | String | The file path in the repository (for commit and wiki_commit types). | ||
| StartLine | Int | Line number at which the secret starts in the file (for commit and wiki_commit types). | ||
| EndLine | Int | Line number at which the secret ends in the file (for commit and wiki_commit types). | ||
| StartColumn | Int | Column at which the secret starts (for commit and wiki_commit types). | ||
| EndColumn | Int | Column at which the secret ends (for commit and wiki_commit types). | ||
| BlobSha | String | SHA-1 hash ID of the associated blob (for commit and wiki_commit types). | ||
| BlobUrl | String | The API URL to get the associated blob resource (for commit type). | ||
| CommitSha | String | SHA-1 hash ID of the associated commit (for commit and wiki_commit types). | ||
| CommitUrl | String | The API/GitHub URL to get the associated commit resource (for commit and wiki_commit types). | ||
| PageUrl | String | The GitHub URL to get the associated wiki page (for wiki_commit type). | ||
| IssueTitleUrl | String | The API URL to get the issue where the secret was detected (for issue_title type). | ||
| IssueBodyUrl | String | The API URL to get the issue where the secret was detected (for issue_body type). | ||
| IssueCommentUrl | String | The API URL to get the issue comment where the secret was detected (for issue_comment type). | ||
| DiscussionTitleUrl | String | The URL to the discussion where the secret was detected (for discussion_title type). | ||
| DiscussionBodyUrl | String | The URL to the discussion where the secret was detected (for discussion_body type). | ||
| DiscussionCommentUrl | String | The API URL to get the discussion comment where the secret was detected (for discussion_comment type). | ||
| PullRequestTitleUrl | String | The API URL to get the pull request where the secret was detected (for pull_request_title type). | ||
| PullRequestBodyUrl | String | The API URL to get the pull request where the secret was detected (for pull_request_body type). | ||
| PullRequestCommentUrl | String | The API URL to get the pull request comment where the secret was detected (for pull_request_comment type). | ||
| PullRequestReviewUrl | String | The API URL to get the pull request review where the secret was detected (for pull_request_review type). | ||
| PullRequestReviewCommentUrl | String | The API URL to get the pull request review comment where the secret was detected (for pull_request_review_comment type). |