SecurityAdvisories
Lists GitHub Security Advisories.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- Id supports the '=,IN' comparison operators.
- GhsaId supports the '=,IN' comparison operators.
- Classification supports the '=,IN' comparison operators.
- EpssPercentage supports the '=' comparison operator.
- EpssPercentile supports the '=' comparison operator.
- PublishedAt supports the '>' comparison operator.
- UpdatedAt supports the '>' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [SecurityAdvisories]
SELECT * FROM [SecurityAdvisories] WHERE [Id] = 'Val1'
SELECT * FROM [SecurityAdvisories] WHERE [GhsaId] = 'Val1'
SELECT * FROM [SecurityAdvisories] WHERE [Classification] = 'GENERAL'
SELECT * FROM [SecurityAdvisories] WHERE [EpssPercentage] = 123
SELECT * FROM [SecurityAdvisories] WHERE [EpssPercentile] = 123
SELECT * FROM [SecurityAdvisories] WHERE [PublishedAt] > '2023-01-01 11:10:00'
SELECT * FROM [SecurityAdvisories] WHERE [UpdatedAt] > '2023-01-01 11:10:00'
The 本製品 processes other filters client-side within the 本製品.
The 本製品 uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:
- EpssPercentage
- EpssPercentile
- PublishedAt
- UpdatedAt
SELECT * FROM [SecurityAdvisories] ORDER BY [EpssPercentage]
SELECT * FROM [SecurityAdvisories] ORDER BY [EpssPercentile]
SELECT * FROM [SecurityAdvisories] ORDER BY [PublishedAt]
SELECT * FROM [SecurityAdvisories] ORDER BY [UpdatedAt]
The 本製品 processes ordering by other columns client-side within the 本製品.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The Node ID of the SecurityAdvisory object. | ||
| DatabaseId | Int | Identifies the primary key from the database. | ||
| GhsaId | String | The GitHub Security Advisory ID. | ||
| Summary | String | A short plaintext summary of the advisory. | ||
| Description | String | A long-form Markdown-supported description of the advisory. | ||
| Origin | String | The organization that originated the advisory. | ||
| Classification | String | The classification of the advisory. | ||
| Identifiers | String | A list of identifiers for this advisory. | ||
| References | String | A list of references for this advisory. | ||
| Permalink | String | The permalink for the advisory. | ||
| NotificationsPermalink | String | The permalink for the advisory's dependabot alerts. | ||
| Severity | String | The severity of the advisory. | ||
| EpssPercentage | Double | The EPSS percentage represents the likelihood of a CVE being exploited. | ||
| EpssPercentile | Double | The EPSS percentile represents the relative rank of the CVE's likelihood of being exploited compared to other CVEs. | ||
| CvssV3Score | Double | The CVSS score associated with this advisory. | ||
| CvssV3VectorString | String | The CVSS vector string associated with this advisory. | ||
| CvssV4Score | Double | The CVSS score associated with this advisory. | ||
| CvssV4VectorString | String | The CVSS vector string associated with this advisory. | ||
| PublishedAt | Datetime | When the advisory was published. | ||
| UpdatedAt | Datetime | When the advisory was last updated. | ||
| WithdrawnAt | Datetime | When the advisory was withdrawn, if it has been withdrawn. |