JumpCloud Radius, Systems, Users, and Bridge Tables

Tables

JumpCloudRadiusServers

Name	Type	Description
ConfigID	integer	Configuration identifier for the record.
ID	string	Unique identifier of the RADIUS server.
Name	string	Human-readable name of the RADIUS server.
NetworkSourceIp	string	IP address or network source from which RADIUS requests are accepted.
SharedSecret	string	Shared secret used for authentication between RADIUS clients and the server.
Mfa	string	Boolean indicating if multi-factor authentication is enforced.
UserLockoutAction	string	Action taken when a user is locked out due to failed login attempts.
UserPasswordExpirationAction	string	Action enforced when a user’s password has expired.
AuthIdp	string	Identity provider used for authentication.
UserPasswordEnabled	bit	Indicates if password authentication is enabled.
UserCertEnabled	bit	Indicates if user certificate authentication is enabled.
DeviceCertEnabled	bit	Indicates if device certificate authentication is enabled.
CaCert	string	Certificate Authority (CA) certificate used for RADIUS authentication.
RequireTlsAuth	bit	Boolean indicating if TLS authentication is required.
RadsecEnabled	bit	Boolean indicating if RADIUS over TLS (`RadSec`) is enabled.
RequireRadsec	bit	Boolean indicating if RadSec is required.
BatchDate	datetime	Timestamp when the record was collected or batched.

JumpCloudSystems

Name	Type	Description
ConfigID	integer	Configuration identifier for the record.
ID	string	Unique identifier of the system.
Created	datetime	Timestamp when the system was first created in JumpCloud.
LastContact	datetime	Timestamp of the last contact from the system.
Os	string	Operating system name of the system.
OsFamily	string	Operating system family (e.g., `Windows`, `macOS`, `Linux`).
Version	string	OS version.
Arch	string	CPU architecture (e.g., `x86_64`, `ARM`).
ArchFamily	string	Architecture family.
Hostname	string	System hostname.
DisplayName	string	Human-readable display name for the system.
SystemTimezone	integer	Timezone configured on the system.
TemplateName	string	Name of any applied system template.
RemoteIP	string	IP address of the system’s last connection.
`active`	bit	Boolean indicating if the system is active.
AgentHasFullDiskAccess	bit	Indicates if the JumpCloud agent has full disk access.
AllowSshPasswordAuthentication	bit	Boolean indicating if SSH password authentication is allowed.
AllowSshRootLogin	bit	Boolean indicating if SSH root login is allowed.
AllowMultiFactorAuthentication	bit	MFA enforcement status for the system.
AllowPublicKeyAuthentication	bit	Boolean indicating if public key SSH authentication is allowed.
ModifySSHDConfig	bit	Boolean indicating if the SSHD config is modified.
AgentVersion	string	Version of the JumpCloud agent installed on the system.
SshRootEnabled	bit	Indicates if SSH root account is enabled.
HwVendor	string	Hardware vendor of the system.
RemoteAssistAgentVersion	string	Version of the remote assistance agent.
SerialNumber	string	Hardware serial number of the system.
HasServiceAccount	bit	Indicates if the system uses a service account.
FileSystem	string	File system type(s) on the system.
Acknowledged	bit	Indicates if the system has acknowledged any policy or command.
AzureAdJoined	bit	Boolean indicating if the system is Azure AD joined.
Description	string	Description of the system.
DesktopCapable	bit	Boolean indicating if the system is a desktop device.
IsPolicyBound	bit	Indicates if any policies are bound to this system.
DomainInfoPartOfDomain	bit	Boolean indicating if the system is part of a domain.
DomainInfoDomainName	string	Name of the domain the system is joined to.
FdeKeyPresent	bit	Boolean indicating if full-disk encryption key is present.
Fde`active`	bit	Boolean indicating if full-disk encryption is active.
SystemInsightsState	string	Status of system insights collection.
OsVersionDetailMinorNumber	integer	Minor number of the OS version.
OsVersionDetailPatchNumber	integer	Patch number of the OS version.
OsVersionDetailDistributionName	string	Distribution name (for Linux systems).
OsVersionDetailReleaseName	string	Release name of the OS version.
OsVersionDetailMajor	string	Major OS version number.
OsVersionDetailMinor	string	Minor OS version number.
OsVersionDetailPatch	string	Patch version number.
OsVersionDetailRevision	string	Revision number of the OS.
OsVersionDetailVersion	string	Full version string.
OsVersionDetailOsName	string	Name of the operating system.
MdmVendor	string	MDM vendor managing the system.
MdmCreatedAt	datetime	Timestamp of MDM enrollment creation.
MdmUpdatedAt	datetime	Timestamp of the last MDM update.
MdmDep	bit	Boolean indicating if DEP (Device Enrollment Program) is used.
MdmProfileIdentifier	string	Identifier of the MDM profile applied.
MdmUserApproved	bit	Indicates if user approved the MDM enrollment.
MdmEnrollmentType	string	Type of MDM enrollment (e.g., `user-approved`, `automated`).
MdmIsSupervised	bit	Boolean indicating if the device is supervised.
MdmEnrollmentAttempts	integer	Number of MDM enrollment attempts.
MdmProviderID	string	Identifier for the MDM provider.
MdmLostModeEnabled	bit	Indicates if lost mode is enabled.
MdmLostModeStatusJson	string	JSON detailing lost mode status.
MdmPolicyConfJson	string	JSON of applied MDM policy configurations.
MdmInternalWindowsDeviceID	string	Internal device ID for Windows MDM management.
MdmInternalDeviceID	string	Internal device ID for MDM management.
MdmWindowsUpn	string	Windows User Principal Name for MDM-managed devices.
PrimarySystemUserID	string	ID of the primary user on the system.
ProvisionerProvisionerID	string	Identifier of the system provisioner.
NetworkInterfacesJson	string	JSON detailing the system’s network interfaces.
SshdParamsJson	string	JSON with SSHD configuration parameters.
ConnectionHistoryJson	string	JSON of the system’s connection history.
UserMetricsJson	string	JSON of user metrics and activity on the system.
BatchDate	datetime	Timestamp when the record was collected or batched.

JumpCloudUserAddresses

Name	Type	Description
ConfigID	integer	Configuration identifier for the record.
ID	string	Unique identifier of the address record.
JumpCloudUserID	string	Reference to the associated JumpCloud user.
Type	string	Type of address (e.g., `home`, `work`, `mailing`).
PoBox	string	Post office box number, if applicable.
ExtendedAddress	string	Additional address information (e.g., `apartment`, `suite`).
StreetAddress	string	Street address of the user.
Locality	string	City or locality of the address.
Region	string	Region, state, or province of the address.
PostalCode	string	Postal or ZIP code.
Country	string	Country of the address.
BatchDate	datetime	Timestamp when the record was collected or batched.

JumpCloudUserAttributes

Name	Type	Description
ConfigID	integer	Configuration identifier for the record.
ID	string	Unique identifier of the user attribute record.
JumpCloudUserID	string	Reference to the associated JumpCloud user.
Name	string	Name of the attribute (e.g., `department`, `title`).
Value	string	Value assigned to the attribute.
BatchDate	datetime	Timestamp when the record was collected or batched.

JumpCloudUserPhoneNumbers

Name	Type	Description
ConfigID	integer	Configuration identifier for the record.
ID	string	Unique identifier of the phone number record.
JumpCloudUserID	string	Reference to the associated JumpCloud user.
Type	string	Type of phone number (e.g., `mobile`, `work`, `home`).
Number	string	The phone number.
BatchDate	datetime	Timestamp when the record was collected or batched.

JumpCloudUsers

Name	Type	Description
ConfigID	integer	Configuration identifier for the record.
ID	string	Unique identifier of the user.
AllowPublicKey	bit	Indicates if public key authentication is allowed.
AlternateEmail	string	Alternate email address of the user.
Company	string	Company the user belongs to.
CostCenter	string	Cost center associated with the user.
Department	string	Department of the user.
Description	string	Description of the user or role.
disabledeviceMaxLoginAttempts	bit	Boolean indicating if device max login attempts are disabled.
Displayname	string	Full display name of the user.
Email	string	Primary email address.
EmployeeIdentifier	string	Employee identifier (e.g., `staff ID`).
EmployeeType	string	Type of employee (e.g., `contractor`, `full-time`).
EnableManagedUUID	bit	Boolean indicating if managed UUID is enabled.
EnableUserPortalMultifactor	bit	Boolean indicating if MFA for the user portal is enabled.
ExternalDn	string	External distinguished name for LDAP or directory.
ExternalSourceType	string	Type of external source (e.g., `LDAP`, `SAML`).
ExternallyManaged	bit	Boolean indicating if the user is managed externally.
Firstname	string	User’s first name.
JobTitle	string	Job title of the user.
Lastname	string	User’s last name.
LdapBindingUser	bit	Boolean indicating if this is an LDAP binding user.
Location	string	Physical or organizational location of the user.
ManagedAppleID	string	Managed Apple ID assigned to the user.
Manager	string	User’s manager identifier.
MFAExclusion	bit	Boolean indicating if the user is excluded from MFA.
MFAConfigured	bit	Boolean indicating if MFA is configured for the user.
MFAExclusionUntil	datetime	Expiration date for MFA exclusion.
Middlename	string	User’s middle name.
PasswordNeverExpires	bit	Boolean indicating if the user’s password never expires.
PasswordlessSudo	bit	Boolean indicating if passwordless sudo is enabled.
PublicKey	string	User’s public key for authentication.
RestrictedFieldsJson	string	JSON listing restricted fields for the user.
SambaServiceUser	bit	Boolean indicating if the user is a Samba service account.
State	string	User state (e.g., `active`, `suspended`).
Sudo	bit	Boolean indicating if the user has sudo privileges.
Suspended	bit	Boolean indicating if the user is suspended.
SystemUsername	string	Username on the system.
UnixGUID	integer	GUID for Unix systems.
UnixUID	integer	User ID for Unix systems.
Username	string	Login username.
Created	datetime	Timestamp when the user was created.
Organization	string	Organization the user belongs to.
PasswordDate	datetime	Date when the password was last set.
PasswordExpirationDate	datetime	Date when the password will expire.
Password`expired`	bit	Boolean indicating if the password has expired.
TotpEnabled	bit	Boolean indicating if TOTP MFA is enabled.
MFAEnrollmentTotpStatus	string	Status of TOTP MFA enrollment.
MFAEnrollmentWebAuthnStatus	string	Status of WebAuthn MFA enrollment.
MFAEnrollmentPushStatus	string	Status of Push MFA enrollment.
MFAEnrollmentOverallStatus	string	Overall MFA enrollment status.
AdminID	string	Identifier of the administering user.
AdminRoleName	string	Role name of the administrator.
CreationSource	string	Source from which the user was created (e.g., `portal`, `API`).
RecoveryEmailAddress	string	Recovery email address for the user.
RecoveryEmailVerified	bit	Boolean indicating if recovery email is verified.
RecoveryEmailVerifiedAt	datetime	Timestamp when recovery email was verified.
BatchDate	datetime	Timestamp when the record was collected or batched.

JumpCloudUserSSHKeys

Name	Type	Description
ConfigID	integer	Configuration identifier for the record.
ID	string	Unique identifier of the SSH key record.
JumpCloudUserID	string	Reference to the associated JumpCloud user.
Name	string	Name assigned to the SSH key.
CreateDate	datetime	Timestamp when the SSH key was created.
PublicKey	string	Public key string for SSH authentication.
BatchDate	datetime	Timestamp when the record was collected or batched.

Bridge Tables

JumpCloudRadiusServers_JumpCloudGroups

Name	Type	Description
JumpCloudRadiusServerModelID	string	Unique identifier of the JumpCloud RADIUS server in the bridge table.
JumpCloudRadiusServerModelConfigID	integer	Configuration identifier for the associated RADIUS server.
JumpCloudGroupModelID	string	Unique identifier of the JumpCloud group in the bridge table.
JumpCloudGroupModelConfigID	integer	Configuration identifier for the associated group.

JumpCloudRadiusServers_JumpCloudUsers

Name	Type	Description
JumpCloudRadiusServerModelID	string	Unique identifier of the JumpCloud RADIUS server in the bridge table.
JumpCloudRadiusServerModelConfigID	integer	Configuration identifier for the associated RADIUS server.
JumpCloudUserModelID	string	Unique identifier of the JumpCloud user in the bridge table.
JumpCloudUserModelConfigID	integer	Configuration identifier for the associated user.

JumpCloudSystems_JumpCloudUsers

Name	Type	Description
JumpCloudUserModelID	string	Unique identifier of the JumpCloud user in the bridge table.
JumpCloudUserModelConfigID	integer	Configuration identifier for the associated user.
JumpCloudSystemModelID	string	Unique identifier of the JumpCloud system in the bridge table.
JumpCloudSystemModelConfigID	integer	Configuration identifier for the associated system.

Tables

JumpCloudRadiusServers

JumpCloudSystems

JumpCloudUserAddresses

JumpCloudUserAttributes

JumpCloudUserPhoneNumbers

JumpCloudUsers

JumpCloudUserSSHKeys

Bridge Tables

JumpCloudRadiusServers_JumpCloudGroups

JumpCloudRadiusServers_JumpCloudUsers

JumpCloudSystems_JumpCloudUsers

Learn more...