---
title: "Application Devices"
slug: "application-devices-1"
updated: 2026-10-22T15:21:47Z
published: 2026-10-22T15:21:47Z
canonical: "docs.databee.buzz/application-devices-1"
---

> ## 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.

# Application Devices

## Purpose

The Application Devices CDP is a mapping table and should be used to join devices to the applications installed. The CDP is ideal for answering questions of which devices are currently running the application or have done so in the past.

## Understanding the Table

A new row will be created in the database for each unique combination of `application_id` and `device_id`. This ensures that every distinct pairing of applications and devices is accounted for and tracked individually.

To determine if an application is active, you should use the `last_seen_time` along with a specified time range. This method is particularly useful when the `end_time` is not captured or available.

## [Schema](/user-manual/docs/application-devices)

## Example Queries

Find all records for a given device or application id

```pgsql
SELECT * FROM application_devices where end_date is null and device_id = {id}
```

```pgsql
SELECT * FROM application_devices where end_date is null and application_id = {id}
```

Find all active entities and their latest row

```pgsql
SELECT * FROM application_devices WHERE end_time is null
```

## CDP Data Dictionary

| **Caption** | **Name** | **Requirement** | **Type** | **Description** |
| --- | --- | --- | --- | --- |
| Device ID | device_id | required | integer_t | ApplicationLifecycle.device_id: This is the id that DataBee uses to link this to a specific device. ApplicationLifecycle.start_time: The start time of a time period, or the time of the least recent event included in the aggregate event. ApplicationLifecycle.end_time: The end time of a time period, or the time of the most recent event included in the aggregate event. ApplicationLifecycle.time: The normalized event occurrence time. For example: `1618524549901` |
| End Time | end_time | optional | timestamp_t | ApplicationLifecycle.device_id: This is the id that DataBee uses to link this to a specific device. ApplicationLifecycle.start_time: The start time of a time period, or the time of the least recent event included in the aggregate event. ApplicationLifecycle.end_time: The end time of a time period, or the time of the most recent event included in the aggregate event. ApplicationLifecycle.time: The normalized event occurrence time. For example: `1618524549901`. |
| First Seen Time | first_seen_time | optional | timestamp_t | ApplicationLifecycle.device_id: This is the id that DataBee uses to link this to a specific device. ApplicationLifecycle.start_time: The start time of a time period, or the time of the least recent event included in the aggregate event. ApplicationLifecycle.end_time: The end time of a time period, or the time of the most recent event included in the aggregate event. ApplicationLifecycle.time: The normalized event occurrence time. For example: `1618524549901`. |
| ID | 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. ApplicationLifecycle.device_id: This is the id that DataBee uses to link this to a specific device. ApplicationLifecycle.start_time: The start time of a time period, or the time of the least recent event included in the aggregate event. ApplicationLifecycle.end_time: The end time of a time period, or the time of the most recent event included in the aggregate event. ApplicationLifecycle.time: The normalized event occurrence time. For example: `1618524549901`. |
| Last Seen Time | last_seen_time | optional | timestamp_t | ApplicationLifecycle.device_id: This is the id that DataBee uses to link this to a specific device. ApplicationLifecycle.start_time: The start time of a time period, or the time of the least recent event included in the aggregate event. ApplicationLifecycle.end_time: The end time of a time period, or the time of the most recent event included in the aggregate event. ApplicationLifecycle.time: The normalized event occurrence time. For example: `1618524549901`. |
| 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. |
| Start Time | start_time | optional | timestamp_t | ApplicationLifecycle.device_id: This is the id that DataBee uses to link this to a specific device. ApplicationLifecycle.start_time: The start time of a time period, or the time of the least recent event included in the aggregate event. ApplicationLifecycle.end_time: The end time of a time period, or the time of the most recent event included in the aggregate event. ApplicationLifecycle.time: The normalized event occurrence time. For example: `1618524549901`. |