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

Example Queries

Find all records for a given device or application id

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

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

Find all active entities and their latest row

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