JumpCloud Groups, Integrations, Password, Policies, and Bridge Tables
Tables
JumpCloudGroupModelJumpCloudPolicyModel
| Name | Type | Description |
|---|---|---|
| JumpCloudGroupsID | string | Unique identifier for the JumpCloud group linked to the policy. |
| JumpCloudGroupsConfigID | integer | Configuration identifier associated with the JumpCloud group. |
| JumpCloudPoliciesID | string | Unique identifier for the JumpCloud policy assigned to the group. |
| JumpCloudPoliciesConfigID | integer | Configuration identifier associated with the JumpCloud policy. |
JumpCloudGroups
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Configuration identifier for the group record. |
| ID | string | Unique identifier of the JumpCloud group. |
| Name | string | Human-readable name of the group. |
| Type | string | Type of group (e.g., user group, system group, application group, etc.). |
| string | Optional group email address (if applicable). | |
| Description | string | Text description of the group’s purpose or usage. |
| AttributesJson | string | JSON object with additional group attributes or metadata. |
| BatchDate | datetime | Timestamp when the record was last captured or updated in batch ingestion. |
JumpCloudIntegrations
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier of the integration. |
| Name | string | Human-readable name of the integration (e.g., Slack, AWS, Atlassian). |
| CreatedDate | datetime | Timestamp when the integration was first created. |
| ModifiedDate | datetime | Timestamp of the last modification to the integration. |
| CreatedBy | string | Identifier of the user or system that created the integration. |
| ModifiedBy | string | Identifier of the user or system that last modified the integration. |
| IsEnabled | bit | Boolean flag indicating if the integration is currently active. |
JumpCloudPasswordPolicies
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Configuration identifier for the policy record. |
| ID | string | Unique identifier of the password policy. |
| AllowUnenrolledMFAPasswordReset | bit | Whether users without MFA enrollment can reset their password. |
| AllowUsernameSubstring | bit | Indicates if a username substring can be used in the password. |
| DaysAfterExpirationToSelfRecover | integer | Number of days after expiration a user can self-recover a password. |
| DaysBeforeExpirationToForceReset | integer | Number of days before expiration when users are forced to reset their password. |
| Default | bit | Flag showing if this is the default password policy. |
| Description | string | Human-readable description of the policy. |
| DisallowCommonlyUsedPasswords | bit | Blocks use of common or weak passwords. |
| DisallowSequentialOrRepetitiveChars | bit | Prevents sequential or repetitive characters in passwords. |
| EffectiveDate | datetime | Date when the policy became effective. |
| EnableDaysAfterExpirationToSelfRecover | bit | Enables the self-recovery option after password expiration. |
| EnableDaysBeforeExpirationToForceReset | bit | Enables forced reset before expiration. |
| EnableLockoutTimeInSeconds | bit | Enables lockout duration configuration. |
| EnableMaxHistory | bit | Enables password history enforcement. |
| EnableMaxLoginAttempts | bit | Enables login attempt restrictions. |
| EnableMinChangePeriodInDays | bit | Enables minimum time before a user can change their password again. |
| EnableMinLength | bit | Enables minimum password length enforcement. |
| EnablePasswordExpirationInDays | bit | Enables password expiration period. |
| EnableRecoveryEmail | bit | Enables password recovery via email. |
| EnableResetLockoutCounter | bit | Enables reset of the lockout counter after defined minutes. |
| LockoutTimeInSeconds | integer | Duration a user is locked out after exceeding failed login attempts. |
| MaxHistory | integer | Number of previous passwords disallowed from reuse. |
| MaxLoginAttempts | integer | Maximum number of failed login attempts before lockout. |
| MinChangePeriodInDays | integer | Minimum number of days before a password can be changed again. |
| MinLength | integer | Minimum password length required. |
| Name | string | Name of the password policy. |
| NeedsLowercase | bit | Requires lowercase letters in the password. |
| NeedsNumeric | bit | Requires numeric characters in the password. |
| NeedsSymbolic | bit | Requires symbolic characters in the password. |
| NeedsUppercase | bit | Requires uppercase letters in the password. |
| PasswordExpirationInDays | integer | Number of days after which passwords must be changed. |
| Precedence | integer | Determines priority if multiple password policies apply. |
| ResetLockoutCounterMinutes | integer | Time (in minutes) before failed login attempts counter resets. |
| BatchDate | datetime | Timestamp when the record was collected or batched. |
JumpCloudPolicies
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Configuration identifier for the policy record. |
| ID | string | Unique identifier of the policy. |
| Name | string | Name of the policy defined in JumpCloud. |
| Notes | string | Administrator notes or comments about the policy. |
| TemplateID | string | Identifier of the template the policy is based on. |
| TemplateName | string | Name of the policy template. |
| TemplateActivation | string | Activation status of the policy template. |
| TemplateBehavior | string | Defines how the policy template behaves (enforcement, monitoring, etc.). |
| TemplateDisplayName | string | Human-readable display name of the template. |
| TemplateDescription | string | Description of the policy template. |
| TemplateOsMetaFamily | string | Operating system family the template applies to (e.g., Windows, macOS, Linux). |
| TemplateState | string | Current state of the template (enabled, disabled, draft). |
| TemplateDeliveryTypesJson | string | JSON describing supported delivery methods (e.g., MDM, agent-based). |
| TemplateAlertJson | string | JSON defining alerting rules or thresholds. |
| TemplateReferenceJson | string | JSON with reference metadata for the policy template. |
| TemplateOsRestrictionsJson | string | JSON defining OS-specific restrictions for the policy. |
| BatchDate | datetime | Timestamp when the record was collected or batched. |
JumpCloudPolicyConfigFields
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Configuration identifier for the record. |
| ID | integer | Unique identifier of the policy configuration field. |
| JumpCloudPolicyID | string | Reference to the associated JumpCloud policy. |
| ConfigFieldID | string | Identifier for the specific configuration field. |
| Name | string | System name of the configuration field. |
| Label | string | Display label for the configuration field. |
| DisplayType | string | Type of UI element used for display (e.g., textbox, dropdown). |
| Position | integer | Field’s position or order in the configuration layout. |
| Required | bit | Indicates if the field is mandatory. |
| ReadOnly | bit | Marks whether the field can be modified. |
| Sensitive | bit | Indicates if the field contains sensitive data (e.g., passwords). |
| DefaultValueJson | string | JSON specifying the default value of the field. |
validatorsJson | string | JSON defining validation rules for the field. |
| TooltipTemplate | string | Tooltip text template for user guidance. |
| TooltipVariablesMessage | string | Dynamic message variables for tooltips. |
| TooltipVariablesIcon | string | Icon representation for tooltip guidance. |
| DisplayOptionsMaxSize | integer | Maximum allowed size of the field value. |
| DisplayOptionsType | string | Display option type for rendering. |
| DisplayOptionsLabel | string | Display label specific to UI rendering. |
| DisplayOptionsTooltipTemplate | string | Template text for display-related tooltips. |
| DisplayOptionsTooltipVariablesMessage | string | Variables for display tooltip messages. |
| DisplayOptionsTooltipVariablesIcon | string | Icon reference for display tooltip. |
| BatchDate | datetime | Timestamp when the record was collected or batched. |
JumpCloudPolicyModelJumpCloudSystemModel
| Name | Type | Description |
|---|---|---|
| JumpCloudPoliciesID | string | Unique identifier of the associated JumpCloud policy. |
| JumpCloudPoliciesConfigID | integer | Configuration identifier for the linked policy. |
| JumpCloudSystemsID | string | Unique identifier of the associated JumpCloud-managed system (e.g., endpoint). |
| JumpCloudSystemsConfigID | integer | Configuration identifier for the linked system. |
JumpCloudPolicyResultOsRestrictions
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Configuration identifier for the record. |
| ID | integer | Unique identifier of the OS restriction record. |
| JumpCloudPolicyResultID | string | Reference to the associated JumpCloud policy result. |
| OsName | string | Name of the operating system the restriction applies to (e.g., Windows, macOS). |
| EarliestVersion | string | Minimum OS version required for the policy to be applied. |
| DeprecatedVersion | string | OS version at which the policy is considered deprecated or unsupported. |
| IsMdmRequired | bit | Boolean indicating if MDM enrollment is required for the policy on this OS. |
| AppleRestrictionsRequiresSupervision | bit | Boolean indicating if Apple devices must be supervised to enforce the policy. |
| AppleRestrictionsSupportedEnrollmentTypesJson | string | JSON array listing supported Apple enrollment types for the policy. |
| BatchDate | datetime | Timestamp when the record was collected or batched. |
JumpCloudPolicyResults
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Configuration identifier for the record. |
| PolicyResultID | string | Unique identifier of the policy result. |
| Name | string | Name of the policy result. |
| Notes | string | Administrator notes or comments about the policy result. |
| OrganizationObjectID | string | Identifier for the organization the policy result belongs to. |
| TemplateID | string | Identifier of the policy template the result is based on. |
| TemplateName | string | Name of the policy template. |
| TemplateActivation | string | Activation status of the policy template. |
| TemplateBehavior | string | Defines how the template behaves (e.g., enforcement, monitoring). |
| TemplateDisplayName | string | Human-readable display name of the template. |
| TemplateDescription | string | Description of the policy template. |
| TemplateOsMetaFamily | string | Operating system family the template applies to (e.g., Windows, macOS, Linux). |
| TemplateState | string | Current state of the template (enabled, disabled, draft). |
| TemplateAlertJson | string | JSON defining alerting rules or thresholds. |
| TemplateReferenceJson | string | JSON with reference metadata for the policy template. |
| TemplateDeliveryTypesJson | string | JSON describing supported delivery methods (e.g., MDM, agent-based). |
| ValuesJson | string | JSON containing the configured values for the policy result. |
| BatchDate | datetime | Timestamp when the record was collected or batched. |
JumpCloudPolicyValues
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Configuration identifier for the record. |
| JumpCloudPolicyID | string | Reference to the associated JumpCloud policy. |
| ConfigFieldID | string | Identifier for the specific configuration field within the policy. |
| ConfigFieldName | string | Name of the configuration field. |
| Sensitive | bit | Boolean indicating if the field contains sensitive information (e.g., passwords). |
| Value | string | The configured value for the policy field. |
| BatchDate | datetime | Timestamp when the record was collected or batched. |
Bridge Tables
JumpCloudGroups_JumpCloudApplications
| Name | Type | Description |
|---|---|---|
| JumpCloudGroupModelID | string | Unique identifier of the JumpCloud group in the bridge table. |
| JumpCloudGroupModelConfigID | integer | Configuration identifier for the associated group. |
| JumpCloudApplicationModelID | string | Unique identifier of the JumpCloud application in the bridge table. |
| JumpCloudApplicationModelConfigID | integer | Configuration identifier for the associated application. |
JumpCloudGroups_JumpCloudGroupAssociations
| Name | Type | Description |
|---|---|---|
| FromGroupID | string | Unique identifier of the source JumpCloud group in the association. |
| FromConfigID | integer | Configuration identifier for the source group. |
| ToGroupID | string | Unique identifier of the target JumpCloud group in the association. |
| ToConfigID | integer | Configuration identifier for the target group. |
JumpCloudGroups_JumpCloudSystems
| Name | Type | Description |
|---|---|---|
| JumpCloudSystemModelID | string | Unique identifier of the JumpCloud system in the bridge table. |
| JumpCloudSystemModelConfigID | integer | Configuration identifier for the associated system. |
| JumpCloudGroupModelID | string | Unique identifier of the JumpCloud group in the bridge table. |
| JumpCloudGroupModelConfigID | integer | Configuration identifier for the associated group. |
JumpCloudGroups_JumpCloudUsers
| Name | Type | Description |
|---|---|---|
| JumpCloudGroupModelID | string | Unique identifier of the JumpCloud group in the bridge table. |
| JumpCloudGroupModelConfigID | integer | Configuration identifier for the associated group. |
| JumpCloudUserModelID | string | Unique identifier of the JumpCloud user in the bridge table. |
| JumpCloudUserModelConfigID | integer | Configuration identifier for the associated user. |
JumpCloudPasswordPolicies_JumpCloudGroups
| Name | Type | Description |
|---|---|---|
| JumpCloudPasswordPolicyModelID | string | Unique identifier of the JumpCloud password policy in the bridge table. |
| JumpCloudPasswordPolicyModelConfigID | integer | Configuration identifier for the associated password policy. |
| JumpCloudGroupModelID | string | Unique identifier of the JumpCloud group in the bridge table. |
| JumpCloudGroupModelConfigID | integer | Configuration identifier for the associated group. |
JumpCloudPasswordPolicies_JumpCloudUsers
| Name | Type | Description |
|---|---|---|
| JumpCloudPasswordPolicyModelID | string | Unique identifier of the JumpCloud password policy in the bridge table. |
| JumpCloudPasswordPolicyModelConfigID | integer | Configuration identifier for the associated password policy. |
| JumpCloudUserModelID | string | Unique identifier of the JumpCloud user in the bridge table. |
| JumpCloudUserModelConfigID | integer | Configuration identifier for the associated user. |
Updated 10 months ago
Learn more...
Did this page help you?