--- title: "Device Feed" slug: "device-feed" updated: 2026-10-22T15:25:00Z published: 2026-10-22T15:25:00Z canonical: "docs.databee.buzz/device-feed" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.databee.buzz/llms.txt > Use this file to discover all available pages before exploring further. # Device Feed ## 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). ```json { "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 ```pgsql SELECT * from cdp.device_feed where device_id is ``` ## 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. |