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}