JumpCloud Directory and Bridge Tables
Tables
JumpCloudDirectories
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the directory record to its configuration in JumpCloud. |
| ID | string | Unique identifier for the directory object. |
| Type | string | The directory type (e.g., active Directory, LDAP, G Suite, etc.). |
| Name | string | Human-readable name of the directory. |
| OAuthStatusExpirySeconds | string | Expiration time in seconds for the OAuth status token used in the directory. |
| OAuthStatusExpiryNanos | integer | Expiration time in nanoseconds for the OAuth status token. |
| OAuthStatusError | string | Error code representing any OAuth connection issue. |
| OAuthStatusErrorMessage | string | Descriptive error message for OAuth connection issues. |
| BatchDate | datetime | The date when this directory record was last synchronized or batched. |
| GroupsEnabled | bit | Indicates whether directory group synchronization is enabled. |
| ImportFilter | string | Defines filters for which directory users/groups are imported. |
| UserLockoutAction | string | Configured action taken when a user is locked out from this directory. |
| UserPasswordExpirationAction | string | Configured action taken when a user’s password in the directory expires. |
JumpCloudDirectoryInsightsEventAvailableOsUpdates
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the OS update record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the OS update entry. |
| JumpCloudDirectoryInsightsEventID | string | Identifier linking this update to the corresponding directory insights event. |
| AllowsInstallLater | bit | Indicates if the update allows users to postpone installation. |
| RestartRequired | bit | Specifies if the update requires a system restart to complete installation. |
| MetadataUrl | string | URL pointing to metadata about the update (e.g., Apple or OS vendor update info). |
| IsConfigDataUpdate | bit | Indicates if the update is a configuration data update rather than a full OS update. |
| HumanReadableName | string | User-friendly name of the update (e.g., macOS Sonoma 14.2). |
| AppIdentifiersToCloseJson | string | JSON list of app identifiers that must be closed before applying the update. |
| ProductName | string | Official product name associated with the update. |
| Version | string | Version number of the update. |
| IsFirmwareUpdate | bit | Indicates if the update includes firmware updates in addition to OS changes. |
| RequiresBootstrapToken | bit | Shows if the update requires a bootstrap token for installation. |
| HumanReadableNameLocale | string | Locale-specific display name of the update. |
| ProductKey | string | Unique product key associated with the update. |
| Build | string | Build identifier for the OS update. |
| InstallSize | float | Estimated size of the update when installed (in MB/GB). |
| IsMajorOsUpdate | bit | Indicates if the update is a major OS upgrade (e.g., macOS 13 > macOS 14). |
| DownloadSizeJson | string | JSON representation of the download size of the update. |
| IsCritical | bit | Specifies if the update is marked as critical (e.g., urgent security patch). |
| BatchDate | datetime | The date when this OS update record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventBackgroundTasks
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the background task record to its JumpCloud configuration. |
| UUID | integer | Universally unique identifier for the background task entry. |
| JumpCloudDirectoryInsightsEventID | string | Identifier linking this record to the related directory insights event. |
| Path | string | File system path of the background task or launch item. |
| Identifier | string | Unique identifier string for the background task. |
| State | string | Current state of the background task (e.g., running, stopped, disabled). |
| Type | string | Type of background task (e.g., launch daemon, launch agent, scheduled task). |
| CodeSignature | string | Information about the code signature of the executable (validity, signer, etc.). |
| Removed | bit | Indicates whether the task has been removed from the system. |
| LaunchdChecksum | string | Checksum value for the associated launchd configuration file. |
| LaunchdProgram | string | Path to the program or executable managed by the background task. |
| LaunchdLabel | string | Label name used by launchd for identifying the task. |
| LaunchdProgramArgumentsJson | string | JSON array containing arguments passed to the program when executed. |
| BatchDate | datetime | Date when this background task record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventChanges
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the change record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the individual change entry. |
| JumpCloudDirectoryInsightsEventID | string | Identifier linking this change record to the related directory insights event. |
| Field | string | The field or attribute within the event that was changed. |
| FromJson | string | JSON representation of the value before the change occurred. |
| ToJson | string | JSON representation of the updated value after the change. |
| BatchDate | datetime | Date when this change record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventCommandManifestItemAssets
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the asset record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the asset entry. |
| JumpCloudDirectoryInsightsEventCommandManifestItemID | integer | Identifier linking this asset to the related command manifest item. |
| Kind | string | Type or category of the asset (e.g., binary, script, configuration file). |
| Sha256Size | integer | Size of the asset used in calculating the SHA-256 checksum. |
| Url | string | URL where the asset can be accessed or downloaded. |
| Sha256sJson | string | JSON array containing SHA-256 hash values for verifying asset integrity. |
| BatchDate | datetime | Date when this asset record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventCommandManifestItems
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the manifest item record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the manifest item. |
| JumpCloudDirectoryInsightsEventID | string | Identifier linking this manifest item to the related directory insights event. |
| MetadataResourceType | string | The type of resource represented by the manifest item (e.g., app, profile, script). |
| MetadataAction | string | Action associated with the manifest item (e.g., install, update, remove). |
| MetadataKind | string | Specific kind or classification of the item (e.g., configuration, binary). |
| MetadataBundleVersion | string | Version of the bundle associated with the manifest item. |
| MetadataBundleIdentifier | string | Unique bundle identifier (e.g., bundle ID for macOS/iOS apps). |
| MetadataTitle | string | Human-readable title or name of the manifest item. |
| BatchDate | datetime | Date when this manifest item record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventCommandSettings
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the command settings record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the command settings entry. |
| JumpCloudDirectoryInsightsEventID | string | Identifier linking this settings record to the related directory insights event. |
| Item | string | The specific command or configuration item associated with these settings. |
| MdmOptionsActivationLockAllowedWhileSupervised | bit | Indicates whether Activation Lock is allowed while the device is supervised (MDM setting). |
| BatchDate | datetime | Date when this command settings record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventErrorChains
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the error chain record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the error chain entry. |
| JumpCloudDirectoryInsightsEventID | string | Identifier linking this error chain to the related directory insights event. |
| ErrorDomain | string | Domain or category of the error (e.g., system, network, authentication). |
| LocalizedDescription | string | Human-readable description of the error in the device’s local language. |
| UsEnglishDescription | string | English-language description of the error. |
| ErrorCode | integer | Numeric or string code representing the error type. |
| BatchDate | datetime | Date when this error chain record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventPoliciesApplied
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the applied policy record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the applied policy entry. |
| JumpCloudDirectoryInsightsEventID | string | Identifier linking this policy application to the related directory insights event. |
| PolicyID | string | Unique identifier of the policy that was applied. |
| Name | string | Human-readable name of the applied policy. |
| MetadataResourceType | string | Type of resource the policy applies to (e.g., system, device, user). |
| MetadataAction | string | Action taken by the policy (e.g., enforce, restrict, configure). |
| MetadataKind | string | Specific kind or classification of the policy (e.g., password, security). |
| MetadataBundleVersion | string | Version of the bundle associated with the policy. |
| MetadataBundleIdentifier | string | Unique bundle identifier associated with the policy. |
| MetadataTitle | string | Human-readable title or description of the policy bundle. |
| BatchDate | datetime | Date when this applied policy record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventProfileListPayloadContents
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the payload content record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the payload content entry. |
| JumpCloudDirectoryInsightsEventProfileListID | integer | Identifier linking this payload content to the related profile list event. |
| ProfileListPayloadUuid | string | UUID of the profile list payload. |
| PayloadUuid | string | UUID of the individual payload. |
| PayloadType | string | Type of the payload (e.g., configuration profile, policy). |
| PayloadVersion | integer | Version number of the payload. |
| PayloadIdentifier | string | Unique identifier assigned to the payload. |
| PayloadOrganization | string | Organization associated with the payload. |
| PayloadDescription | string | Human-readable description of the payload. |
| PayloadDisplayName | string | Display name of the payload as shown to end users or administrators. |
| BatchDate | datetime | Date when this payload content record was last synchronized or batched. |
JumpCloudDirectoryInsightsEventProfileLists
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the profile list record to its JumpCloud configuration. |
| ID | integer | Unique identifier for the profile list entry. |
| JumpCloudDirectoryInsightsEventID | string | Identifier linking this profile list to the related directory insights event. |
| PayloadUuid | string | UUID of the payload associated with this profile list. |
| PayloadRemovalDisallowed | bit | Indicates if removal of the payload is disallowed. |
| SignerCertificatesJson | string | JSON array of certificates used to sign the payload. |
| PayloadIdentifier | string | Unique identifier assigned to the payload. |
| IsEncrypted | bit | Boolean indicating if the payload is encrypted. |
| PayloadOrganization | string | Organization associated with the payload. |
| HasRemovalPasscode | bit | Indicates if a passcode is required to remove the payload. |
| PayloadDisplayName | string | Display name of the payload. |
| PayloadVerion | integer | Version of the payload. |
| PayloadDescription | string | Human-readable description of the payload. |
| IsManaged | bit | Boolean indicating whether the payload is managed by MDM. |
| BatchDate | datetime | Date when this profile list record was last synchronized or batched. |
JumpCloudDirectoryInsightsEvents
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier linking the event record to its JumpCloud configuration. |
| ID | string | Unique identifier for the directory insights event. |
| EventType | string | Type of the event (e.g., authentication, system, software update). |
| Success | bit | Boolean indicating if the event was successfully completed. |
| Service | string | Service or component associated with the event. |
| Organization | string | Organization associated with the event. |
| Version | string | Version of the software or agent generating the event. |
| SystemTimestamp | datetime | Timestamp recorded by the system generating the event. |
| ClientIp | string | IP address of the client system that triggered the event. |
| Message | string | Human-readable message describing the event. |
| TimestampSource | string | Source of the timestamp (system, client, server). |
| RepeatCount | integer | Number of times this event was repeated or retried. |
| Username | string | Username associated with the event, if applicable. |
| ServerTimestampRaw | string | Raw server timestamp for the event. |
| TimestampRaw | string | Raw event timestamp as captured. |
| InitiatedByType | string | Type of initiator (e.g., user, admin,system). |
| InitiatedByID | string | Identifier of the entity that initiated the event. |
| InitiatedByUsername | string | Username of the entity that initiated the event. |
| InitiatedByAdministrator | bit | Boolean indicating if the initiator is an administrator. |
| InitiatedByUserID | string | User ID of the initiator. |
| InitiatedByEmail | string | Email address of the initiator. |
| InitiatedBySourceMetadataSourceName | string | Source system name from which the event was initiated. |
| GeoipCountryCode | string | Country code derived from the client IP address. |
| GeoipTimezone | string | Timezone derived from the client IP address. |
| GeoipLatitude | float | Latitude derived from the client IP address. |
| GeoipContinentCode | string | Continent code derived from the client IP address. |
| GeoipRegionName | string | Name of the region derived from the client IP address. |
| GeoipLongitude | float | Longitude derived from the client IP address. |
| GeoipRegionCode | string | Region code derived from the client IP address. |
| SystemHostname | string | Hostname of the system generating the event. |
| SystemDisplayName | string | Display name of the system generating the event. |
| SystemID | string | Unique system ID within JumpCloud. |
| SystemOsFamily | string | Operating system family (e.g., macOS, Windows). |
| SystemOs | string | Operating system name and version. |
| SystemVersion | string | Specific version of the OS on the system. |
| AuthContextSystemHostname | string | Hostname in the authentication context. |
| AuthContextSystemDisplayName | string | Display name in the authentication context. |
| AuthContextSystemID | string | System ID in the authentication context. |
| AuthContextSystemOsFamily | string | OS family in the authentication context. |
| AuthContextSystemOs | string | OS name/version in the authentication context. |
| AuthContextSystemVersion | string | OS version in the authentication context. |
| ApplicationPath | string | File path of the application involved in the event. |
| ApplicationUninstallString | string | Command or string used to uninstall the application. |
| ApplicationName | string | Name of the application. |
| ApplicationPublisher | string | Publisher or vendor of the application. |
| ApplicationVersion | string | Version of the application. |
| ApplicationDisplayLabel | string | Display label of the application. |
| ApplicationSsoType | string | Type of SSO associated with the application. |
| ApplicationID | string | JumpCloud ID of the application. |
| ApplicationSsoUrl | string | SSO URL for the application. |
| ResourceID | string | Identifier for the resource involved in the event. |
| ResourceType | string | Type of resource (e.g., system, user, application). |
| ResourceApplicationName | string | Name of the resource’s application, if applicable. |
| ResourceLoginType | string | Type of login associated with the resource (e.g., password, SSO). |
| ResourceUserID | string | User ID associated with the resource. |
| ResourceAccountIdentifier | string | Account identifier for the resource. |
| ResourceAccountEmail | string | Email associated with the resource account. |
| ResourceAccountID | string | JumpCloud ID of the resource account. |
| ResourceUsername | string | Username for the resource. |
| ResourceDisplayLabel | string | Display label for the resource. |
| ResourceDisplayName | string | Human-readable name of the resource. |
| ResourceName | string | Name of the resource. |
| ResourcePolicyTemplateName | string | Name of the policy template applied to the resource. |
| ResourcePolicyID | string | Identifier of the policy applied to the resource. |
| ResourcePolicyName | string | Name of the policy applied to the resource. |
| ResourcePolicyTemplateID | string | ID of the policy template applied. |
| ResourceHostname | string | Hostname of the resource system. |
| ResourceLoginTimestamp | datetime | Timestamp of the resource login. |
| DiscoveryInfoBrowserID | string | Identifier of the browser discovered during the event. |
| DiscoveryInfoDiscoveryType | string | Type of discovery (e.g., agent, network scan). |
| DiscoveryInfoExtensionVersion | string | Version of the discovered browser extension. |
| DiscoveryInfoBrowserType | string | Type of browser (e.g., Chrome, Firefox). |
| DiscoveryInfoBrowserVersion | string | Version of the discovered browser. |
| DiscoveryInfoConnectorID | string | Connector ID used to collect the discovery information. |
| DiscoveryInfoUserAgentVersion | string | User agent version string collected. |
| DiscoveryInfoSystemID | string | System ID associated with the discovery info. |
| DiscoveryInfoUserAgentOs | string | Operating system as reported by the user agent. |
| DiscoveryInfoSourceEventID | string | Source event ID for discovery tracking. |
| DiscoveryInfoUserAgentName | string | User agent name collected during discovery. |
| UserAgentMinor | string | Minor version number of the user agent. |
| UserAgentOs | string | Operating system reported by the user agent. |
| UserAgentOsMinor | string | Minor version of the OS from the user agent. |
| UserAgentOsVersion | string | Full OS version string from the user agent. |
| UserAgentOsMajor | string | Major version of the OS from the user agent. |
| UserAgentVersion | string | Version of the user agent. |
| UserAgentOsPatch | string | OS patch version reported by the user agent. |
| UserAgentPatch | string | Patch version of the user agent. |
| UserAgentOsFull | string | Complete OS version string. |
| UserAgentMajor | string | Major version of the user agent. |
| UserAgentName | string | Name of the user agent. |
| UserAgentOsName | string | Name of the OS from the user agent. |
| UserAgentDevice | string | Device type reported by the user agent. |
| AuthMethodsJumpcloudGoSuccess | bit | Indicates successful JumpCloud Go authentication. |
| AuthMethodsJumpcloudGoUvSuccess | bit | Indicates successful JumpCloud Go UV authentication. |
| AuthMethodsTotpSuccess | bit | Indicates successful TOTP authentication. |
| AuthMethodsPasswordSuccess | bit | Indicates successful password authentication. |
| AuthMethodsWebauthnSuccess | bit | Indicates successful WebAuthn authentication. |
| AuthMetaUserPasswordEnabled | bit | Flag indicating if user password authentication is enabled. |
| AuthMetaDeviceCertEnabled | bit | Flag indicating if device certificate authentication is enabled. |
| AuthMetaUserCertEnabled | bit | Flag indicating if user certificate authentication is enabled. |
| AuthMetaAuthIdp | string | Identity provider used for authentication. |
| AuthMetaUseridType | string | Type of user ID used in authentication. |
| AuthMetaAuthMethodsJumpcloudGoSuccess | bit | Metadata flag for JumpCloud Go authentication success. |
| AuthMetaAuthMethodsJumpcloudGoUvSuccess | bit | Metadata flag for JumpCloud Go UV authentication success. |
| AuthMetaAuthMethodsTotpSuccess | bit | Metadata flag for TOTP authentication success. |
| AuthMetaAuthMethodsPasswordSuccess | bit | Metadata flag for password authentication success. |
| AuthMetaAuthMethodsWebauthnSuccess | bit | Metadata flag for WebAuthn authentication success. |
| Mfa | bit | Indicates if multi-factor authentication was used. |
| AuthType | string | Type of authentication performed. |
| AuthMethod | string | Method used for authentication (e.g., password, token). |
| Provider | string | Authentication provider used. |
| NasMfaState | string | MFA state for NAS authentication. |
| MfaMetaType | string | Type of MFA used (e.g., TOTP, WebAuthn). |
| RequestType | string | Type of request generating the event. |
| CommandUuid | string | UUID for command associated with the event. |
| CommandRequestType | string | Type of command requested. |
| CommandPayload | string | Payload associated with the command. |
| CommandItemsJson | string | JSON array of items included in the command. |
| CommandQueriesJson | string | JSON array of queries included in the command. |
| CommandManagedAppsOnly | bit | Boolean indicating if the command applies to managed applications only. |
| CommandForce | bit | Boolean flag indicating if the command was forced. |
| StartTls | bit | Indicates if STARTTLS was used in the connection. |
| TlsEstablished | bit | Boolean flag showing if TLS was established. |
| Dn | string | Distinguished Name (DN) involved in the event. |
| Mech | string | Authentication mechanism used. |
| ConnectionId | string | Identifier for the connection associated with the event. |
| ErrorCode | integer | Error code generated during the event. |
| OperationNumber | integer | Numeric identifier of the operation. |
| Deref | integer | Indicates if dereferencing was used (e.g., LDAP). |
| Filter | string | Filter applied to the operation or query. |
| Scope | integer | Scope of the operation or event. |
| NumberOfResults | integer | Number of results returned by the operation. |
| Attr | string | Attributes involved in the event. |
| Base | string | Base DN or path for the operation. |
| MdmType | string | Type of MDM managing the system. |
| Status | string | Status of the event or operation. |
| ErrorMessage | string | Description of any error encountered. |
| OperationType | string | Type of operation performed (e.g., read, write, update). |
| PreviousState | string | State before the operation occurred. |
| State | string | State after the operation occurred. |
| ClientId | string | Identifier for the client performing the action. |
| MessageChainResponseCode | string | Response code from a message chain. |
| MessageChainResponseMessage | string | Response message from a message chain. |
| MessageChainMessageDetails | string | Detailed information from message chain processing. |
| LogFilePath | string | Path to the log file related to the event. |
| EapType | string | EAP (Extensible Authentication Protocol) type used. |
| OuterUsername | string | Outer username used in authentication. |
| RequireTlsAuth | bit | Boolean indicating if TLS authentication is required. |
| Detail | string | Detailed description of the event. |
| ProcessName | string | Name of the process involved in the event. |
| SsoTokenSuccess | bit | Boolean indicating if SSO token authentication succeeded. |
| IdpInitiated | bit | Boolean indicating if the event was initiated by the identity provider. |
| ManagementStatusIsUserEnrollment | bit | Indicates if the system is enrolled via MDM. |
| ManagementStatusIsActivationLockManageable | bit | Indicates if Activation Lock is manageable. |
| ManagementStatusUserApprovedEnrollment | bit | Indicates if user-approved enrollment occurred. |
| ManagementStatusEnrolledViaDep | bit | Indicates if enrollment occurred via DEP. |
| SecureBootSecureBootLevel | string | Secure Boot level of the system. |
| WindowsMetaUserTasks | string | JSON array of user tasks on Windows systems. |
| WindowsMetaUserProcess | string | JSON array of user processes on Windows systems. |
| WindowsMetaElevated | string | Boolean indicating if processes are elevated. |
| WindowsMetaUserServices | string | JSON array of user services on Windows systems. |
| WindowsMetaLogonType | string | Logon type on Windows systems. |
| QueryResponsesDeviceName | string | Device name from query responses. |
| QueryResponsesModelName | string | Device model name from query responses. |
| QueryResponsesIsSupervised | bit | Indicates if the device is supervised. |
| QueryResponsesAvailableDeviceCapacity | float | Available device storage capacity. |
| QueryResponsesOsVersion | string | OS version reported in query responses. |
| QueryResponsesWifiMac | string | Wi-Fi MAC address of the device. |
| QueryResponsesMdmOptionsActivationLockAllowedWhileSupervised | bit | MDM option indicating Activation Lock behavior. |
| QueryResponsesProductName | string | Product name reported in query responses. |
| QueryResponsesDeviceCapacity | float | Total device capacity. |
| MgmtClientCapabilitiesSupportedVersionsJson | string | JSON array of supported management client versions. |
| MgmtSupportedPayloadsStatusItemsJson | string | JSON array of supported payload statuses. |
| MgmtDeclarationsAssetsJson | string | JSON array of declared assets. |
| MgmtDeclarationsManagementJson | string | JSON array of management declarations. |
| MgmtDeclarationsConfigurationsJson | string | JSON array of configuration declarations. |
| MgmtDeclarationsActivationsJson | string | JSON array of activation declarations. |
| DiskmanagementFilevaultEnabled | bit | Indicates if FileVault is enabled on macOS devices. |
| DeviceIdentifierSerialNumber | string | Serial number of the device. |
| DeviceOperatingSystemFamily | string | OS family of the device (e.g., Windows, macOS). |
| DeviceOperatingSystemVersion | string | OS version of the device. |
| DeviceOperatingSystemBuildVersion | string | OS build version of the device. |
| DeviceOperatingSystemMarketingName | string | Marketing name of the device OS. |
| DeviceOperatingSystemSupplementalBuildVersion | string | Supplemental build version of the OS. |
| DeviceOperatingSystemSupplementalExtraVersion | string | Extra supplemental version info of the OS. |
| DeviceModelNumber | string | Model number of the device. |
| DeviceModelIdentifier | string | Device model identifier. |
| DeviceModelFamily | string | Device model family. |
| DeviceModelMarketingName | string | Marketing name of the device model. |
| SoftwareupdateInstallState | string | Install state of software updates. |
| SoftwareupdatePendingVersionOsVersion | string | OS version of pending software updates. |
| SoftwareupdatePendingVersionBuildVersion | string | Build version of pending software updates. |
| SoftwareupdateFailureReasonCount | integer | Count of failure reasons for software updates. |
| SoftwareupdateFailureReasonReason | string | Reason for software update failure. |
| SoftwareupdateFailureReasonTimestamp | datetime | Timestamp of the software update failure. |
| SoftwareupdateDeviceID | string | Device ID for the software update. |
| SoftwareupdateInstallReasonJson | string | JSON array of reasons for software update installation. |
| ScanInitiated | bit | Timestamp indicating when a scan was initiated. |
| EventOriginal | string | Original event payload or log. |
| AssociationOp | string | Type of association operation. |
| AssociationActionSource | string | Source of the association action. |
| AssociationAttributesJson | string | JSON array of attributes involved in the association. |
| AssociationConnectionFromName | string | Name of the source connection. |
| AssociationConnectionFromType | string | Type of the source connection. |
| AssociationConnectionFromObjectID | string | Object ID of the source connection. |
| AssociationConnectionToName | string | Name of the target connection. |
| AssociationConnectionToType | string | Type of the target connection. |
| AssociationConnectionToObjectID | string | Object ID of the target connection. |
| MdmDeviceID | string | Identifier for the MDM-managed device. |
| MdmDeviceManagerID | string | Identifier for the MDM device manager. |
| TargetResourceType | string | Type of the target resource. |
| StatusReportErrorsJson | string | JSON array of errors reported in status reports. |
| StatusReportFullReport | bit | Complete status report content. |
| BatchDate | datetime | Date when this directory insights event record was last synchronized or batched. |
Bridge Tables
JumpCloudDirectories_JumpCloudGroups
| Name | Type | Description |
|---|---|---|
| JumpCloudDirectoryModelID | string | Unique identifier of the JumpCloud directory in the bridge table. |
| JumpCloudDirectoryModelConfigID | integer | Configuration identifier for the associated directory. |
| JumpCloudGroupModelID | string | Unique identifier of the JumpCloud group in the bridge table. |
| JumpCloudGroupModelConfigID | integer | Configuration identifier for the associated group. |
JumpCloudDirectories_JumpCloudUsers
| Name | Type | Description |
|---|---|---|
| JumpCloudDirectoryModelID | string | Unique identifier of the JumpCloud directory in the bridge table. |
| JumpCloudDirectoryModelConfigID | integer | Configuration identifier for the associated directory. |
| 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?