Jamf

Explore the interactive ERD

Table & Field Reference

device_enrollment

Column	Type	Keys
`id`	Unknown	PK
`supervision_identity_id`	Unknown	FK
`admin_id`	Unknown
`name`	Unknown
`org_address`	Unknown
`org_email`	Unknown
`org_name`	Unknown
`org_phone`	Unknown
`server_name`	Unknown
`server_uuid`	Unknown
`site_id`	Unknown
`token_expiration_date`	Unknown

startup_status

Column	Type	Keys
`_fivetran_id`	String	PK
`error`	Unknown
`error_code`	Unknown
`percentage`	Unknown
`setup_assistant_necessary`	Unknown
`step`	Unknown
`step_code`	Unknown
`step_param`	Unknown
`warning`	Unknown
`warning_code`	Unknown
`warning_param`	Unknown

sso_history_object

Column	Type	Keys
`id`	Unknown	PK
`date`	Instant
`details`	Unknown
`note`	Unknown
`username`	Unknown

server_configuration

Column	Type	Keys
`id`	Unknown	PK
`mapping_user_id`	Unknown	FK
`deprecated_consent`	Unknown
`enabled`	Unknown
`membership_calculation_optimization_enabled`	Unknown
`migrated`	Unknown
`search_timeout`	Unknown
`tenant_id`	Unknown
`transitive_directory_membership_enabled`	Unknown
`transitive_membership_enabled`	Unknown
`transitive_membership_user_field`	Unknown

sso_host

Column	Type	Keys
`index`	Unknown	PK
`sso_id`	Unknown	PKFK
`host`	Unknown

sso

Column	Type	Keys
`id`	Unknown	PK
`enrollment_sso_for_account_driven_enrollment_enabled`	Unknown
`federation_metadata_file`	Unknown
`group_attribute_name`	Unknown
`group_enrollment_access_enabled`	Unknown
`group_enrollment_access_name`	Unknown
`group_rdn_key`	Unknown
`idp_provider_type`	Unknown
`idp_url`	Unknown
`management_hint`	Unknown
`metadata_file_name`	Unknown
`metadata_source`	Unknown
`other_provider_type_name`	Unknown
`session_timeout`	Unknown
`sso_bypass_allowed`	Unknown
`sso_enabled`	Unknown
`sso_for_enrollment_enabled`	Unknown
`sso_for_mac_os_self_service_enabled`	Unknown
`token_expiration_disabled`	Unknown
`user_attribute_enabled`	Unknown
`user_attribute_name`	Unknown
`user_mapping`	Unknown

mobile_device_group

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

app_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`app_store_locale`	Unknown
`approver_email`	Json
`is_enabled`	Unknown
`requester_user_group_id`	Unknown

cloud_identity

Column	Type	Keys
`id`	Unknown	PK
`display_name`	Unknown
`enabled`	Unknown
`provider_name`	Unknown

computer_inventory_capable_user

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`users`	Unknown

computer_inventory_cache_detail

Column	Type	Keys
`id`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`category_name`	Unknown
`disk_space_bytes_used`	Unknown

computer_inventory_alert

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`cache_bytes_limit`	Unknown
`class_name`	Unknown
`path_preventing_access`	Unknown
`post_date`	Unknown
`reserved_volume_bytes`	Unknown
`resource`	Unknown

computer_value

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_extension_index`	Unknown	PKFK
`computer_inventory_id`	Unknown	PKFK
`value`	Unknown

computer_option

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_extension_index`	Unknown	PKFK
`computer_inventory_id`	Unknown	PKFK
`option`	Unknown

computer_inventory_extension

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`data_type`	Unknown
`definition_id`	Unknown
`description`	Unknown
`enabled`	Unknown
`input_type`	Unknown
`multi_value`	Unknown
`name`	Unknown

computer_inventory_parent_local_network

Column	Type	Keys
`id`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`computer_inventory_parent_id`	Unknown	PKFK
`speed`	Unknown
`wired`	Unknown

computer_inventory_parent

Column	Type	Keys
`id`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`address`	Unknown
`alert_addresses`	Json
`alert_class_name`	Unknown
`alert_content_caching_parent_alert_id`	Unknown
`alert_post_date`	Unknown
`detail_ac_power`	Unknown
`detail_cache_size_bytes`	Unknown
`detail_capability_content_caching_parent_capabilities_id`	Unknown
`detail_capability_imports`	Unknown
`detail_capability_name_space`	Unknown
`detail_capability_personal_content`	Unknown
`detail_capability_prioritization`	Unknown
`detail_capability_query_parameter`	Unknown
`detail_capability_shared_content`	Unknown
`detail_content_caching_parent_details_id`	Unknown
`detail_portable`	Unknown
`guid`	Unknown
`healthy`	Unknown
`port`	Unknown
`version`	Unknown

computer_inventory_software_update

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`name`	Unknown
`package_name`	Unknown
`version`	Unknown

computer_inventory_attachment

Column	Type	Keys
`id`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`file_type`	Unknown
`name`	Unknown
`size_byte`	Unknown

computer_inventory_ibeacon

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`name`	Unknown

computer_inventory_licensed_software

Column	Type	Keys
`id`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`name`	Unknown

computer_inventory_font

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`name`	Unknown
`path`	Unknown
`version`	Unknown

computer_inventory_plugin

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`name`	Unknown
`path`	Unknown
`version`	Unknown

computer_inventory_certificate

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`certificate_status`	Unknown
`common_name`	Unknown
`expiration_date`	Unknown
`identities`	Unknown
`issued_date`	Unknown
`lifecycle_status`	Unknown
`serial_number`	Unknown
`sha_1_fingerprint`	Unknown
`subject_name`	Unknown
`username`	Unknown

computer_inventory_local_user_account

Column	Type	Keys
`id`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`admin`	Unknown
`azure_active_directory_id`	Unknown
`computer_azure_active_directory_id`	Unknown
`file_vault_2_enabled`	Unknown
`full_name`	Unknown
`home_directory`	Unknown
`home_directory_size_mb`	Unknown
`password_history_depth`	Unknown
`password_max_age`	Unknown
`password_min_complex_character`	Unknown
`password_min_length`	Unknown
`password_require_alphanumeric`	Unknown
`user_account_type`	Unknown
`user_azure_active_directory_id`	Unknown
`user_guid`	Unknown
`username`	Unknown

computer_inventory_service

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`name`	Unknown

computer_inventory_printer

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`location`	Unknown
`name`	Unknown
`type`	Unknown
`uri`	Unknown

computer_inventory_configuration_profile

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`display_name`	Unknown
`id`	Unknown
`last_installed`	Unknown
`profile_identifier`	Unknown
`removable`	Unknown
`username`	Unknown

computer_inventory_disk_portition

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_disk_id`	Unknown	PKFK
`computer_inventory_id`	Unknown	PKFK
`available_mega`	Unknown
`bytes`	Unknown
`file_vault_2_progress_percent`	Unknown
`file_vault_2_state`	Unknown
`lvm_managed`	Unknown
`name`	Unknown
`partition_type`	Unknown
`percent_used`	Unknown
`size_mega_bytes`	Unknown

computer_inventory_disk

Column	Type	Keys
`id`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`device`	Unknown
`model`	Unknown
`revision`	Unknown
`serial_number`	Unknown
`size_mega_bytes`	Unknown
`smart_status`	Unknown
`type`	Unknown

computer_inventory_application

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`bundle_id`	Unknown
`external_version_id`	Unknown
`mac_app_store`	Unknown
`name`	Unknown
`path`	Unknown
`size_megabytes`	Unknown
`update_available`	Unknown
`version`	Unknown

computer_inventory_file_vault

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`file_vault_2_enabled_user_name`	Unknown

computer_inventory_group_membership

Column	Type	Keys
`computer_inventory_id`	Unknown	PKFK
`id`	Unknown	PKFK
`group_name`	Unknown
`smart_group`	Unknown

computer_inventory_content_caching_data_migration_user_info

Column	Type	Keys
`index`	Unknown	PK
`computer_inventory_id`	Unknown	PKFK
`key`	Unknown
`value`	Unknown

computer_inventory

Column	Type	Keys
`id`	Unknown	PK
`asset_tag`	Unknown
`barcode_1`	Unknown
`barcode_2`	Unknown
`boot_partition_encryption_detail_partition_file_vault_2_percent`	Unknown
`boot_partition_encryption_detail_partition_file_vault_2_state`	Unknown
`boot_partition_encryption_detail_partition_name`	Unknown
`content_cache_activated`	Unknown
`content_cache_active`	Unknown
`content_cache_actual_cache_bytes_used`	Unknown
`content_cache_bytes_free`	Unknown
`content_cache_bytes_limit`	Unknown
`content_cache_bytes_used`	Unknown
`content_cache_computer_content_caching_information_id`	Unknown
`content_cache_data_migration_completed`	Unknown
`content_cache_data_migration_progress_percentage`	Unknown
`content_cache_max_cache_pressure_last_1_hour_percentage`	Unknown
`content_cache_personal_cache_bytes_free`	Unknown
`content_cache_personal_cache_bytes_limit`	Unknown
`content_cache_personal_cache_bytes_used`	Unknown
`content_cache_port`	Unknown
`content_cache_public_address`	Unknown
`content_cache_registration_error`	Unknown
`content_cache_registration_response_code`	Unknown
`content_cache_registration_started`	Unknown
`content_cache_registration_status`	Unknown
`content_cache_restricted_media`	Unknown
`content_cache_server_guid`	Unknown
`content_cache_startup_status`	Unknown
`content_cache_status`	Unknown
`content_cache_tetherator_status`	Unknown
`content_cache_total_bytes_are_since`	Unknown
`content_cache_total_bytes_dropped`	Unknown
`content_cache_total_bytes_imported`	Unknown
`content_cache_total_bytes_returned_to_children`	Unknown
`content_cache_total_bytes_returned_to_client`	Unknown
`content_cache_total_bytes_returned_to_peer`	Unknown
`content_cache_total_bytes_stored_from_origin`	Unknown
`content_cache_total_bytes_stored_from_parent`	Unknown
`content_cache_total_bytes_stored_from_peer`	Unknown
`content_caching_data_migration_error_code`	Unknown
`content_caching_data_migration_error_domain`	Unknown
`declarative_device_management_enabled`	Unknown
`disk_encryption_configuration_name`	Unknown
`disk_encryption_file_vault_2_eligibility_message`	Unknown
`disk_encryption_file_vault_2_enabled`	Unknown
`disk_encryption_individual_recovery_key_validity_status`	Unknown
`disk_encryption_institutional_recovery_key_present`	Unknown
`distribution_point`	Unknown
`enrolled_via_automated_device_enrollment`	Unknown
`general_enrollment_method_id`	Unknown
`general_enrollment_method_object_name`	Unknown
`general_enrollment_method_object_type`	Unknown
`general_mdm_capable`	Unknown
`general_remote_managed`	Unknown
`general_remote_management_username`	Unknown
`hardware_alt_mac_address`	Unknown
`hardware_alt_network_adapter_type`	Unknown
`hardware_apple_silicon`	Unknown
`hardware_battery_capacity_percent`	Unknown
`hardware_ble_capable`	Unknown
`hardware_boot_rom`	Unknown
`hardware_bus_speed_mhz`	Unknown
`hardware_cache_size_kilobytes`	Unknown
`hardware_core_count`	Unknown
`hardware_mac_address`	Unknown
`hardware_make`	Unknown
`hardware_model`	Unknown
`hardware_model_identifier`	Unknown
`hardware_network_adapter_type`	Unknown
`hardware_nic_speed`	Unknown
`hardware_open_ram_slot`	Unknown
`hardware_optical_drive`	Unknown
`hardware_processor_architecture`	Unknown
`hardware_processor_count`	Unknown
`hardware_processor_speed_mhz`	Unknown
`hardware_processor_type`	Unknown
`hardware_serial_number`	Unknown
`hardware_smc_version`	Unknown
`hardware_supports_ios_app_install`	Unknown
`hardware_total_ram_megabytes`	Unknown
`initial_entry_date`	Unknown
`is_leased`	Unknown
`is_purchased`	Unknown
`itunes_store_account_active`	Unknown
`jamf_binary_version`	Unknown
`last_cloud_backup_date`	Unknown
`last_contact_time`	Unknown
`last_enrolled_date`	Unknown
`last_ip_address`	Unknown
`last_reported_ip`	Unknown
`management_id`	Unknown
`mdm_profile_expiration`	Unknown
`name`	Unknown
`operating_system_active_directory_status`	Unknown
`operating_system_build`	Unknown
`operating_system_file_vault_2_status`	Unknown
`operating_system_name`	Unknown
`operating_system_rapid_security_response`	Unknown
`operating_system_software_update_device_id`	Unknown
`operating_system_supplemental_build_version`	Unknown
`operating_system_version`	Unknown
`package_receipt`	Json
`platform`	Unknown
`purchasing_account`	Unknown
`purchasing_apple_care_id`	Unknown
`purchasing_contact`	Unknown
`purchasing_lease_date`	Unknown
`purchasing_life_expectancy`	Unknown
`purchasing_po_date`	Unknown
`purchasing_po_number`	Unknown
`purchasing_price`	Unknown
`purchasing_vendor`	Unknown
`purchasing_warranty_date`	Unknown
`report_date`	Unknown
`security_activation_lock_enabled`	Unknown
`security_attestation_status`	Unknown
`security_auto_login_disabled`	Unknown
`security_bootstrap_token_allowed`	Unknown
`security_bootstrap_token_escrowed_status`	Unknown
`security_external_boot_level`	Unknown
`security_firewall_enabled`	Unknown
`security_gate_keeper_status`	Unknown
`security_last_attestation_attempt`	Unknown
`security_last_successful_attestation`	Unknown
`security_recovery_lock_enabled`	Unknown
`security_remote_desktop_enabled`	Unknown
`security_secure_boot_level`	Unknown
`security_sip_status`	Unknown
`security_x_protect_version`	Unknown
`site_id`	Unknown
`site_name`	Unknown
`storage`	Unknown
`supervised`	Unknown
`udid`	Unknown
`user_and_location_building_id`	Unknown
`user_and_location_department_id`	Unknown
`user_and_location_email`	Unknown
`user_and_location_phone`	Unknown
`user_and_location_position`	Unknown
`user_and_location_realname`	Unknown
`user_and_location_room`	Unknown
`user_and_location_username`	Unknown
`user_approved_mdm`	Unknown

patch_software_title_configuration_extension

Column	Type	Keys
`id`	Unknown	PK
`patch_software_title_configuration_id`	Unknown	PKFK
`accepted`	Unknown

patch_software_title_configuration_package

Column	Type	Keys
`id`	Unknown	PK
`patch_software_title_configuration_id`	Unknown	PKFK
`display_name`	Unknown
`version`	Unknown

patch_software_title_configuration

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	FK
`display_name`	Unknown
`email_notification`	Unknown
`jamf_official`	Unknown
`patch_source_enabled`	Unknown
`patch_source_name`	Unknown
`site_id`	Unknown
`software_title_id`	Unknown
`software_title_name`	Unknown
`software_title_name_id`	Unknown
`software_title_publisher`	Unknown
`ui_notification`	Unknown

mapping

Column	Type	Keys
`user_id`	Unknown	PK
`group_id`	Unknown	FK
`building`	Unknown
`department`	Unknown
`email`	Unknown
`group_name`	Unknown
`phone`	Unknown
`position`	Unknown
`real_name`	Unknown
`room`	Unknown
`user_name`	Unknown

check_in

Column	Type	Keys
`_fivetran_id`	String	PK
`check_in_frequency`	Unknown
`create_hook`	Unknown
`create_startup_script`	Unknown
`enable_local_configuration_profile`	Unknown
`hook_log`	Unknown
`hook_policy`	Unknown
`startup_log`	Unknown
`startup_policy`	Unknown
`startup_ssh`	Unknown

patch_policy_log

Column	Type	Keys
`id`	Unknown	PKFK
`ignored_for_patch_policy_id`	Unknown	FK
`attempt_number`	Unknown
`device_id`	Unknown
`device_name`	Unknown
`status_code`	Unknown
`status_date`	Unknown
`status_enum`	Unknown

mobile_device_object

Column	Type	Keys
`id`	Unknown	PK
`management_id`	Unknown
`model`	Unknown
`model_identifier`	Unknown
`name`	Unknown
`phone_number`	Unknown
`serial_number`	Unknown
`software_update_device_id`	Unknown
`type`	Unknown
`udid`	Unknown
`username`	Unknown
`wifi_mac_address`	Unknown

sso_dependency

Column	Type	Keys
`_fivetran_id`	String	PK
`human_readable_name`	Unknown
`hyperlink`	Unknown
`name`	Unknown

remote_administration_configuration

Column	Type	Keys
`id`	Unknown	PK
`display_name`	Unknown
`site_id`	Unknown
`type`	Unknown

ios_configuration

Column	Type	Keys
`id`	Unknown	PK
`branding_name`	Unknown
`branding_name_color_code`	Unknown
`header_background_color_code`	Unknown
`icon_id`	Unknown
`menu_icon_color_code`	Unknown
`status_bar_text_color`	Unknown

cloud_identity_history

Column	Type	Keys
`id`	Unknown	PKFK
`date`	Instant
`details`	Unknown
`note`	Unknown
`username`	Unknown

check_in_history

Column	Type	Keys
`id`	Unknown	PK
`date`	Instant
`details`	Unknown
`note`	Unknown
`username`	Unknown

re_enrollment_object

Column	Type	Keys
`_fivetran_id`	String	PK
`flush_mdm_queue`	Unknown
`is_flush_extension_attributes_enabled`	Unknown
`is_flush_location_information_enabled`	Unknown
`is_flush_location_information_history_enabled`	Unknown
`is_flush_policy_history_enabled`	Unknown

static_group

Column	Type	Keys
`id`	Unknown	PK
`count`	Unknown
`group_name`	Unknown
`site_id`	Unknown

enrollment_customization

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`display_name`	Unknown
`enrollment_customization_branding_setting_background_color`	Unknown
`enrollment_customization_branding_setting_button_color`	Unknown
`enrollment_customization_branding_setting_button_text_color`	Unknown
`enrollment_customization_branding_setting_icon_url`	Unknown
`enrollment_customization_branding_setting_text_color`	Unknown
`site_id`	Unknown

computer

Column	Type	Keys
`id`	Unknown	PK
`asset_tag`	Unknown
`ip_address`	Unknown
`is_managed`	Unknown
`last_contact_date`	Unknown
`last_enrolled_date`	Unknown
`last_report_date`	Instant
`location_building`	Unknown
`location_department`	Unknown
`location_email_address`	Unknown
`location_phone_number`	Unknown
`location_position`	Unknown
`location_real_name`	Unknown
`location_room`	Unknown
`location_username`	Unknown
`mac_address`	Unknown
`management_id`	Unknown
`mdm_access_right`	Unknown
`model_identifier`	Unknown
`name`	Unknown
`operating_system_build`	Unknown
`operating_system_rapid_security_response`	Unknown
`operating_system_supplemental_build_version`	Unknown
`operating_system_version`	Unknown
`serial_number`	Unknown
`site`	Unknown
`udid`	Unknown

api_role_privilege

Column	Type	Keys
`index`	Unknown	PK
`api_role_id`	Unknown	PKFK
`privilege_id`	Unknown

api_role

Column	Type	Keys
`id`	Unknown	PK
`display_name`	Unknown

authorization_detail_group_id

Column	Type	Keys
`index`	Unknown	PK
`authorization_detail_account_id`	Unknown	PKFK
`group_id`	Unknown	FK

authorization_account_group_member

Column	Type	Keys
`index`	Unknown	PK
`authorization_detail_account_group_index`	Unknown	PKFK
`authorization_detail_account_id`	Unknown	PKFK
`member_user_id`	Unknown

authorization_detail_account_group

Column	Type	Keys
`index`	Unknown	PK
`authorization_detail_account_id`	Unknown	PKFK
`access_level`	Unknown
`privilege_set`	Unknown
`privileges`	Unknown
`site_id`	Unknown

authorization_detail_site

Column	Type	Keys
`id`	Unknown	PK
`authorization_detail_account_id`	Unknown	PKFK
`name`	Unknown

authorization_detail

Column	Type	Keys
`account_id`	Unknown	PK
`account_access_level`	Unknown
`account_current_site_id`	Unknown
`account_date_format`	Unknown
`account_disable_relative_date`	Unknown
`account_email`	Unknown
`account_language`	Unknown
`account_multi_site_admin`	Unknown
`account_privilege_set`	Unknown
`account_real_name`	Unknown
`account_region`	Unknown
`account_timezone`	Unknown
`account_username`	Unknown
`custom_`

mobile_device_extension_attribute_value

Column	Type	Keys
`index`	Unknown	PK
`mobile_device_detail_extension_attribute_id`	Unknown	PKFK
`mobile_device_detail_id`	Unknown	PKFK
`value`	Unknown

mobile_device_detail_extension_attribute

Column	Type	Keys
`id`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`extension_attribute_collection_allowed`	Unknown
`inventory_display`	Unknown
`name`	Unknown
`type`	Unknown

mobile_device_detail_application

Column	Type	Keys
`index`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`bundle_size`	Unknown
`dynamic_size`	Unknown
`identifier`	Unknown
`management_status`	Unknown
`name`	Unknown
`short_version`	Unknown
`validation_status`	Unknown
`version`	Unknown

mobile_device_detail_certificate

Column	Type	Keys
`index`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`common_name`	Unknown
`expiration_date`	Unknown
`identities`	Unknown

mobile_device_detail_profile

Column	Type	Keys
`id`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`display_name`	Unknown
`identifier`	Unknown
`last_installed`	Unknown
`removable`	Unknown
`version`	Unknown

mobile_device_detail_user_profile

Column	Type	Keys
`id`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`display_name`	Unknown
`identifier`	Unknown
`last_installed`	Unknown
`removable`	Unknown
`username`	Unknown
`version`	Unknown

mobile_device_detail_shared_user

Column	Type	Keys
`index`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`data_to_sync`	Unknown
`logged_in`	Unknown
`managed_apple_id`	Unknown

mobile_device_detail_service_subscription

Column	Type	Keys
`e_id`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`carrier_setting_version`	Unknown
`current_carrier_network`	Unknown
`current_mobile_country_code`	Unknown
`current_mobile_network_code`	Unknown
`data_preferred`	Unknown
`icc_id`	Unknown
`imei`	Unknown
`label`	Unknown
`label_id`	Unknown
`me_id`	Unknown
`phone_number`	Unknown
`roaming`	Unknown
`slot`	Unknown
`subscriber_carrier_network`	Unknown
`voice_preferred`	Unknown

mobile_device_detail_e_book

Column	Type	Keys
`index`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`author`	Unknown
`kind`	Unknown
`management_state`	Unknown
`title`	Unknown
`version`	Unknown

mobile_device_detail_provision_profile

Column	Type	Keys
`id`	Unknown	PK
`mobile_device_detail_id`	Unknown	PKFK
`display_name`	Unknown
`expiration_date`	Unknown

mobile_device_detail

Column	Type	Keys
`id`	Unknown	PK
`air_play_password`	Unknown
`app_analytics_enabled`	Unknown
`asset_tag`	Unknown
`cloud_backup_enabled`	Unknown
`declarative_device_management_enabled`	Unknown
`device_locator_service_enabled`	Unknown
`device_ownership_type`	Unknown
`device_type`	Unknown
`diagnostic_and_usage_reporting_enabled`	Unknown
`display_name`	Unknown
`do_not_disturb_enabled`	Unknown
`enrollment_method_prestage_mobile_device_prestage_id`	Unknown
`enrollment_method_prestage_profile_name`	Unknown
`enrollment_session_token_valid`	Unknown
`exchange_device_id`	Unknown
`hardware_available_space_mb`	Unknown
`hardware_battery_level`	Unknown
`hardware_bluetooth_low_energy_capable`	Unknown
`hardware_bluetooth_mac_address`	Unknown
`hardware_capacity_mb`	Unknown
`hardware_device_id`	Unknown
`hardware_model`	Unknown
`hardware_model_identifier`	Unknown
`hardware_model_number`	Unknown
`hardware_modem_firmware_version`	Unknown
`hardware_serial_number`	Unknown
`hardware_used_space_percentage`	Unknown
`hardware_wifi_mac_address`	Unknown
`ip_address`	Unknown
`is_leased`	Unknown
`is_purchased`	Unknown
`itunes_store_account_active`	Unknown
`languages`	Unknown
`last_backup_date`	Unknown
`last_cloud_backup_date`	Unknown
`last_enrolled_date`	Unknown
`last_inventory_update_date`	Unknown
`locales`	Unknown
`location_services_for_self_service_mobile_enabled`	Unknown
`managed`	Unknown
`maximum_sharedi_pad_users_stored`	Unknown
`mdm_profile_expiration_date`	Unknown
`os_build`	Unknown
`os_rapid_security_response`	Unknown
`os_supplemental_build_version`	Unknown
`os_version`	Unknown
`purchasing_apple_care_id`	Unknown
`purchasing_contact`	Unknown
`purchasing_lease_expires_date`	Unknown
`purchasing_life_expectancy`	Unknown
`purchasing_po_date`	Unknown
`purchasing_po_number`	Unknown
`purchasing_purchase_price`	Unknown
`purchasing_purchasing_account`	Unknown
`purchasing_vendor`	Unknown
`purchasing_warranty_expires_date`	Unknown
`quota_size`	Unknown
`resident_users`	Unknown
`security_activation_lock_enabled`	Unknown
`security_block_level_encryption_capable`	Unknown
`security_data_protected`	Unknown
`security_file_level_encryption_capable`	Unknown
`security_hardware_encryption`	Unknown
`security_jail_break_detected`	Unknown
`security_last_attestation_attempt_date`	Unknown
`security_last_successful_attestation_date`	Unknown
`security_lost_mode_enabled`	Unknown
`security_lost_mode_foot_note`	Unknown
`security_lost_mode_location_altitude_meter`	Unknown
`security_lost_mode_location_course_degrees`	Unknown
`security_lost_mode_location_horizontal_accuracy_meter`	Unknown
`security_lost_mode_location_speed_meters_per_second`	Unknown
`security_lost_mode_location_timestamp`	Unknown
`security_lost_mode_location_update`	Unknown
`security_lost_mode_location_vertical_accuracy_meter`	Unknown
`security_lost_mode_message`	Unknown
`security_lost_mode_persistent`	Unknown
`security_lost_mode_phone_number`	Unknown
`security_passcode_compliant`	Unknown
`security_passcode_compliant_with_profile`	Unknown
`security_passcode_lock_grace_period_enforced_second`	Unknown
`security_passcode_present`	Unknown
`security_personal_device_profile_current`	Unknown
`shared_ipad`	Unknown
`site_id`	Unknown
`software_update_device_id`	Unknown
`supervised`	Unknown
`synced_to_computer`	Unknown
`temporary_session_only`	Unknown
`temporary_session_timeout`	Unknown
`tethered`	Unknown
`time_zone`	Unknown
`udid`	Unknown
`user_and_location_building`	Unknown
`user_and_location_building_id`	Unknown
`user_and_location_department`	Unknown
`user_and_location_department_id`	Unknown
`user_and_location_email_address`	Unknown
`user_and_location_phone_number`	Unknown
`user_and_location_position`	Unknown
`user_and_location_real_name`	Unknown
`user_and_location_room`	Unknown
`user_and_location_username`	Unknown
`user_session_timeout`	Unknown

computer_prestage_custom_package

Column	Type	Keys
`index`	Unknown	PK
`computer_prestage_id`	Unknown	PKFK
`package_id`	Unknown

computer_prestaged_installed_profile

Column	Type	Keys
`index`	Unknown	PK
`computer_prestage_id`	Unknown	PKFK
`profile_id`	Unknown

computer_prestage_anchor_certificate

Column	Type	Keys
`index`	Unknown	PK
`computer_prestage_id`	Unknown	PKFK
`anchor_certificate`	Unknown

computer_prestage

Column	Type	Keys
`id`	Unknown	PK
`account_setting_admin_username`	Unknown
`account_setting_hidden_admin_account`	Unknown
`account_setting_id`	Unknown
`account_setting_local_admin_account_enabled`	Unknown
`account_setting_local_user_managed`	Unknown
`account_setting_payload_configured`	Unknown
`account_setting_prefill_account_full_name`	Unknown
`account_setting_prefill_account_user_name`	Unknown
`account_setting_prefill_primary_account_info_feature_enabled`	Unknown
`account_setting_prefill_type`	Unknown
`account_setting_prevent_prefill_info_from_modification`	Unknown
`account_setting_user_account_type`	Unknown
`account_setting_version_lock`	Unknown
`authentication_prompt`	Unknown
`auto_advance_setup`	Unknown
`custom_package_distribution_point_id`	Unknown
`default_prestage`	Unknown
`department`	Unknown
`device_enrollment_program_instance_id`	Unknown
`display_name`	Unknown
`enable_device_based_activation_lock`	Unknown
`enable_recovery_lock`	Unknown
`enrollment_customization_id`	Unknown
`enrollment_site_id`	Unknown
`install_profiles_during_setup`	Unknown
`is_leased`	Unknown
`is_purchased`	Unknown
`keep_existing_location_information`	Unknown
`keep_existing_site_membership`	Unknown
`languages`	Unknown
`location_building_id`	Unknown
`location_department_id`	Unknown
`location_email`	Unknown
`location_id`	Unknown
`location_phone`	Unknown
`location_position`	Unknown
`location_realname`	Unknown
`location_room`	Unknown
`location_username`	Unknown
`location_version_lock`	Unknown
`mandatory`	Unknown
`mdm_removable`	Unknown
`prevent_activation_lock`	Unknown
`profile_uuid`	Unknown
`purchase_info_apple_care_id`	Unknown
`purchase_info_id`	Unknown
`purchase_info_lease_date`	Unknown
`purchase_info_life_expectancy`	Unknown
`purchase_info_po_date`	Unknown
`purchase_info_po_number`	Unknown
`purchase_info_purchase_price`	Unknown
`purchase_info_purchasing_account`	Unknown
`purchase_info_purchasing_contact`	Unknown
`purchase_info_vendor`	Unknown
`purchase_info_version_lock`	Unknown
`purchase_info_warranty_date`	Unknown
`recovery_lock_password_type`	Unknown
`region`	Unknown
`require_authentication`	Unknown
`rotate_recovery_lock_password`	Unknown
`site_id`	Unknown
`skip_setup_item_accessibility`	Unknown
`skip_setup_item_appearance`	Unknown
`skip_setup_item_apple_id`	Unknown
`skip_setup_item_biometric`	Unknown
`skip_setup_item_diagnostics`	Unknown
`skip_setup_item_display_tone`	Unknown
`skip_setup_item_file_vault`	Unknown
`skip_setup_item_i_cloud_diagnostics`	Unknown
`skip_setup_item_i_cloud_storage`	Unknown
`skip_setup_item_location`	Unknown
`skip_setup_item_payment`	Unknown
`skip_setup_item_privacy`	Unknown
`skip_setup_item_registration`	Unknown
`skip_setup_item_restores`	Unknown
`skip_setup_item_screen_time`	Unknown
`skip_setup_item_siri`	Unknown
`skip_setup_item_terms_of_address`	Unknown
`skip_setup_item_tos`	Unknown
`support_email_address`	Unknown
`support_phone_number`	Unknown
`version_lock`	Unknown

computer_inventory_setting_application_path

Column	Type	Keys
`id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`path`	Unknown

computer_inventory_setting_font_path

Column	Type	Keys
`id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`path`	Unknown

computer_inventory_setting_plugin_path

Column	Type	Keys
`id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`path`	Unknown

computer_inventory_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`collect_synced_mobile_device_info`	Unknown
`computer_allow_changing_user_and_location`	Unknown
`computer_calculate_size`	Unknown
`computer_collect_unmanaged_certificate`	Unknown
`computer_include_account`	Unknown
`computer_include_font`	Unknown
`computer_include_hidden_account`	Unknown
`computer_include_package`	Unknown
`computer_include_plugin`	Unknown
`computer_include_printer`	Unknown
`computer_include_service`	Unknown
`computer_include_software_id`	Unknown
`computer_include_software_update`	Unknown
`computer_monitor_application_usage`	Unknown
`computer_monitor_beacon`	Unknown
`computer_update_ldap_info_on_computer_inventory_submission`	Unknown
`computer_use_unix_user_path`	Unknown

department

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

re_enrollment_object_history

Column	Type	Keys
`id`	Unknown	PK
`date`	Instant
`details`	Unknown
`note`	Unknown
`username`	Unknown

self_service_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`configuration_setting_alert_user_approved_mdm`	Unknown
`configuration_setting_bookmarks_name`	Unknown
`configuration_setting_default_home_category_id`	Unknown
`configuration_setting_default_landing_page`	Unknown
`configuration_setting_notifications_enabled`	Unknown
`install_automatically`	Unknown
`install_location`	Unknown
`setting_allow_remember_me`	Unknown
`setting_auth_type`	Unknown
`setting_user_login_level`	Unknown

computer_group

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

advanced_search_object_criteria

Column	Type	Keys
`index`	Unknown	PK
`advanced_search_object_id`	Unknown	PKFK
`and_or`	Unknown
`closing_paren`	Unknown
`name`	Unknown
`opening_paren`	Unknown
`priority`	Unknown
`search_type`	Unknown
`value`	Unknown

advanced_search_object_display_field

Column	Type	Keys
`index`	Unknown	PK
`advanced_search_object_id`	Unknown	PKFK
`display_field`	Unknown

advanced_search_object

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

mobile_device_detail_network_section

Column	Type	Keys
`id`	Unknown	PKFK
`network_carrier_setting_version`	Unknown
`network_cellular_technology`	Unknown
`network_current_carrier_network`	Unknown
`network_current_mobile_country_code`	Unknown
`network_current_mobile_network_code`	Unknown
`network_data_roaming_enabled`	Unknown
`network_e_id`	Unknown
`network_home_carrier_network`	Unknown
`network_home_mobile_country_code`	Unknown
`network_home_mobile_network_code`	Unknown
`network_iccid`	Unknown
`network_imei`	Unknown
`network_me_id`	Unknown
`network_personal_hotspot_enabled`	Unknown
`network_phone_number`	Unknown
`network_roaming`	Unknown
`network_voice_roaming_enabled`	Unknown

supervision_identity

Column	Type	Keys
`id`	Unknown	PK
`common_name`	Unknown
`display_name`	Unknown
`expiration_date`	Unknown

category_history

Column	Type	Keys
`id`	Unknown	PKFK
`date`	Instant
`details`	Unknown
`note`	Unknown
`username`	Unknown

device_enrollment_instance

Column	Type	Keys
`id`	Unknown	PK
`time_stamp`	Unknown	PK
`sync_state`	Unknown

mac_os_configuration

Column	Type	Keys
`id`	Unknown	PK
`application_name`	Unknown
`branding_header_image_id`	Unknown
`branding_name`	Unknown
`branding_name_secondary`	Unknown
`icon_id`	Unknown

patch_software_title_configuration_history

Column	Type	Keys
`id`	Unknown	PKFK
`date`	Instant
`details`	Unknown
`note`	Unknown
`username`	Unknown

device_setting_history

Column	Type	Keys
`id`	Unknown	PK
`date`	Instant
`details`	Unknown
`note`	Unknown
`username`	Unknown

static_user_group

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

patch_policy

Column	Type	Keys
`id`	Unknown	PK
`completed`	Unknown
`deferred`	Unknown
`failed`	Unknown
`pending`	Unknown
`policy_deployment_method`	Unknown
`policy_enabled`	Unknown
`policy_name`	Unknown
`policy_target_version`	Unknown
`software_title`	Unknown
`software_title_configuration_id`	Unknown