Device Owners

Purpose

The Device Owners CDP is a mapping table and should be used to join users to devices. Users can have different relationships to a device from business owner, IT owner, asset owner, finance owner, etc. The CDP is ideal for answering questions of who the point of contact is for a device depending on the use case.

Understanding the Table

The table is structured with device_id as the main row identifier, the key representing the relationship type (BU, IT, ORG_Owner), and the value being the user_id that correlates with the relationship type.

A new row will be created for each unique set of device_id, key, and value

Check if end_time is null to determine if a user is still responsible for a given device.

Joining to CDPs and OCSF

Device_id and value should be used to join against other CDPs.

Schema

Example Queries

Find all records for a given user or device id

SELECT * FROM device_owner where end_date is null and value = {id} 

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