Custom Reports: Entity References

Creating custom reports in JumpCloud requires a clear understanding of the available data structures. This reference table serves as a comprehensive guide to navigating the platform's primary entities, identifying the columns available for your queries, and discovering the secondary entities that can be joined to them. By mapping out these relationships, you can efficiently construct reports and refine your data insights.

Entities and Columns in Custom Reports

Primary Entity	Available Columns	Secondary Entities Available
Accessory Assets	Created At, Currency Code, Deployed Date, Accessory Asset ID, Location ID, Accessory Model, Accessory Name, Owner User ID, PO Number, Purchase Cost, Purchase ID, Status Option ID, Supplier, Asset Tag, Asset Type, Accessory Type Option ID, Updated At, Warranty Expiration Date, Warranty Period Months	Assets, Assets Custom Field Values, Assets Custom Field, Asset Fields JSON, Asset History Events, Asset Status Select Options, Asset Type Select Options, Location Assets, Users
Administrators	Created Date, Account Disabled, Admin Email, First Name, Administrator ID, Last Access, Last Name, Created At, Asset ID, Asset Type, Uploaded At, Administrator Role Name, Account Suspended.	Asset History Events, Admin Login Attempt Events, Admin Password Change Events, Admin Password Reset Request Event, Organizations, Roles, Users
Assets	No Available Options	Accessory Assets, Assets Custom Field Values, Asset Fields JSON, Asset History Events, Device Assets, Location Assets
Assets Custom Field Values	Asset ID, Asset Type, Boolean Value, Created At, Date Value, DateTime Value, Field Config ID, Field Type, File Value ID, Float Value, Custom Field Value ID, Integer Value, Location Value ID, Is Multiple Value, Select Value ID, Text Area Value, Text Value, Unique Test Value, Updated At, User Group Value ID, User Value ID	Accessory Assets, Assets, Asset Custom Select Option, Asset Field Configuration, Asset Field JSON, Device Assets, Location Assets, Users, User Groups
Assets Custom Field	Asset ID, Asset Type, Boolean Value, Date Value, DateTime Value, Field Config ID, Field Label, Field Label (Uppercase), Field Order, Field Section, Field Type, Field Value, Field Value (Lowercase), Float Value, Integer Value,Is Mandatory, Is Multiple, Location ID, Select Option ID, Select Option Value, Text Area Value, Text Value, User Group ID, User ID, Value Created At, Value Updated At	Accessory Assets, Asset Custom Select Option, Asset Field Configuration, Asset Field JSON, Device Assets, Location Assets, Users, User Groups
Assets Custom Select Options	Created At, Field Config ID, Field Type, Option ID, Display Order, Updated At, Option Value	Asset Custom Field Values, Asset Custom Fields, Asset Field Configuration
Asset Default Select Options	Display Color, Created At, Device Status Mapping, Editable, Field Type, Option ID, Display Order, Updated At, Option Value	No Available Options
Asset Field Configuration	Auto Populate, Created at, Is Default Field, Field Config ID, Field Label, Mandatory, Allow Multiple Values, Display Order, Scope, Section, Tooltip, Field Type, Unique Value Required, Updated At	Asset Custom Field Values, Asset Custom Fields, Asset Custom Select Options
Asset Fields JSON	Asset ID, Asset Type, Custom Fields, Field Names, Field Types, First Created At, Last Updated At, Total Fields	Accessory Assets, Assets, Asset Custom Field Values, Asset Custom Fields, Device Assets, Location Assets
Asset History Events	Actor Info, Actor Type, Asset ID, Asset Type, Created At, Event ID, Note, Occurred At, Event Type, Updated At	Accessory Assets, Administrators, Assets, Device Assets, Location Assets, Users
Asset OS Family Select Options	Display Color, Created At, Editable, Field Type, OS, Family Option ID, Display, Order, Updated At, OS Family Value	Device Assets
Asset Ownership Select Options	Display Color, Created At, Editable, Field Type, Ownership Option ID, Display, Order, Updated At, Ownership Value	Device Assets
Asset Settings	Created At,Currency Format,Default Currency Code,Settings ID, State, Updated At	No Available Options
Asset Status Select Options	Display Color,Created At,Device Status Mapping, Editable,Field Type, Status Option ID, Display Order, Updated At, Status Value	Accessory Assets, Device Assets
Asset Type Select Options	Display Color, Created At,Editable, Field Type, Type Option ID, Display Order, Updated At, Type Value	Accessory Assets, Device Assets
Authentication	Login success, Last login timestamp, MFA Type	Organizations, Users
Browsers	Browser Name, Browser Version	Devices, Organizations
Certificates	Certificate Name, Certificate Type, Expiry Date, ID	No Available Options
Commands	Command Exit Code, Command Name, Command, Run Timestamp, Command Status	Devices, Organizations
Devices	Activation Lock Enabled, Agent Install Date, Agent Reporting Status, Agent Version, Architecture, Architecture Family, Build (Win only), Device Description, Device Creation Date, Disk Encrypted, Device Display Name, Operating System Edition, Hardware Model, Hardware Vendor, Hostname, JumpCloud Device ID, Device Last Contact, MDM Enrolled, MDM Enrollment Type, MDM Enrollment Date,MDM Provider ID, Device MFA Enabled, Device OS, Operating System Family, OS Release Name, OS Version, Primary User ID, Public IP Address, Hardware Serial Number, OS Version Name	Browsers, Commands, Device Assets, Devices Disk Details, Device Disk Summary, Device Groups, Devices Network Details, Devices OS Details, Device Policies, Devices System Details, Login Attempt Events, Software Add Events, System User Lockout Events, System User Password, Change Events, Organizations, Software, System Attributes, Systems (Raw), System Users (Raw), Users
Device Assets	Agent StatusAgent VersionBattery Current CapacityBattery Max CapacityCPU, Created At, Currency Code, Data Source, Deployed Date, Disk Encrypted, Disk Size (MB), Device Asset ID, IMEI, Last Contact, Location ID, MDM Provider, MDM Status, MDM Status Enum, MFA Status, Device Model, Device Name, Old System ID, Operating System, OS Family Option ID, OS Version, Owner User ID, Ownership Type Option ID, PO Number, Primary User ID, Purchase Cost, Purchase Date, RAM (MB), Serial Number, Status Option ID, Supplier, System ID, System Insights Enabled, Asset Tag, Asset Type, Device Type Option ID, Unique Serial, Updated At, Vendor, Warranty Expiration Date, Warranty Period (Months)	Assets, Asset Custom Field Values, Asset Custom Fields, Asset Fields JSON, Asset History Events, Asset OS Family Select Options, Asset Ownership Select Options, Asset Status Select Options, Asset Type Select Options, Devices, Location Assets, Users
Devices Disk Details	Disk size, Storage Available	Devices, Organizations
Device Disk Summary	Primary Drive Name, Primary Disk Free Space, Primary, Drive Free Space Percentage, Primary Disk, Used Space, Total Free Disk Space, Total Free Disk Space, Percentage, Total Used Disk Space	Devices, Organizations
Device Groups	Membership Method, Device Group Name	Devices, Organizations, System Group Details, User Groups
Device Group Rules	Attribute, Created At, Device, Group ID, Device Group, Name, Rule Operator, Top, Level Operator, Updated At, Value	System Group Details
Devices Network Details	Firewall Enabled, MAC Address, Private IP Address	Devices, Organizations
Devices OS Details	Version Install Date, Latest Version, On Latest OS, Version, Version Release Date	Devices, Organizations
Device Policies	Exit Code, Exit Message, Exit Message (stderr), Exit, Message (stdout), Device, Policy ID, Policy Name, Policy Template Name, Policy Status	Devices, Organizations
Devices System Details	CPU Model, CPU Brand, Memory, Device Uptime	Devices, Organizations
Directories	Directory Name, Directory ID	Organizations, Users
Admin Login Attempt Details	Authentication Method, Login Attempt Time, MFA Used Status, Source IPSuccess	Administrators
Admin Password Change Events	Admin ID, Timestamp, Source IP	Administrators, Users
Admin Password Reset Request Event	Browser Name, Browser Version, Client IP, Country Code, Device Type, Request Time, Operating System, OS Version, Provider, Region Name, Service, User Agent, User Email	Administrators
Login Attempt Events	Authentication Method, Login Attempt Time, Initiated By Username, Source IP, Success	Devices, Users
Software Add Events	Timestamp, Software Name, Software Version, Source IP	Devices
SSO Authentication Events	Application display label, Application name, Authentication method, Authentication Time, MFA Used, MFA Type, Source IP, SSO Success, Success	SSO Apps Users
System User Lockout Events	Timestamp, Reason, Source IP	Devices, Users
System User Password Change Events	Timestamp, Source IP	Devices, Users
User Lockout Events	Authentication Method, Timestamp, Reason, Source IP	Users
User Login Attempt Events	Authentication Method, Login Attempt Time, MFA Used, Status, Source IP, Success	Users
User Password Change Events	Change Type, Change Time, Source IP, User ID	Users
LDAP	LDAP ID, LDAP Display Name	Organizations, Users
Location Assets	Street Address, City, Country, Created At, Location ID, Manager User ID, Location Name, Parent Location ID, Phone Number, State/Province, Location Tag, Asset Type, Updated At, ZIP/Postal Code	Accessory Assets, Assets, Asset Custom Field Values, Asset Custom Fields, Asset Fields JSON, Asset History Events, Device Assets, Users
Organizations	Organization Name	Administrators, Authentication, Browsers, Commands, Devices, Devices Disk Details, Device Disk Summary, Device Groups, Devices Network Details, Devices OS Details, Device Policies, Devices System Details, Directories, LDAP, Radius, Software, SSO Apps, System Attributes, Users, User Groups
Radius	Radius ID, Radius Display Name	Organizations, Users
Roles	Role Description, Role ID, Custom Role, Role Name	Administrators
SaaS Applications	Access Restriction, Alternative Button Label, Alternative Button URL, Catalog Application ID, Application Created At, Custom Restriction Message, Discovered At, Manually Added, Owner User ID, Restriction Excluded Group IDs, Application Status	SaaS Application Catalog
SaaS Applications Catalog	Catalog Category ID, Catalog Created At, Application Description, Catalog Homepage, Catalog Multi-Tenancy Support, Application Name, Parent Catalog Application ID, Catalog SSO Support, Catalog Updated At	SaaS Application Catalog
Softwares	Application Platform, Software Install/Update (date), Software Last Opened, Software Name, Software Vendor, Software Version	Devices, Organizations
SSO Apps	Application Name, Application Display Name, Application ID, Idp URL, SCIM Enabled, SSO Enabled	SSO Authentication Events, Organizations, User Groups
System Attributes	Attribute ID, Attribute Name, Attribute Value	Devices, Organizations, Systems (Raw)
System Group Details	Created At, Description, Group Email, Member Suggestions Notify, Membership Method, Group Name, Group Object ID, Updated At	Device Groups, Device Group Rules
System Primary User Member Of	Hardware Vendor, ID, Member Of, Primary System User Member Of	No Available Options
Systems (Raw)	System ID, Raw JSON	Devices System Attributes
System Users (Raw)	System User ID, Raw JSON	Devices System User AttributesUsers
System User with User Aggregates	Email, First Name, User ID, Job Title, Member Of Groups	System User Attributes
Users	Account Lockout, Activation Date, Administrator Role Name, Alternate Email, Delegated Authority, Email, Employee ID, First Name, Global Admin/Sudo User, User ID, JC Go Enrolled, Last Name, LDAP Binding User, Linked Administrator ID, Managed Apple ID, Manager ID, MFA Required, Middle Name, Organization ID, Password Activated, Password Authority, Password Expiration Date, Password Expired, Passwordless Sudo, Protect Enrolled, Recovery E-mail, Samba Service User, Suspended Date, TOTP Enrolled, User Company, User Cost Center, User Creation Date, User Department, User Description, User Display Name, User Employee Type, User Job Title, User Location, User State, Username, WebAuthN Enrolled, Work Country	Accessory Assets, Administrators, Asset Custom Field Values, Asset Custom Fields, Asset History Events, Authentication, Devices, Device Assets, Directories, Admin Password Change Events, Login Attempt Events, SSO Authentication Events, System User Lockout Events, System User Password Change Events, User Lockout Events, User Login Attempt Events, User Password Change Events, LDAP, Location Assets, Organizations, Radius, System User Attributes, System Users (Raw), User Groups
User Groups	Custom Group Attributes (Group Inherited Attributes),User Group Description,User Group Email,User Group ID,Membership Method,User Group Name,Sudo	Asset Custom Field Values, Asset Custom Fields, Device Groups, Organizations, SSO Apps, Users, User Group Details
User Groups Details	Created At, Description, Group Email, Member Suggestions Notify, Membership Method, Group Name, Group Object ID, Updated At	User Groups, User Group Rules
User Group Rules	Attribute, Created At, Rule Operator, Top Level Operator, Updated At, User Group ID, User Group Name, Value	User Group Details