Purpose
The Cyber Vulnerabilities CDP contains up-to-date information on all ongoing vulnerabilities and can be joined to OCSF event tables for historical trend analysis.
Understanding the Table
The Cyber Vulnerability CDP is ideal for answering questions about the status of all ongoing vulnerabilities. This includes understanding which applications are in use, their versions, and the vendors supplying them.
Cyber Vulnerabilities is a Type 1 table. This means that columns are updated directly (overwritten) when new information is ingested.
A row is a unique combination of the following attributes: Vulnerability Finding UID, CVE UID, CVSS Version, and Device ID.
Joining to CDPs and OCSF
The cyber_vulnerability.uid column should be used for all joins back to OCSF. This ensures consistency and accuracy when merging data from different sources. Furthermore, the user_id, device_id, and software_application_id columns can be used to join back to their respective CDPs.
To determine if a cyber vulnerability is currently active, you should use the last_seen_time in combination with a specified time range. Additionally, you need to check the active flag to confirm the status. By utilizing both the last_seen_time and the active flag within the given time range, you can accurately assess the presence and activity of the cyber vulnerability.
Schema
Example Queries
How to join back to OCSF
SELECT * FROM CDP.cyber_vulnerabilities LEFT JOIN OCSF.vulnerability_finding ON CDP.cyber_vulnerabilities.uid = OCSF.vulnerability_finding.finding_info:uid;CDP Data Dictionary
Caption | Name | Requirement | Type | Description |
|---|---|---|---|---|
Event Time | active | required | boolean_t | VulnerabilityFinding.time: The normalized event occurrence time. For example: |
CVE Base Score | cve_cvss_base_score | recommended | float_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.cve: The Common Vulnerabilities and Exposures ( |
CVE Severity | cve_cvss_severity | recommended | string_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.cve: The Common Vulnerabilities and Exposures ( |
CVE Version | cve_cvss_version | recommended | string_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.cve: The Common Vulnerabilities and Exposures ( |
CVE Description | cve_description | optional | string_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.cve: The Common Vulnerabilities and Exposures (CVE). Cve.desc: A brief description of the CVE Record. |
CVE References | cve_references | recommended | string_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.cve: The Common Vulnerabilities and Exposures (CVE). Cve.references: A list of reference URLs with additional information about the CVE Record. |
CVE Type | cve_type | recommended | string_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.cve: The Common Vulnerabilities and Exposures ( |
CVE UID | cve_uid | required | string_t | SecurityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.cve: The Common Vulnerabilities and Exposures ( |
CVE Exploitation Status | exploitation_status | recommended | string_t | Vulnerability.cve: The observed exploitation status of the CVE (SSVC "Exploitation" decision point). |
CISA KEV | kev | recommended | kev | Vulnerability.cve: Details from the CISA Known Exploited Vulnerabilities (KEV) catalog, if the CVE is listed, including KEV date added, remediation due date, and whether the CVE is currently listed. |
Device ID | device_id | required | integer_t | VulnerabilityFinding.device_id: This is the id that DataBee uses to link this to a specific device. |
First Seen Time | first_seen_time | optional | timestamp_t | VulnerabilityFinding.start_time: The time of the least recent event included in the finding. |
ID | id | required | integer_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.cve: The Common Vulnerabilities and Exposures ( |
Last Seen Time | last_seen_time | optional | timestamp_t | VulnerabilityFinding.end_time: The time of the most recent event included in the finding. |
Exploit Available | is_exploit_available | optional | boolean_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.is_exploit_available: Indicates if an exploit or a PoC (proof-of-concept) is available for the reported vulnerability. |
Record Created At | record_created_at | required | timestamp_t | CDPs generated timestamp when record was created. |
Record Updated At | record_updated_at | required | timestamp_t | CDPs generated timestamp when record was last updated. |
Application ID | software_application_id | required | integer_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.vendor_name: The name of the vendor of the product. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.version: The version of the product, as defined by the event source. For example: |
Data Sources | sources | required | string_t Array | VulnerabilityFinding.metadata_: The metadata associated with the event or a finding. Metadata.product: The product that reported the event. |
Title | title | required | string_t | VulnerabilityFinding.finding_info: Describes the supporting information about a generated finding. FindingInfo.title: A title or a brief phrase summarizing the reported finding. |
Unique ID | uid | required | string_t | VulnerabilityFinding.finding_info: Describes the supporting information about a generated finding. FindingInfo.uid: The unique identifier of the reported finding. |
User ID | user_id | required | integer_t | VulnerabilityFinding.user_id: This is the id that DataBee uses to link this to a specific user. |
Vendor Description | vendor_description | optional | string_t | VulnerabilityFinding.finding_info: Describes the supporting information about a generated finding. FindingInfo.desc: The description of the reported finding. |
Vendor Type | vendor_type | optional | string_t | VulnerabilityFinding.finding_info: Describes the supporting information about a generated finding. FindingInfo.types_: One or more types of the reported finding. |
Severity | vulnerability_severity | optional | string_t | VulnerabilityFinding.vulnerabilities: This object describes vulnerabilities reported in a security finding. Vulnerability.severity: The Common Vulnerability Scoring System (CVSS) Qualitative Severity Rating. A textual representation of the numeric score. |
Status | status | optional | string_t | VulnerabilityFinding.finding_info: Describes the supporting information about a generated finding. FindingInfo.status: The normalized remediation status of the vulnerability finding (for example, open or resolved). |
Due Date | due_date | optional | timestamp_t | VulnerabilityFinding.remediation: Describes the remediation recommendations for the finding. Remediation.due_date: The date by which the vulnerability is due to be remediated. |
Fix Available Date | fix_available_date | optional | timestamp_t | VulnerabilityFinding.remediation: Describes the remediation recommendations for the finding. Remediation.fix_available_date: The date a fix became available from the vendor for the reported vulnerability. |
Remediated Date | remediated_date | optional | timestamp_t | VulnerabilityFinding.remediation: Describes the remediation recommendations for the finding. Remediation.remediated_date: The date the vulnerability finding was remediated. |
Vendor ID | vendor_id | optional | string_t | VulnerabilityFinding.finding_info: Describes the supporting information about a generated finding. FindingInfo.vendor_id: The vendor-assigned advisory or identifier associated with the reported vulnerability. |