JumpCloud Apple MDM, Applications, Authentication, and Bridge Tables

Tables

JumpCloudAppleMDMDevices

Name	Type	Description
ConfigID	integer	A unique identifier for the device configuration within JumpCloud.
ID	string	The unique identifier for the Apple MDM device in JumpCloud.
CreatedAt	string	Timestamp of when the device record was created.
DepRegistered	bit	Indicates if the device is registered with Apple’s Device Enrollment Program (DEP).
Enrolled	bit	Indicates whether the device is enrolled in Mobile Device Management (MDM).
HasActivationLockBypassCodes	bit	Shows whether activation lock bypass codes are available for the device.
MdmOsFamily	string	The operating system family managed by MDM (e.g., `iOS`, `macOS`).
ModelFamily	string	Broad model family classification of the device.
OsVersion	string	The version of the device’s operating system.
SerialNumber	string	The hardware serial number of the device.
Udid	string	Unique Device Identifier (`UDID`) assigned by Apple.
DeviceInformationActivationLockAllowedWhileSupervised	bit	Indicates whether Activation Lock is allowed while the device is supervised.
DeviceInformationAvailableDeviceCapacity	float	Amount of available storage capacity on the device.
DeviceInformationDeviceCapacity	float	Total storage capacity of the device.
DeviceInformationDeviceName	string	The user-assigned or system-assigned name of the device.
DeviceInformationIccid	string	Integrated Circuit Card Identifier for the SIM card in the device.
DeviceInformationImei	string	International Mobile Equipment Identity number for the device.
DeviceInformationIsSupervised	bit	Indicates whether the device is supervised (enrolled in supervised mode).
DeviceInformationModelMarketingName	string	Marketing name of the device model (e.g., `MacBook Pro`).
DeviceInformationModelName	string	The technical name of the device model.
DeviceInformationModelNumber	string	The specific model number identifier for the device.
DeviceInformationOsBuildVersion	string	The build version of the installed operating system.
DeviceInformationOsExtraVersion	string	Additional version string information for the OS.
DeviceInformationOsMarketingName	string	The marketing name for the OS (e.g., `macOS Sonoma`).
DeviceInformationOsSupplementalBuildVersion	string	Supplemental build identifier for the OS.
DeviceInformationSecondIccid	string	ICCID for a second SIM if supported.
DeviceInformationSecondImei	string	IMEI for a second SIM if supported.
DeviceInformationSecondSubscriberCarrierNetwork	string	Carrier network associated with the second SIM.
DeviceInformationSofwareUpdateId	string	Identifier for the most recent software update available.
DeviceInformationSubscriberCarrierNetwork	string	Carrier network associated with the primary SIM.
DeviceInformationWifiMac	string	The MAC address of the Wi-Fi interface.
SecurityInfoEnrolledViaDep	bit	Indicates if the device was enrolled via Apple DEP.
SecurityInfoFilevaultEnabled	bit	Shows whether FileVault disk encryption is enabled (macOS only).
SecurityInfoIsActivationLockManageable	bit	Indicates whether Activation Lock can be managed through MDM.
SecurityInfoIsUserEnrollment	bit	Indicates if the device is enrolled using Apple’s User Enrollment method.
SecurityInfoPasscodeCompliant	bit	Shows if the device passcode complies with security policies.
SecurityInfoPasscodePresent	bit	Indicates whether the device currently has a passcode set.
SecurityInfoUserApprovedEnrollment	bit	Indicates if enrollment was explicitly approved by the end user.
JumpCloudAppleMDMID	string	Unique identifier for the Apple MDM configuration in JumpCloud.
BatchDate	datetime	Timestamp indicating when this device record was last batched or synchronized into reporting.

JumpCloudAppleMDMs

Name	Type	Description
ConfigID	integer	Unique identifier for the JumpCloud Apple MDM configuration.
ID	string	The specific MDM configuration record ID within JumpCloud.
AllowMobileUserEnrollment	bit	Indicates whether mobile devices can self-enroll in MDM.
ApnsCertExpiry	string	Expiration date of the Apple Push Notification Service (APNs) certificate.
ApnsPushTopic	string	The APNs topic string used to push MDM commands to devices.
AppleCertCreatorAppleID	string	The Apple ID used to create the APNs certificate.
AppleCertSerialNumber	string	Serial number of the APNs certificate.
DefaultIosUserEnrollmentDeviceGroupID	string	Default JumpCloud device group assigned to newly enrolled iOS devices.
DefaultSystemGroupID	string	Default JumpCloud system group assigned to enrolled macOS systems.
DepAccessTokenExpiry	string	Expiration timestamp for the Apple DEP (Device Enrollment Program) access token.
DepServerTokenState	string	Current state of the Apple DEP server token (e.g., `valid`, `expired`).
Name	string	The administrator-assigned name of the Apple MDM configuration.
Organization	string	Organization name associated with the MDM configuration.
DepEnableZeroTouchEnrollment	bit	Indicates if zero-touch enrollment is enabled for Apple DEP devices.
DepSetupAssistantOptionsJson	string	JSON definition of setup assistant options for DEP-enrolled devices.
DepWelcomeScreenTitle	string	Custom title text displayed on the DEP enrollment welcome screen.
DepWelcomeScreenParagraph	string	Custom paragraph text displayed on the DEP enrollment welcome screen.
DepWelcomeScreenButton	string	Custom button text displayed on the DEP enrollment welcome screen.
AdesIosDefaultDeviceGroupObjectIDsJson	string	JSON array of default JumpCloud device groups assigned to ADEs-enrolled iOS devices.
AdesIosEnableZeroTouchEnrollment	bit	Indicates if ADEs zero-touch enrollment is enabled for iOS devices.
AdesIosSetupAssistantOptionsJson	string	JSON definition of setup assistant options for ADEs-enrolled iOS devices.
AdesIosSetupOptionsJson	string	JSON definition of setup workflow options for iOS ADEs enrollment.
AdesIosWelcomeScreenTitle	string	Custom title for the ADEs enrollment welcome screen (`iOS`).
AdesIosWelcomeScreenParagraph	string	Custom paragraph text for the ADEs enrollment welcome screen (`iOS`).
AdesIosWelcomeScreenButton	string	Custom button text for the ADEs enrollment welcome screen (`iOS`).
AdesMacosDefaultDeviceGroupObjectIDsJson	string	JSON array of default JumpCloud device groups assigned to ADEs-enrolled macOS devices.
AdesMacosEnableZeroTouchEnrollment	bit	Indicates if ADEs zero-touch enrollment is enabled for macOS devices.
AdesMacosSetupAssistantOptionsJson	string	JSON definition of setup assistant options for ADEs-enrolled macOS devices.
AdesMacosSetupOptionsJson	string	JSON definition of setup workflow options for macOS ADEs enrollment.
AdesMacosWelcomeScreenTitle	string	Custom title for the ADEs enrollment welcome screen (macOS).
AdesMacosWelcomeScreenParagraph	string	Custom paragraph text for the ADEs enrollment welcome screen (`macOS`).
AdesMacosWelcomeScreenButton	string	Custom button text for the ADEs enrollment welcome screen (`macOS`).
BatchDate	datetime	Timestamp when this MDM configuration record was last batched or synchronized into reporting.

JumpCloudApplications

Name	Type	Description
ConfigID	integer	Unique identifier linking the application record to its configuration in JumpCloud.
ID	string	Unique identifier for the application within JumpCloud.
DisplayName	string	The name shown in the JumpCloud console for the application.
SsoType	string	Indicates the type of SSO integration (e.g., `SAML`, `OIDC`).
ProvisionType	string	Specifies the provisioning method (e.g., `SCIM`, `manual`).
Status	string	Current operational status of the application (e.g., `active`, `disabled`).
SsoUrl	string	URL endpoint used for initiating Single Sign-On.
Color	string	Hex or named color assigned for UI display of the application.
ProvisionExportdisabled	bit	Boolean flag indicating if user/group exports to the app are disabled.
ProvisionGroupsEnabled	bit	Boolean flag showing whether group provisioning is enabled.
ProvisionGroupsSupported	bit	Indicates if the application supports provisioning groups.
ProvisionImportdisabled	bit	Boolean flag showing if imports from the app are disabled.
Sso`active`	bit	Boolean flag showing if the SSO configuration is currently active.
SsoBeta	bit	Indicates if the SSO feature for this application is in beta.
SsoCert`expired`	bit	Boolean flag showing whether the SSO certificate has expired.
SsoHidden	bit	Indicates if the SSO integration is hidden in the JumpCloud console.
SsoIdpCertExpirationAt	datetime	Timestamp when the identity provider certificate expires.
SsoJitEnabled	bit	Boolean flag showing if Just-In-Time (`JIT`) user provisioning is enabled.
SsoJitSupported	bit	Indicates if the application supports JIT provisioning.
ProvisionBeta	bit	Marks if provisioning features are in beta for this application.
SsoSpErrorFlow	bit	Configuration value defining error handling flow for Service Provider SSO failures.
ProvisionID	string	Identifier for the application’s provisioning configuration.
DisplayLabel	string	Alternate label displayed for the application in JumpCloud.
Description	string	Human-readable description of the application.
Organization	string	The organization to which this application belongs.
Name	string	The internal or catalog name of the application.
CatalogItemJson	string	JSON object with catalog item details (e.g., `template data`, `metadata`).
BatchDate	datetime	The date when this application record was last synchronized or batched.
LogoUrl	string	URL to the logo image used for representing the application.

JumpCloudAuthenticationPolicies

Name	Type	Description
ConfigID	integer	Unique identifier linking the authentication policy to its configuration in JumpCloud.
ID	string	Unique identifier for the authentication policy.
Name	string	Human-readable name assigned to the authentication policy.
Description	string	Text description explaining the purpose or scope of the policy.
disabled	bit	Boolean flag indicating if the policy is currently disabled.
Type	string	Specifies the type of authentication policy (e.g., `conditional access`, `MFA`).
EffectAction	string	Defines the enforcement action when conditions are met (e.g., `allow`, `deny`, `require MFA`).
TargetsUsersInclusionsJson	string	JSON list of specific users included in this policy’s scope.
TargetsUserGroupsInclusionsJson	string	JSON list of user groups explicitly included under this policy.
TargetsUserGroupsExclusionsJson	string	JSON list of user groups excluded from this policy’s enforcement.
ConditionsNotIpAddressInJson	string	JSON object defining disallowed IP ranges or addresses for authentication attempts.
BatchDate	datetime	The date when this authentication policy record was last synchronized or batched.

JumpCloudAuthenticationPolicyTargetResources

Name	Type	Description
ConfigID	integer	Unique identifier linking the resource entry to its configuration in JumpCloud.
ID	string	Unique identifier for the target resource record.
Type	string	Specifies the type of resource targeted (e.g., `application`, `system`, or `service`).
JumpCloudAuthenticationPolicyID	string	Identifier of the authentication policy that this resource is associated with.
BatchDate	datetime	The date when this target resource record was last synchronized or batched.

Bridge Tables

JumpCloudApplications_JumpCloudUsers

Name	Type	Description
JumpCloudUserModelID	string	Unique identifier of the JumpCloud user in the bridge table.
JumpCloudUserModelConfigID	integer	Configuration identifier for the associated user.
JumpCloudApplicationModelID	string	Unique identifier of the JumpCloud application in the bridge table.
JumpCloudApplicationModelConfigID	integer	Configuration identifier for the associated application.

Tables

JumpCloudAppleMDMDevices

JumpCloudAppleMDMs

JumpCloudApplications

JumpCloudAuthenticationPolicies

JumpCloudAuthenticationPolicyTargetResources

Bridge Tables

JumpCloudApplications_JumpCloudUsers

Learn more...