Azure Managed Apps, Managed Devices, Management Groups, and Microsoft Teams Tables

Tables

AzureADManagedApps

Intune-managed mobile application entries, including publisher and publishing state.

Name	Type	Description
ID	integer	A unique identifier for the Managed App record.
ManagedAppId	string	The unique identifier for the managed application.
DisplayName	string	The name displayed for the managed app.
ODataType	string	The OData type for the managed app.
Publisher	string	The publisher or organization responsible for the managed app.
IsFeatured	boolean	Indicates whether the app is featured (`true` or `false`).
PrivacyInformationUrl	string	The URL where privacy information related to the managed app is provided.
InformationUrl	string	The URL providing more detailed information about the managed app.
Owner	string	The owner of the managed app.
Developer	string	The developer responsible for the app.
Notes	string	Additional notes or description about the managed app.
PublishingState	string	The publishing state of the app (e.g., `draft`, `published`, etc.).

AzureADManagedDeviceConfigurations

Intune device configuration profile definitions applied to managed devices.

Name	Type	Description
ID	integer	A unique identifier for the Managed Device Configuration record.
ManagedDeviceConfigurationId	string	The unique identifier for the specific managed device configuration.
ODataType	string	The OData type for the managed device configuration.
Description	string	A description of the managed device configuration.
DisplayName	string	The display name of the managed device configuration.
CreatedDateTime	datetimeoffset	The date and time when the managed device configuration was created.
LastModifiedDateTime	datetimeoffset	The date and time when the managed device configuration was last modified.
Version	integer	The version number of the managed device configuration.
BatchID	integer	The batch ID associated with the operation for this configuration.
BatchDate	datetime	The date and time when the batch operation for this configuration occurred or was last updated.
ConfigID	integer	The configuration ID associated with the managed device configuration.
PeriodEnd	datetime	The end date for the period relevant to this configuration.
PeriodStart	datetime	The start date for the period relevant to this configuration.

AzureADManagedDeviceEnrollmentConfigurations

Intune device enrollment configuration profiles and their assignment priority.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration related to managed device enrollment.
ID	integer	A unique identifier for the specific managed device enrollment configuration.
Priority	integer	The priority level of the managed device enrollment configuration. A higher priority may indicate precedence.
ManagedDeviceEnrollmentConfigurationId	string	The identifier for the specific managed device enrollment configuration.
Version	integer	The version number of the managed device enrollment configuration.
DisplayName	string	The display name of the managed device enrollment configuration.
Description	string	A description of the managed device enrollment configuration.
CreatedDateTime	datetimeoffset	The date and time when the managed device enrollment configuration was created.
LastModifiedDateTime	datetimeoffset	The date and time when the managed device enrollment configuration was last modified.
ODataType	string	The OData type for the managed device enrollment configuration.
BatchDate	datetime	The date and time when the batch operation for this configuration occurred or was last updated.

AzureADManagedDeviceRoleAssignments

Assignments of Intune role definitions to scopes for managed device administration.

Name	Type	Description
ID	integer	A unique identifier for the managed device role assignment.
RoleDefinitionId	integer	The identifier for the role definition that is assigned to the device.
Decription	string	A description of the managed device role assignment.
DisplayName	string	The display name of the managed device role assignment.
ODataType	string	The OData type for the managed device role assignment.
BatchID	integer	A unique identifier for the batch operation related to this role assignment.
BatchDate	datetime	The date and time when the batch operation for this role assignment occurred or was last updated.
ConfigID	integer	A unique identifier for the configuration related to the managed device role assignment.
PeriodEnd	datetime	The end date and time for the period during which the role assignment was valid.
PeriodStart	datetime	The start date and time for the period during which the role assignment was valid.

AzureADManagedDeviceRoleDefinitions

Intune role definitions available for delegated device management permissions.

Name	Type	Description
ID	integer	A unique identifier for the managed device role definition.
RoleId	string	The unique identifier for the role associated with the device.
DisplayName	string	The display name of the role definition.
Description	string	A description of the role definition.
IsBuiltIn	boolean	A boolean indicating whether the role is built-in or custom.
BatchID	integer	A unique identifier for the batch operation related to this role definition.
BatchDate	datetime	The date and time when the batch operation for this role definition occurred or was last updated.
ConfigID	integer	A unique identifier for the configuration related to the role definition.
PeriodEnd	datetime	The end date and time for the period during which the role definition is valid.
PeriodStart	datetime	The start date and time for the period during which the role definition is valid.

AzureADManagedDevices

Devices enrolled in Intune management, including compliance, protection, and OS state.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration related to the managed device.
DeviceID	string	The unique identifier for the managed device.
DeviceName	string	The name of the managed device.
EmailAddress	string	The email address associated with the managed device.
CompliantState	string	The compliance state of the managed device.
OperatingSystem	string	The operating system of the managed device.
OSVersion	string	The version of the operating system on the managed device.
IsEncrypted	boolean	A boolean indicating whether the device is encrypted.
IsSupervised	boolean	A boolean indicating whether the device is supervised.
LastSyncDate	datetime	The date and time of the last synchronization of the device.
AntiMalwareVersion	string	The version of the anti-malware software installed on the device.
DetectedMalwareState	string	The current state of malware detection on the device.

AzureADManagedDeviceTermsandConditions

Intune terms and conditions policies presented to users during device enrollment.

Name	Type	Description
ID	integer	A unique identifier for the terms and conditions.
ODataType	string	The OData type for the terms and conditions.
TermsId	string	The unique identifier for the terms document.
Description	string	A description of the terms and conditions.
DisplayName	string	The display name of the terms and conditions.
Title	string	The title of the terms and conditions.
Version	integer	The version number of the terms and conditions.
CreatedDateTime	datetimeoffset	The date and time when the terms and conditions were created.
LastModifiedDateTime	datetimeoffset	The date and time when the terms and conditions were last modified.
BatchID	integer	The unique identifier for the batch operation related to the terms and conditions.
BatchDate	datetime	The date and time when the batch operation for the terms and conditions occurred or was last updated.
ConfigID	integer	A unique identifier for the configuration related to the terms and conditions.
PeriodEnd	datetime	The end date and time for the period during which the terms and conditions are valid.
PeriodStart	datetime	The start date and time for the period during which the terms and conditions are valid.

AzureADManagedDeviceUsers

Users associated with Intune-managed devices, including their profile attributes.

Name	Type	Description
ID	integer	A unique identifier for the managed device user.
ManagedDeviceId	string	The unique identifier for the managed device associated with the user.
AccountEnabled	boolean	A boolean indicating whether the accountis enabled for the user.
CompanyName	string	The name of the company the user is associated with.
DisplayName	string	The display name of the user.
EmployeeId	string	The employee ID associated with the user.
EmployeeType	string	The type of employee (e.g., `full-time`, `part-time`, `contractor`).
ManagerUserId	string	The unique identifier for the user’s manager.
ManagedDeviceUserId	string	The unique identifier for the managed device user in the system.
JobTitle	string	The job title of the user.
EMail	string	The email address of the user.
ManagerId	string	The unique identifier for the manager of the user.

AzureADManagementGroupAssignments

Azure RBAC role assignments scoped to management groups.

Name	Type	Description
ID	integer	A unique identifier for the management group assignment.
RoleDefinitionId	string	The unique identifier for the role definition assigned to the management group.
PrincipalId	string	The unique identifier of the principal (user, group, or service principal) that the role is assigned to.
Scope	string	The scope to which the role assignment is applied (e.g., `a management group`, `subscription`).
CreatedOn	datetime	The date and time when the assignment was created.
UpdatedOn	datetime	The date and time when the assignment was last updated.
CreatedBy	string	The user or system that created the assignment.
UpdatedBy	string	The user or system that last updated the assignment.
ManagementGroupName	string	The name of the management group the assignment is associated with.
Type	string	The type of the management group assignment (e.g., `user`, `service principal`, etc.).
Name	string	The name associated with the assignment.
ManagementGroupId	string	The unique identifier of the management group the assignment is linked to.
ConfigId	integer	A unique identifier for the configuration related to the management group assignment.
BatchDate	datetime	The date and time when the batch operation for the assignment was created or last updated.

AzureADManagementGroupProperties

Descriptive properties of Azure management groups, including tenant and display name.

Name	Type	Description
ID	integer	A unique identifier for the management group properties.
ManagementGroupId	string	The unique identifier for the management group.
TenantId	string	The unique identifier for the tenant associated with the management group.
DisplayName	string	The display name of the management group.

AzureADManagementGroups

Azure management group hierarchy resources used to organize subscriptions.

Name	Type	Description
ID	integer	A unique identifier for the management group.
GroupId	string	The unique identifier for the group.
Name	string	The name of the management group.
Type	string	The type of the management group (e.g., `root management group`, `custom management group`).
BatchID	integer	The unique identifier for the batch operation related to the management group.
BatchDate	datetime	The date and time when the batch operation for the management group was created or last updated.
ConfigID	integer	A unique identifier for the configuration related to the management group.
TenantId	string	The unique identifier of the tenant associated with the management group.
DisplayName	string	The display name of the management group.

AzureADMicrosoftTeamChannelMembers

Membership records for members of Microsoft Teams channels.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration related to the team channel member.
ID	string	A unique identifier for the channel member.
ChannelId	string	The unique identifier of the Microsoft Teams channel where the member is associated.
OdataType	string	The OData type used for the channel member.
ListRoles	string	The roles assigned to the channel member, such as owner or member.
DisplayName	string	The display name of the channel member.
VisibleHistoryStartDateTime	datetime	The date and time from which the channel's history is visible to the member.
BatchDate	datetime	The date and time when the batch operation for the channel member was created or last updated.

AzureADMicrosoftTeamChannels

Channels defined within Microsoft Teams teams.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration related to the team channel.
ID	string	A unique identifier for the Microsoft Teams channel.
TeamId	string	The unique identifier of the team that owns the channel.
OdataId	string	The OData identifier for the channel.
CreatedDateTime	datetime	The date and time when the channel was created.
DisplayName	string	The display name of the channel.
Description	string	A description of the channel.
TenantId	string	The unique identifier of the tenant associated with the channel.
IsArchived	boolean	A boolean value indicating if the channel is archived.
IsFavoriteByDefault	boolean	A boolean value indicating if the channel is set as favorite by default.
BatchDate	datetime	The date and time when the batch operation for the channel was created or last updated.

AzureADMicrosoftTeams

Microsoft Teams team objects provisioned in the tenant.

Name	Type	Description
ConfigID	integer	A unique identifier for the configuration related to the Microsoft Team.
ID	string	A unique identifier for the Microsoft Team.
DisplayName	string	The display name of the Microsoft Team.
Description	string	A description of the Microsoft Team.
BatchDate	datetime	The date and time when the batch operation for the Microsoft Team was created or last updated.