Software Application Owners

Purpose

The Application Owners CDP is a mapping table and should be used to join users to the applications they manage. Users can have different relationships to Applications 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 an Application depending on the use case.

Understanding the Table

The table is structured with application_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 application_id, key, and value.

Use the last_seen_time and a time range along with checking if end_time is null to determine if a user is still responsible for a given application.

Schema

Example Queries

Find all records for a given user or application id

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

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