JamF Tables
The JamF integration uses the following tables
Tables
JamFAccounts
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier for the configuration record |
| Id | integer | Unique identifier for each account within the system |
| Name | string | Name associated with the account, usually representing the user's name or the account's display name |
| AccessLevel | string | Defines the level of access or permissions granted to the account, such as Admin, User, or Guest |
| PrivilegeSet | string | Set of specific privileges or permissions assigned to the account, indicating what actions the account can perform |
| BatchDate | datetime | The timestamp indicating when the account or data was processed or updated, typically in batch operations |
JamFComputerDetails
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the computer record |
| UserName | string | Username associated with the computer |
| LastIpAddress | string | IP address of the computer when it was last connected to the network |
| LastReportedIp | string | Last known IP address that the computer reported |
| Platform | string | Operating system platform of the computer (e.g., Windows, macOS, etc.) |
| Managed | string | Indicates whether the computer is managed by an IT management system |
| Supervised | string | Indicates whether the computer is supervised or controlled by a management system |
| ReportDate | string | The date when the computer report was generated |
| LastContactTime | string | The last time the computer contacted the server or management system |
| LastCloudBackupDate | string | The date of the last cloud backup for the computer |
| InitialEntryDate | string | The initial entry date when the computer was added to the management system |
| ItunesStoreAccountActive | string | Indicates whether the iTunes Store account on the computer is active |
| UserApprovedMdm | string | Indicates whether the device was approved for Mobile Device Management (MDM) |
| Encrypted | string | Indicates whether the computer's data is encrypted |
| EndPointName | string | The name of the computer or endpoint |
| EnrolmentUser | string | The user associated with enrolling the computer in the management system |
| EnrolementType | string | The type of enrollment used for the computer (e.g., user-initiated, admin-initiated, etc.) |
| Make | string | The manufacturer or brand of the computer |
| Model | string | The model of the computer |
| ModelIdentifier | string | The unique identifier for the computer model |
| MacAddress | string | The MAC address of the computer's primary network interface |
| AltMacAddress | string | The MAC address of an alternate network interface |
| SipStatus | string | The status of the Session Initiation Protocol (SIP) for the computer |
| AutoLoginDisabled | string | Indicates whether auto-login is disabled on the computer |
| Position | string | The physical or virtual position of the computer in the organization or network setup |
| Phone | string | The phone number associated with the user or computer |
| DepartmentId | string | The ID of the department that the computer is assigned to |
| BuildingId | string | The ID of the building where the computer is located |
| Room | string | The room or location within the building where the computer is located |
| BatchID | integer | Unique identifier for the batch in which the computer was processed |
| BatchDate | datetime | The timestamp when the computer record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the computer |
JamFComputerDetailsApp
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the application record |
| Name | string | The name of the application installed on the computer |
| Version | string | The version of the application installed on the computer |
| UpdateAvailable | string | Indicates whether an update is available for the application |
| EndPoint | string | The endpoint (computer or device) where the application is installed |
| MacAddress | string | The MAC address associated with the computer or device where the application is installed |
| BatchID | integer | Unique identifier for the batch in which the application details were processed |
| BatchDate | datetime | The timestamp when the application record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the application details |
JamFComputerDetailsConfProfile
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the configuration profile record |
| LastInstalled | string | The date when the configuration profile was last installed |
| User | string | The user associated with the configuration profile |
| EndPoint | string | The endpoint (computer or device) where the configuration profile is applied |
| ConfProfile | string | The name or identifier of the configuration profile applied to the computer or device |
| MacAddress | string | The MAC address associated with the computer or device where the configuration profile is applied |
| BatchID | integer | Unique identifier for the batch in which the configuration profile details were processed |
| BatchDate | datetime | The timestamp when the configuration profile record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the configuration profile |
JamFComputerDetailsExtensionAttributes
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the extension attribute record |
| MacAddress | string | The MAC address associated with the computer or device where the extension attributes are applied |
| Name | string | The name of the extension attribute |
| Description | string | A description of the extension attribute, providing additional context or details about its purpose |
| Values | string | The value or data associated with the extension attribute |
| InputType | string | The type of input expected for the extension attribute (e.g., text, number, date) |
| Enabled | string | Indicates whether the extension attribute is enabled or active |
| EndPoint | string | The endpoint (computer or device) where the extension attribute is applied |
| BatchID | integer | Unique identifier for the batch in which the extension attribute details were processed |
| BatchDate | datetime | The timestamp when the extension attribute record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the extension attribute |
JamFComputerDetailsGroup
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the group record |
| GroupId | string | The identifier for the group to which the computer or device belongs |
| GroupName | string | The name of the group to which the computer or device belongs |
| SmartGroup | string | Indicates whether the group is a smart group, which may have dynamic membership based on defined criteria |
| EndPoint | string | The endpoint (computer or device) associated with the group |
| MacAddress | string | The MAC address associated with the computer or device in the group |
| BatchID | integer | Unique identifier for the batch in which the group details were processed |
| BatchDate | datetime | The timestamp when the group record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the group |
JamFComputerDetailsPasswordSettings
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the password settings record |
| MacAddress | string | The MAC address associated with the computer or device for which the password settings are applied |
| Admin | string | Indicates whether the computer has administrative password settings |
| PasswordMinLength | string | The minimum length required for passwords on the computer or device |
| PasswordMaxAge | string | The maximum age (in days) of passwords before they must be changed |
| PasswordMinComplexCharacters | string | The minimum number of complex characters required in passwords (e.g., special characters, numbers) |
| PasswordRequiredAlphanumeric | string | Indicates whether alphanumeric characters are required in the password |
| PasswordHistoryDepth | string | The depth of password history maintained, specifying how many previous passwords cannot be reused |
| ComputerAzureActiveDirectoryId | string | The Azure Active Directory ID of the computer or device for integration with Microsoft Azure AD |
| BatchID | integer | Unique identifier for the batch in which the password settings details were processed |
| BatchDate | datetime | The timestamp when the password settings record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the password settings |
JamFMobileDeviceApplications
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier for the configuration record related to the mobile device application |
| MobileDeviceApplicationID | integer | Unique identifier for the mobile device application |
| Name | string | The name of the mobile device application |
| DisplayName | string | The display name of the mobile device application, which may be different from the internal name |
| BundleId | string | The unique bundle identifier (BundleId) for the mobile device application |
| Version | string | The version of the mobile device application |
| InternalApp | bit | Indicates whether the application is an internal (private) application or not (e.g., used in enterprise environments) |
| BatchDate | datetime | The timestamp when the mobile device application details were processed or updated |
JamFMobileDeviceDetails
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier for the configuration record related to the mobile device |
| MobileDeviceID | integer | Unique identifier for the mobile device |
| DisplayName | string | The display name associated with the mobile device |
| DeviceName | string | The name of the mobile device |
| Name | string | The internal name associated with the mobile device |
| AssetTag | string | The asset tag assigned to the mobile device, often used for inventory purposes |
| LastInventoryUpdate | datetime | The timestamp when the mobile device inventory was last updated |
| LastInventoryUpdateEpoch | bigint | The last inventory update timestamp in Unix epoch format |
| LastInventoryUpdateUtc | datetime | The last inventory update timestamp in UTC |
| Capacity | integer | The total storage capacity of the mobile device (in bytes) |
| CapacityMb | integer | The total storage capacity of the mobile device in megabytes (MB) |
| Available | integer | The amount of storage space currently available on the mobile device (in bytes) |
| AvailableMb | integer | The amount of available storage space on the mobile device in megabytes (MB) |
| PercentageUsed | integer | The percentage of storage that has been used on the mobile device |
| OsType | string | The operating system type of the mobile device (e.g., iOS, Android) |
| OsVersion | string | The version of the operating system running on the mobile device |
| OsBuild | string | The build version of the mobile device's operating system |
| SerialNumber | string | The serial number assigned to the mobile device |
| UDID | string | The unique device identifier (UDID) of the mobile device |
| InitialEntryDateEpoch | bigint | The initial entry date of the mobile device in Unix epoch format |
| InitialEntryDateUtc | datetime | The initial entry date of the mobile device in UTC |
| PhoneNumber | string | The phone number associated with the mobile device |
| IpAddress | string | The IP address assigned to the mobile device |
| WifiMacAddress | string | The MAC address of the mobile device's Wi-Fi interface |
| BluetoothMacAddress | string | The MAC address of the mobile device's Bluetooth interface |
| ModemFirmware | string | The firmware version of the mobile device's modem |
| Model | string | The model of the mobile device |
| ModelIdentifier | string | The model identifier of the mobile device |
| ModelNumber | string | The model number of the mobile device |
| ModelDisplay | string | The display name or description of the mobile device's model |
| DeviceOwnershipLevel | string | The ownership level of the mobile device (e.g., corporate, personal) |
| LastEnrollmentEpoch | bigint | The last enrollment date of the mobile device in Unix epoch format |
| LastEnrollmentUtc | datetime | The last enrollment date of the mobile device in UTC |
| Managed | bit | Indicates whether the mobile device is managed (e.g., through a mobile device management system) |
| Supervised | bit | Indicates whether the mobile device is supervised (e.g., remotely controlled by an organization) |
| ExchangeActivesyncDeviceIdentifier | string | The ActiveSync device identifier for Exchange management |
| Shared | string | Indicates whether the mobile device is shared among users |
| Tethered | string | Indicates whether the mobile device is tethered to another device |
| BatteryLevel | integer | The current battery level of the mobile device (in percentage) |
| BleCapable | bit | Indicates whether the mobile device supports Bluetooth Low Energy (BLE) |
| DeviceLocatorServiceEnabled | bit | Indicates whether the device locator service is enabled on the mobile device |
| DoNotDisturbEnabled | bit | Indicates whether "Do Not Disturb" mode is enabled on the mobile device |
| CloudBackupEnabled | bit | Indicates whether cloud backup is enabled on the mobile device |
| LastCloudBackupDateEpoch | bigint | The timestamp of the last cloud backup in Unix epoch format |
| LastCloudBackupDateUtc | datetime | The timestamp of the last cloud backup in UTC |
| LocationServicesEnabled | bit | Indicates whether location services are enabled on the mobile device |
| ItunesStoreAccountIsActive | bit | Indicates whether the iTunes Store account is active on the mobile device |
| LastBackupTimeEpoch | bigint | The timestamp of the last backup in Unix epoch format |
| LastBackupTimeUtc | datetime | The timestamp of the last backup in UTC |
| BatchDate | datetime | The timestamp when the mobile device record was processed or updated in the batch process |
JamFOsXConfigurationProfile
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the configuration profile record |
| PolicyId | integer | Unique identifier for the policy associated with the configuration profile |
| Name | string | The name of the configuration profile |
| BatchID | integer | Unique identifier for the batch in which the configuration profile was processed |
| BatchDate | datetime | The timestamp when the configuration profile record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the configuration profile |
JamFOsXConfigurationProfileDetails
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the configuration profile details record |
| PolicyId | integer | Unique identifier for the policy associated with the configuration profile details |
| Name | string | The name of the configuration profile details |
| Description | string | A description of the configuration profile details |
| DistributionMethod | string | The method used to distribute the configuration profile (e.g., push, download, etc.) |
| UserRemovable | string | Indicates whether the configuration profile can be removed by the user |
| Level | string | The level of the configuration profile (e.g., system, user, etc.) |
| RedeployOnUpdate | string | Indicates whether the configuration profile should be redeployed when updated |
| AllComputers | string | Indicates whether the configuration profile applies to all computers |
| Computers | string | A list of specific computers to which the configuration profile applies |
| BatchID | integer | Unique identifier for the batch in which the configuration profile details were processed |
| BatchDate | datetime | The timestamp when the configuration profile details record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the configuration profile details |
JamFPolicies
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the policy record |
| PolicyId | integer | Unique identifier for the policy |
| Name | string | The name of the policy |
| BatchDate | datetime | The timestamp when the policy record was added or updated |
| ConfigID | integer | Unique identifier for the configuration record related to the policy |
JamFPolicyDetails
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the policy detail record |
| PolicyId | integer | Unique identifier for the policy |
| Name | string | The name of the policy |
| Enabled | string | Indicates whether the policy is enabled (active) |
| Trigger | string | The trigger event or condition for the policy to execute (e.g., schedule, manual trigger) |
| Frequency | string | The frequency at which the policy is applied or checked (e.g., daily, weekly, etc.) |
| RetryEvent | string | The retry event condition for the policy in case of failure |
| Category | string | The category under which the policy falls (e.g., security, system configuration) |
| DateTimeLimitations | string | Any limitations or restrictions on the execution of the policy based on specific date/time conditions |
| AllComputers | string | Indicates whether the policy applies to all computers |
| Action | string | The action that the policy will perform when triggered |
| BatchDate | datetime | The timestamp when the policy details record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the policy |
| BatchId | integer | Unique identifier for the batch in which the policy details were processed |
JamFPolicyLimitations
| Name | Type | Description |
|---|---|---|
| ID | integer | Unique identifier for the policy limitation record |
| PolicyId | integer | Unique identifier for the policy |
| Ibeacons | string | The iBeacons associated with the policy limitations |
| NetworkSegments | string | The network segments associated with the policy limitations |
| UserGroups | string | The user groups associated with the policy limitations |
| Users | string | The users associated with the policy limitations |
| BatchDate | datetime | The timestamp when the policy limitations record was added or updated in the batch process |
| ConfigID | integer | Unique identifier for the configuration record related to the policy limitations |
| BatchId | integer | Unique identifier for the batch in which the policy limitations details were processed |
JamFUserDetails
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier for the user configuration record |
| ID | integer | Unique identifier for the user |
| Name | string | The name of the user |
| FullName | string | The full name of the user |
| string | The email address associated with the user | |
| Position | string | The job position or title of the user |
| EmailAddress | string | The email address of the user (if different from the primary email) |
| PhoneNumber | string | The phone number of the user |
| ManagedAppleId | string | The Managed Apple ID associated with the user |
| BatchDate | datetime | The timestamp when the user details were added or updated in the batch process |
JamFUserGroups
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Unique identifier for the configuration record related to the user group |
| ID | integer | Unique identifier for the user group |
| Name | string | The name of the user group |
| IsSmart | bit | Indicates whether the user group is a smart group (dynamically updated based on conditions) |
| IsNotifyOnChange | bit | Indicates whether notifications should be sent when the user group changes |
| BatchDate | datetime | The timestamp when the user group record was added or updated in the batch process |
Bridge Tables
JamFMobileDevices_JamFMobileDeviceApplications
| Name | Type | Description |
|---|---|---|
| MobileDeviceID | integer | Unique identifier for the mobile device associated with the application |
| MobileDeviceApplicationID | integer | Unique identifier for the mobile device application |
| ConfigID | integer | Unique identifier for the configuration record related to the mobile device and application relationship |
JamFUserDetails_JamFUserGroups
| Name | Type | Description |
|---|---|---|
| JamFUserGroupsID | integer | Unique identifier for the user group association record |
| JamFUserGroupsConfigID | integer | Unique identifier for the configuration record related to the user group |
| JamFUsersID | integer | Unique identifier for the user associated with the user group |
| JamFUsersConfigID | integer | Unique identifier for the configuration record related to the user |
Updated over 1 year ago
Learn more...
Did this page help you?