Cyber Vulnerabilities

Prev Next

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: 1618524549901

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 <https://cve.mitre.org/>_).

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 <https://cve.mitre.org/>_).

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 <https://cve.mitre.org/>_).

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 <https://cve.mitre.org/>_).

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 <https://cve.mitre.org/>_).

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 (CVE <https://cve.mitre.org/>_).

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: 2013.1.3-beta. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.name: The name of the product. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.uid: The unique identifier of the product.

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.

Copyright © 2026 DataBee®, A Comcast Company.
DataBee® is a registered trademark of Comcast.