JumpCloud Directory and Bridge Tables

Tables

JumpCloudDirectories

NameTypeDescription
ConfigIDintegerUnique identifier linking the directory record to its configuration in JumpCloud.
IDstringUnique identifier for the directory object.
TypestringThe directory type (e.g., active Directory, LDAP, G Suite, etc.).
NamestringHuman-readable name of the directory.
OAuthStatusExpirySecondsstringExpiration time in seconds for the OAuth status token used in the directory.
OAuthStatusExpiryNanosintegerExpiration time in nanoseconds for the OAuth status token.
OAuthStatusErrorstringError code representing any OAuth connection issue.
OAuthStatusErrorMessagestringDescriptive error message for OAuth connection issues.
BatchDatedatetimeThe date when this directory record was last synchronized or batched.
GroupsEnabledbitIndicates whether directory group synchronization is enabled.
ImportFilterstringDefines filters for which directory users/groups are imported.
UserLockoutActionstringConfigured action taken when a user is locked out from this directory.
UserPasswordExpirationActionstringConfigured action taken when a user’s password in the directory expires.

JumpCloudDirectoryInsightsEventAvailableOsUpdates

NameTypeDescription
ConfigIDintegerUnique identifier linking the OS update record to its JumpCloud configuration.
IDintegerUnique identifier for the OS update entry.
JumpCloudDirectoryInsightsEventIDstringIdentifier linking this update to the corresponding directory insights event.
AllowsInstallLaterbitIndicates if the update allows users to postpone installation.
RestartRequiredbitSpecifies if the update requires a system restart to complete installation.
MetadataUrlstringURL pointing to metadata about the update (e.g., Apple or OS vendor update info).
IsConfigDataUpdatebitIndicates if the update is a configuration data update rather than a full OS update.
HumanReadableNamestringUser-friendly name of the update (e.g., macOS Sonoma 14.2).
AppIdentifiersToCloseJsonstringJSON list of app identifiers that must be closed before applying the update.
ProductNamestringOfficial product name associated with the update.
VersionstringVersion number of the update.
IsFirmwareUpdatebitIndicates if the update includes firmware updates in addition to OS changes.
RequiresBootstrapTokenbitShows if the update requires a bootstrap token for installation.
HumanReadableNameLocalestringLocale-specific display name of the update.
ProductKeystringUnique product key associated with the update.
BuildstringBuild identifier for the OS update.
InstallSizefloatEstimated size of the update when installed (in MB/GB).
IsMajorOsUpdatebitIndicates if the update is a major OS upgrade (e.g., macOS 13 > macOS 14).
DownloadSizeJsonstringJSON representation of the download size of the update.
IsCriticalbitSpecifies if the update is marked as critical (e.g., urgent security patch).
BatchDatedatetimeThe date when this OS update record was last synchronized or batched.

JumpCloudDirectoryInsightsEventBackgroundTasks

NameTypeDescription
ConfigIDintegerUnique identifier linking the background task record to its JumpCloud configuration.
UUIDintegerUniversally unique identifier for the background task entry.
JumpCloudDirectoryInsightsEventIDstringIdentifier linking this record to the related directory insights event.
PathstringFile system path of the background task or launch item.
IdentifierstringUnique identifier string for the background task.
StatestringCurrent state of the background task (e.g., running, stopped, disabled).
TypestringType of background task (e.g., launch daemon, launch agent, scheduled task).
CodeSignaturestringInformation about the code signature of the executable (validity, signer, etc.).
RemovedbitIndicates whether the task has been removed from the system.
LaunchdChecksumstringChecksum value for the associated launchd configuration file.
LaunchdProgramstringPath to the program or executable managed by the background task.
LaunchdLabelstringLabel name used by launchd for identifying the task.
LaunchdProgramArgumentsJsonstringJSON array containing arguments passed to the program when executed.
BatchDatedatetimeDate when this background task record was last synchronized or batched.

JumpCloudDirectoryInsightsEventChanges

NameTypeDescription
ConfigIDintegerUnique identifier linking the change record to its JumpCloud configuration.
IDintegerUnique identifier for the individual change entry.
JumpCloudDirectoryInsightsEventIDstringIdentifier linking this change record to the related directory insights event.
FieldstringThe field or attribute within the event that was changed.
FromJsonstringJSON representation of the value before the change occurred.
ToJsonstringJSON representation of the updated value after the change.
BatchDatedatetimeDate when this change record was last synchronized or batched.

JumpCloudDirectoryInsightsEventCommandManifestItemAssets

NameTypeDescription
ConfigIDintegerUnique identifier linking the asset record to its JumpCloud configuration.
IDintegerUnique identifier for the asset entry.
JumpCloudDirectoryInsightsEventCommandManifestItemIDintegerIdentifier linking this asset to the related command manifest item.
KindstringType or category of the asset (e.g., binary, script, configuration file).
Sha256SizeintegerSize of the asset used in calculating the SHA-256 checksum.
UrlstringURL where the asset can be accessed or downloaded.
Sha256sJsonstringJSON array containing SHA-256 hash values for verifying asset integrity.
BatchDatedatetimeDate when this asset record was last synchronized or batched.

JumpCloudDirectoryInsightsEventCommandManifestItems

NameTypeDescription
ConfigIDintegerUnique identifier linking the manifest item record to its JumpCloud configuration.
IDintegerUnique identifier for the manifest item.
JumpCloudDirectoryInsightsEventIDstringIdentifier linking this manifest item to the related directory insights event.
MetadataResourceTypestringThe type of resource represented by the manifest item (e.g., app, profile, script).
MetadataActionstringAction associated with the manifest item (e.g., install, update, remove).
MetadataKindstringSpecific kind or classification of the item (e.g., configuration, binary).
MetadataBundleVersionstringVersion of the bundle associated with the manifest item.
MetadataBundleIdentifierstringUnique bundle identifier (e.g., bundle ID for macOS/iOS apps).
MetadataTitlestringHuman-readable title or name of the manifest item.
BatchDatedatetimeDate when this manifest item record was last synchronized or batched.

JumpCloudDirectoryInsightsEventCommandSettings

NameTypeDescription
ConfigIDintegerUnique identifier linking the command settings record to its JumpCloud configuration.
IDintegerUnique identifier for the command settings entry.
JumpCloudDirectoryInsightsEventIDstringIdentifier linking this settings record to the related directory insights event.
ItemstringThe specific command or configuration item associated with these settings.
MdmOptionsActivationLockAllowedWhileSupervisedbitIndicates whether Activation Lock is allowed while the device is supervised (MDM setting).
BatchDatedatetimeDate when this command settings record was last synchronized or batched.

JumpCloudDirectoryInsightsEventErrorChains

NameTypeDescription
ConfigIDintegerUnique identifier linking the error chain record to its JumpCloud configuration.
IDintegerUnique identifier for the error chain entry.
JumpCloudDirectoryInsightsEventIDstringIdentifier linking this error chain to the related directory insights event.
ErrorDomainstringDomain or category of the error (e.g., system, network, authentication).
LocalizedDescriptionstringHuman-readable description of the error in the device’s local language.
UsEnglishDescriptionstringEnglish-language description of the error.
ErrorCodeintegerNumeric or string code representing the error type.
BatchDatedatetimeDate when this error chain record was last synchronized or batched.

JumpCloudDirectoryInsightsEventPoliciesApplied

NameTypeDescription
ConfigIDintegerUnique identifier linking the applied policy record to its JumpCloud configuration.
IDintegerUnique identifier for the applied policy entry.
JumpCloudDirectoryInsightsEventIDstringIdentifier linking this policy application to the related directory insights event.
PolicyIDstringUnique identifier of the policy that was applied.
NamestringHuman-readable name of the applied policy.
MetadataResourceTypestringType of resource the policy applies to (e.g., system, device, user).
MetadataActionstringAction taken by the policy (e.g., enforce, restrict, configure).
MetadataKindstringSpecific kind or classification of the policy (e.g., password, security).
MetadataBundleVersionstringVersion of the bundle associated with the policy.
MetadataBundleIdentifierstringUnique bundle identifier associated with the policy.
MetadataTitlestringHuman-readable title or description of the policy bundle.
BatchDatedatetimeDate when this applied policy record was last synchronized or batched.

JumpCloudDirectoryInsightsEventProfileListPayloadContents

NameTypeDescription
ConfigIDintegerUnique identifier linking the payload content record to its JumpCloud configuration.
IDintegerUnique identifier for the payload content entry.
JumpCloudDirectoryInsightsEventProfileListIDintegerIdentifier linking this payload content to the related profile list event.
ProfileListPayloadUuidstringUUID of the profile list payload.
PayloadUuidstringUUID of the individual payload.
PayloadTypestringType of the payload (e.g., configuration profile, policy).
PayloadVersionintegerVersion number of the payload.
PayloadIdentifierstringUnique identifier assigned to the payload.
PayloadOrganizationstringOrganization associated with the payload.
PayloadDescriptionstringHuman-readable description of the payload.
PayloadDisplayNamestringDisplay name of the payload as shown to end users or administrators.
BatchDatedatetimeDate when this payload content record was last synchronized or batched.

JumpCloudDirectoryInsightsEventProfileLists

NameTypeDescription
ConfigIDintegerUnique identifier linking the profile list record to its JumpCloud configuration.
IDintegerUnique identifier for the profile list entry.
JumpCloudDirectoryInsightsEventIDstringIdentifier linking this profile list to the related directory insights event.
PayloadUuidstringUUID of the payload associated with this profile list.
PayloadRemovalDisallowedbitIndicates if removal of the payload is disallowed.
SignerCertificatesJsonstringJSON array of certificates used to sign the payload.
PayloadIdentifierstringUnique identifier assigned to the payload.
IsEncryptedbitBoolean indicating if the payload is encrypted.
PayloadOrganizationstringOrganization associated with the payload.
HasRemovalPasscodebitIndicates if a passcode is required to remove the payload.
PayloadDisplayNamestringDisplay name of the payload.
PayloadVerionintegerVersion of the payload.
PayloadDescriptionstringHuman-readable description of the payload.
IsManagedbitBoolean indicating whether the payload is managed by MDM.
BatchDatedatetimeDate when this profile list record was last synchronized or batched.

JumpCloudDirectoryInsightsEvents

NameTypeDescription
ConfigIDintegerUnique identifier linking the event record to its JumpCloud configuration.
IDstringUnique identifier for the directory insights event.
EventTypestringType of the event (e.g., authentication, system, software update).
SuccessbitBoolean indicating if the event was successfully completed.
ServicestringService or component associated with the event.
OrganizationstringOrganization associated with the event.
VersionstringVersion of the software or agent generating the event.
SystemTimestampdatetimeTimestamp recorded by the system generating the event.
ClientIpstringIP address of the client system that triggered the event.
MessagestringHuman-readable message describing the event.
TimestampSourcestringSource of the timestamp (system, client, server).
RepeatCountintegerNumber of times this event was repeated or retried.
UsernamestringUsername associated with the event, if applicable.
ServerTimestampRawstringRaw server timestamp for the event.
TimestampRawstringRaw event timestamp as captured.
InitiatedByTypestringType of initiator (e.g., user, admin,system).
InitiatedByIDstringIdentifier of the entity that initiated the event.
InitiatedByUsernamestringUsername of the entity that initiated the event.
InitiatedByAdministratorbitBoolean indicating if the initiator is an administrator.
InitiatedByUserIDstringUser ID of the initiator.
InitiatedByEmailstringEmail address of the initiator.
InitiatedBySourceMetadataSourceNamestringSource system name from which the event was initiated.
GeoipCountryCodestringCountry code derived from the client IP address.
GeoipTimezonestringTimezone derived from the client IP address.
GeoipLatitudefloatLatitude derived from the client IP address.
GeoipContinentCodestringContinent code derived from the client IP address.
GeoipRegionNamestringName of the region derived from the client IP address.
GeoipLongitudefloatLongitude derived from the client IP address.
GeoipRegionCodestringRegion code derived from the client IP address.
SystemHostnamestringHostname of the system generating the event.
SystemDisplayNamestringDisplay name of the system generating the event.
SystemIDstringUnique system ID within JumpCloud.
SystemOsFamilystringOperating system family (e.g., macOS, Windows).
SystemOsstringOperating system name and version.
SystemVersionstringSpecific version of the OS on the system.
AuthContextSystemHostnamestringHostname in the authentication context.
AuthContextSystemDisplayNamestringDisplay name in the authentication context.
AuthContextSystemIDstringSystem ID in the authentication context.
AuthContextSystemOsFamilystringOS family in the authentication context.
AuthContextSystemOsstringOS name/version in the authentication context.
AuthContextSystemVersionstringOS version in the authentication context.
ApplicationPathstringFile path of the application involved in the event.
ApplicationUninstallStringstringCommand or string used to uninstall the application.
ApplicationNamestringName of the application.
ApplicationPublisherstringPublisher or vendor of the application.
ApplicationVersionstringVersion of the application.
ApplicationDisplayLabelstringDisplay label of the application.
ApplicationSsoTypestringType of SSO associated with the application.
ApplicationIDstringJumpCloud ID of the application.
ApplicationSsoUrlstringSSO URL for the application.
ResourceIDstringIdentifier for the resource involved in the event.
ResourceTypestringType of resource (e.g., system, user, application).
ResourceApplicationNamestringName of the resource’s application, if applicable.
ResourceLoginTypestringType of login associated with the resource (e.g., password, SSO).
ResourceUserIDstringUser ID associated with the resource.
ResourceAccountIdentifierstringAccount identifier for the resource.
ResourceAccountEmailstringEmail associated with the resource account.
ResourceAccountIDstringJumpCloud ID of the resource account.
ResourceUsernamestringUsername for the resource.
ResourceDisplayLabelstringDisplay label for the resource.
ResourceDisplayNamestringHuman-readable name of the resource.
ResourceNamestringName of the resource.
ResourcePolicyTemplateNamestringName of the policy template applied to the resource.
ResourcePolicyIDstringIdentifier of the policy applied to the resource.
ResourcePolicyNamestringName of the policy applied to the resource.
ResourcePolicyTemplateIDstringID of the policy template applied.
ResourceHostnamestringHostname of the resource system.
ResourceLoginTimestampdatetimeTimestamp of the resource login.
DiscoveryInfoBrowserIDstringIdentifier of the browser discovered during the event.
DiscoveryInfoDiscoveryTypestringType of discovery (e.g., agent, network scan).
DiscoveryInfoExtensionVersionstringVersion of the discovered browser extension.
DiscoveryInfoBrowserTypestringType of browser (e.g., Chrome, Firefox).
DiscoveryInfoBrowserVersionstringVersion of the discovered browser.
DiscoveryInfoConnectorIDstringConnector ID used to collect the discovery information.
DiscoveryInfoUserAgentVersionstringUser agent version string collected.
DiscoveryInfoSystemIDstringSystem ID associated with the discovery info.
DiscoveryInfoUserAgentOsstringOperating system as reported by the user agent.
DiscoveryInfoSourceEventIDstringSource event ID for discovery tracking.
DiscoveryInfoUserAgentNamestringUser agent name collected during discovery.
UserAgentMinorstringMinor version number of the user agent.
UserAgentOsstringOperating system reported by the user agent.
UserAgentOsMinorstringMinor version of the OS from the user agent.
UserAgentOsVersionstringFull OS version string from the user agent.
UserAgentOsMajorstringMajor version of the OS from the user agent.
UserAgentVersionstringVersion of the user agent.
UserAgentOsPatchstringOS patch version reported by the user agent.
UserAgentPatchstringPatch version of the user agent.
UserAgentOsFullstringComplete OS version string.
UserAgentMajorstringMajor version of the user agent.
UserAgentNamestringName of the user agent.
UserAgentOsNamestringName of the OS from the user agent.
UserAgentDevicestringDevice type reported by the user agent.
AuthMethodsJumpcloudGoSuccessbitIndicates successful JumpCloud Go authentication.
AuthMethodsJumpcloudGoUvSuccessbitIndicates successful JumpCloud Go UV authentication.
AuthMethodsTotpSuccessbitIndicates successful TOTP authentication.
AuthMethodsPasswordSuccessbitIndicates successful password authentication.
AuthMethodsWebauthnSuccessbitIndicates successful WebAuthn authentication.
AuthMetaUserPasswordEnabledbitFlag indicating if user password authentication is enabled.
AuthMetaDeviceCertEnabledbitFlag indicating if device certificate authentication is enabled.
AuthMetaUserCertEnabledbitFlag indicating if user certificate authentication is enabled.
AuthMetaAuthIdpstringIdentity provider used for authentication.
AuthMetaUseridTypestringType of user ID used in authentication.
AuthMetaAuthMethodsJumpcloudGoSuccessbitMetadata flag for JumpCloud Go authentication success.
AuthMetaAuthMethodsJumpcloudGoUvSuccessbitMetadata flag for JumpCloud Go UV authentication success.
AuthMetaAuthMethodsTotpSuccessbitMetadata flag for TOTP authentication success.
AuthMetaAuthMethodsPasswordSuccessbitMetadata flag for password authentication success.
AuthMetaAuthMethodsWebauthnSuccessbitMetadata flag for WebAuthn authentication success.
MfabitIndicates if multi-factor authentication was used.
AuthTypestringType of authentication performed.
AuthMethodstringMethod used for authentication (e.g., password, token).
ProviderstringAuthentication provider used.
NasMfaStatestringMFA state for NAS authentication.
MfaMetaTypestringType of MFA used (e.g., TOTP, WebAuthn).
RequestTypestringType of request generating the event.
CommandUuidstringUUID for command associated with the event.
CommandRequestTypestringType of command requested.
CommandPayloadstringPayload associated with the command.
CommandItemsJsonstringJSON array of items included in the command.
CommandQueriesJsonstringJSON array of queries included in the command.
CommandManagedAppsOnlybitBoolean indicating if the command applies to managed applications only.
CommandForcebitBoolean flag indicating if the command was forced.
StartTlsbitIndicates if STARTTLS was used in the connection.
TlsEstablishedbitBoolean flag showing if TLS was established.
DnstringDistinguished Name (DN) involved in the event.
MechstringAuthentication mechanism used.
ConnectionIdstringIdentifier for the connection associated with the event.
ErrorCodeintegerError code generated during the event.
OperationNumberintegerNumeric identifier of the operation.
DerefintegerIndicates if dereferencing was used (e.g., LDAP).
FilterstringFilter applied to the operation or query.
ScopeintegerScope of the operation or event.
NumberOfResultsintegerNumber of results returned by the operation.
AttrstringAttributes involved in the event.
BasestringBase DN or path for the operation.
MdmTypestringType of MDM managing the system.
StatusstringStatus of the event or operation.
ErrorMessagestringDescription of any error encountered.
OperationTypestringType of operation performed (e.g., read, write, update).
PreviousStatestringState before the operation occurred.
StatestringState after the operation occurred.
ClientIdstringIdentifier for the client performing the action.
MessageChainResponseCodestringResponse code from a message chain.
MessageChainResponseMessagestringResponse message from a message chain.
MessageChainMessageDetailsstringDetailed information from message chain processing.
LogFilePathstringPath to the log file related to the event.
EapTypestringEAP (Extensible Authentication Protocol) type used.
OuterUsernamestringOuter username used in authentication.
RequireTlsAuthbitBoolean indicating if TLS authentication is required.
DetailstringDetailed description of the event.
ProcessNamestringName of the process involved in the event.
SsoTokenSuccessbitBoolean indicating if SSO token authentication succeeded.
IdpInitiatedbitBoolean indicating if the event was initiated by the identity provider.
ManagementStatusIsUserEnrollmentbitIndicates if the system is enrolled via MDM.
ManagementStatusIsActivationLockManageablebitIndicates if Activation Lock is manageable.
ManagementStatusUserApprovedEnrollmentbitIndicates if user-approved enrollment occurred.
ManagementStatusEnrolledViaDepbitIndicates if enrollment occurred via DEP.
SecureBootSecureBootLevelstringSecure Boot level of the system.
WindowsMetaUserTasksstringJSON array of user tasks on Windows systems.
WindowsMetaUserProcessstringJSON array of user processes on Windows systems.
WindowsMetaElevatedstringBoolean indicating if processes are elevated.
WindowsMetaUserServicesstringJSON array of user services on Windows systems.
WindowsMetaLogonTypestringLogon type on Windows systems.
QueryResponsesDeviceNamestringDevice name from query responses.
QueryResponsesModelNamestringDevice model name from query responses.
QueryResponsesIsSupervisedbitIndicates if the device is supervised.
QueryResponsesAvailableDeviceCapacityfloatAvailable device storage capacity.
QueryResponsesOsVersionstringOS version reported in query responses.
QueryResponsesWifiMacstringWi-Fi MAC address of the device.
QueryResponsesMdmOptionsActivationLockAllowedWhileSupervisedbitMDM option indicating Activation Lock behavior.
QueryResponsesProductNamestringProduct name reported in query responses.
QueryResponsesDeviceCapacityfloatTotal device capacity.
MgmtClientCapabilitiesSupportedVersionsJsonstringJSON array of supported management client versions.
MgmtSupportedPayloadsStatusItemsJsonstringJSON array of supported payload statuses.
MgmtDeclarationsAssetsJsonstringJSON array of declared assets.
MgmtDeclarationsManagementJsonstringJSON array of management declarations.
MgmtDeclarationsConfigurationsJsonstringJSON array of configuration declarations.
MgmtDeclarationsActivationsJsonstringJSON array of activation declarations.
DiskmanagementFilevaultEnabledbitIndicates if FileVault is enabled on macOS devices.
DeviceIdentifierSerialNumberstringSerial number of the device.
DeviceOperatingSystemFamilystringOS family of the device (e.g., Windows, macOS).
DeviceOperatingSystemVersionstringOS version of the device.
DeviceOperatingSystemBuildVersionstringOS build version of the device.
DeviceOperatingSystemMarketingNamestringMarketing name of the device OS.
DeviceOperatingSystemSupplementalBuildVersionstringSupplemental build version of the OS.
DeviceOperatingSystemSupplementalExtraVersionstringExtra supplemental version info of the OS.
DeviceModelNumberstringModel number of the device.
DeviceModelIdentifierstringDevice model identifier.
DeviceModelFamilystringDevice model family.
DeviceModelMarketingNamestringMarketing name of the device model.
SoftwareupdateInstallStatestringInstall state of software updates.
SoftwareupdatePendingVersionOsVersionstringOS version of pending software updates.
SoftwareupdatePendingVersionBuildVersionstringBuild version of pending software updates.
SoftwareupdateFailureReasonCountintegerCount of failure reasons for software updates.
SoftwareupdateFailureReasonReasonstringReason for software update failure.
SoftwareupdateFailureReasonTimestampdatetimeTimestamp of the software update failure.
SoftwareupdateDeviceIDstringDevice ID for the software update.
SoftwareupdateInstallReasonJsonstringJSON array of reasons for software update installation.
ScanInitiatedbitTimestamp indicating when a scan was initiated.
EventOriginalstringOriginal event payload or log.
AssociationOpstringType of association operation.
AssociationActionSourcestringSource of the association action.
AssociationAttributesJsonstringJSON array of attributes involved in the association.
AssociationConnectionFromNamestringName of the source connection.
AssociationConnectionFromTypestringType of the source connection.
AssociationConnectionFromObjectIDstringObject ID of the source connection.
AssociationConnectionToNamestringName of the target connection.
AssociationConnectionToTypestringType of the target connection.
AssociationConnectionToObjectIDstringObject ID of the target connection.
MdmDeviceIDstringIdentifier for the MDM-managed device.
MdmDeviceManagerIDstringIdentifier for the MDM device manager.
TargetResourceTypestringType of the target resource.
StatusReportErrorsJsonstringJSON array of errors reported in status reports.
StatusReportFullReportbitComplete status report content.
BatchDatedatetimeDate when this directory insights event record was last synchronized or batched.

Bridge Tables

JumpCloudDirectories_JumpCloudGroups

NameTypeDescription
JumpCloudDirectoryModelIDstringUnique identifier of the JumpCloud directory in the bridge table.
JumpCloudDirectoryModelConfigIDintegerConfiguration identifier for the associated directory.
JumpCloudGroupModelIDstringUnique identifier of the JumpCloud group in the bridge table.
JumpCloudGroupModelConfigIDintegerConfiguration identifier for the associated group.

JumpCloudDirectories_JumpCloudUsers

NameTypeDescription
JumpCloudDirectoryModelIDstringUnique identifier of the JumpCloud directory in the bridge table.
JumpCloudDirectoryModelConfigIDintegerConfiguration identifier for the associated directory.
JumpCloudUserModelIDstringUnique identifier of the JumpCloud user in the bridge table.
JumpCloudUserModelConfigIDintegerConfiguration identifier for the associated user.

Did this page help you?