Device Feed

Prev Next

Purpose

The Device Feed CDP contains up-to-date information when a device was first seen and last seen by a particular feed. The Device Feed CDP is ideal for answering questions about when a device was last seen by a feed.

Understanding the Table

The Device Feed CDP contains first_seen and last_seen time stamps. These timestamps indicate when the device (identified by device_id) was last seen by a particular feed and event_type (identified by feed_name and class_uid).

{
	"class_name": "Detection Finding",
	"class_uid": 2004,
	"device_id": 4884720,
	"feed_name": "microsoft_xdr",
	"feed_version": null,
	"first_seen": "2025-11-24T14:13:49.357000",
	"id": 6981552,
	"is_managed": false,
	"last_seen": "2025-12-12T15:17:56.454000",
	"record_created_at": "2025-12-19T06:38:30.884000",
	"record_updated_at": null
}

Joining to CDPs and OCSF

If the security hygiene entitlement is enabled, device_id can be used to join back to OCSF and other CDP tables

Example Queries

Display user_id from all feeds

SELECT * from cdp.device_feed where device_id is <device_id>

CDP Data Dictionary

Caption

Name

Requirement

Type

Description

Class Name

class_name

required

string_t

The class or category of the device feed.

Class UID

class_uid

required

integer_t

The unique identifier for the class or category of the device feed.

Device ID

device_id

required

integer_t

The unique identifier used by DataBee for a specific device. This will be logged as device_id in activity tables to link to a particular device in the Device table.

Event Code

event_code

required

string_t

The event code associated with the device activity in this data feed.

Feed Name

feed_name

required

string_t

The name of the data feed from which the device information was obtained.

Feed Version

feed_version

optional

string_t

The version of the data feed from which the device information was obtained.

First Seen

first_seen

required

timestamp_t

The timestamp when the device was first observed in this data feed.

ID

id

required

integer_t

Auto-incrementing unique identifier for each record.

Is Managed

is_managed

optional

boolean_t

Indicates whether the device is managed by the organization according to this data feed.

Last Seen

last_seen

required

timestamp_t

The timestamp when the device was most recently observed in this data feed.

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.

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