Fivetran documentation

Search the docs

/

Kandji

Explore the interactive ERD

Table & Field Reference

device_activity

Column	Type	Keys
`id`	Unknown	PK
`blueprint_id`	Unknown	FK
`device_id`	Unknown	FK
`action_type`	Unknown
`blueprint_is_removed`	Unknown
`computer_is_removed`	Unknown
`created_at`	Unknown
`detail_attempt`	Unknown
`detail_command_type`	Unknown
`detail_date_completed`	Unknown
`detail_date_requested`	Unknown
`detail_error_chain`	Json
`detail_is_silent`	Unknown
`detail_last_pushed`	Unknown
`detail_metadata`	Json
`detail_priority`	Unknown
`detail_profile_name`	Unknown
`detail_profile_uuid`	Unknown
`detail_request_requires_network_tether`	Unknown
`detail_request_type`	Unknown
`detail_skip_retry`	Unknown
`detail_status`	Unknown
`detail_user`	Unknown
`detail_username`	Unknown
`detail_uuid`	Unknown
`external_token`	Unknown
`users`	Unknown

device_app

Column	Type	Keys
`id`	Unknown	PK
`device_id`	Unknown	FK
`app_name`	Unknown
`app_store_vendable`	String
`bundle_id`	Unknown
`bundle_size`	Unknown
`creation_date`	Unknown
`device_based_vpp`	String
`modification_date`	Unknown
`path`	Unknown
`process`	Unknown
`signature`	Unknown
`source`	Unknown
`version`	Unknown

device_library_item

Column	Type	Keys
`id`	Unknown	PK
`blueprint_id`	Unknown	FK
`device_id`	Unknown	FK
`control_log`	Unknown
`control_reported_at`	Unknown
`item_id`	Unknown
`last_audit_log`	Unknown
`last_audit_run`	Unknown
`log`	Unknown
`name`	Unknown
`reported_at`	Unknown
`rules_present`	Unknown
`status`	Unknown
`type`	Unknown

device

Column	Type	Keys
`id`	Unknown	PK
`blueprint_id`	Unknown	FK
`agent_installed`	Unknown
`agent_version`	Unknown
`asset_tag`	Unknown
`first_enrollment`	Unknown
`is_missing`	Unknown
`is_removed`	Unknown
`last_check_in`	Unknown
`last_enrollment`	Unknown
`lost_mode_status`	String
`mdm_enabled`	Unknown
`model`	Unknown
`name`	Unknown
`os_version`	Unknown
`platform`	Unknown
`serial_number`	Unknown
`user_email`	Unknown
`user_id`	Unknown
`user_is_archived`	Unknown
`user_name`	Unknown

blueprint

Column	Type	Keys
`id`	Unknown	PK
`color`	Unknown
`computers_count`	Unknown
`description`	Unknown
`enrollment_code`	Unknown
`enrollment_is_active`	Unknown
`icon`	Unknown
`missing_computers_count`	Long
`name`	Unknown
`param_`

mdm_device

Column	Type	Keys
`id`	Unknown	PK
`device_associated_token_id`	Unknown	PKFK
`deferred_install`	Unknown
`enrolled_at`	Unknown
`enrollment_status`	Unknown
`is_missing`	Unknown
`is_removed`	Unknown
`name`	Unknown
`status`	Unknown

device_associated_token

Column	Type	Keys
`id`	Unknown	PK
`blueprint_id`	Unknown	FK
`list_ade_id`	Unknown	FK
`asset_tag`	Unknown
`assignment_status_received_at`	Unknown
`color`	Unknown
`dep_account_id`	Unknown
`dep_account_server_name`	Unknown
`description`	Unknown
`device_assigned_by`	Unknown
`device_assigned_date`	Unknown
`device_family`	Unknown
`failed_assignment_attempts`	Unknown
`last_assignment_status`	Unknown
`model`	Unknown
`os`	Unknown
`profile_assign_time`	Unknown
`profile_push_time`	Unknown
`profile_status`	Unknown
`serial_number`	Unknown
`users`	Unknown

device_parameter

Column	Type	Keys
`id`	Unknown	PK
`device_id`	Unknown	FK
`category`	Unknown
`name`	Unknown
`status`	Unknown
`subcategory`	Unknown

list_ade

Column	Type	Keys
`id`	Unknown	PK
`access_token_expiry`	Unknown
`admin_id`	Unknown
`blueprint_id`	Unknown
`days_left`	Unknown
`default_email`	Unknown
`default_phone`	Unknown
`device_count_apple_tv`	Long
`device_count_ipad`	Unknown
`device_count_iphone`	Unknown
`device_count_mac`	Unknown
`device_count_total`	Unknown
`last_device_sync`	Unknown
`organization_address`	Unknown
`organization_email`	Unknown
`organization_name`	Unknown
`organization_phone`	Unknown
`organization_type`	Unknown
`server_name`	Unknown
`server_uuid`	Unknown
`status`	Unknown
`status_reason`	String
`status_received_at`	Unknown
`stoken_file_name`	Unknown

blueprint_result_template

Column	Type	Keys
`id`	Unknown	PK
`blueprint_result_id`	Unknown	PKFK
`category`	Unknown
`color`	Unknown
`description`	Unknown
`icon`	Unknown
`name`	Unknown
`rating`	Unknown
`param_`

blueprint_result

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`weight`	Unknown