Change log for the Intune Data Warehouse API
Keep current on updates to the Intune Data Warehouse.
2202
Released February 2022
The applicationInventory
entity has been removed from the Intune Data Warehouse. A new dataset is now available in the UI and via Intune's export API. For related information, see Export Intune reports using Graph APIs.
2105
Released May 2021
The IntuneAosp
property value is now supported in the managementAgentType
enum. The ManagementAgentTypeID
value for this property is 2048
. It represents the device type that is managed by Intune's MDM for AOSP (Android Open Source Project) devices. For related information, see managementAgentType in the beta section of the Intune Data Warehouse API.
2103
Released March 2021
The applicationInventory
entity will be removed from the Intune Data Warehouse with the 2107 update of Intune. We are introducing a more complete and accurate dataset that will be available in the UI and via our export API. For related information, see Export Intune reports using Graph APIs.
2007
Released July 2020
v1.0 changes
The following table lists the added property to the device entity in the Intune Data Warehouse.
Collection | Change | Description information |
---|---|---|
ethernetMacAddress | Added | The unique network identifier of this device. |
office365Version | Added | The version of Microsoft 365 that is installed on the device. |
The following table lists the added property to the devicePropertyHistories entity in the Intune Data Warehouse.
Collection | Change | Description information |
---|---|---|
physicalMemoryInBytes | Added | The physical memory in bytes. |
totalStorageSpaceInBytes | Added | Total storage capacity in bytes. |
2004
Released April 2020
v1.0 changes
The following table lists the added property to the devices entity in the Intune Data Warehouse.
Collection | Change | Description information |
---|---|---|
windowsOsEdition | Added | Windows Operating System edition. |
Beta changes
The following table lists the added property to the device entity in the Intune Data Warehouse.
Collection | Change | Description information |
---|---|---|
windowsOsEdition | Added | Windows Operating System edition. |
2003
Released March 2020
Beta changes
The following table lists the added properties to the device entity in the Intune Data Warehouse.
Collection | Change | Description information |
---|---|---|
ethernetMacAddress | Added | The unique network identifier of this device. |
model | Added | The device model. |
office365Version | Added | The version of Microsoft 365 that is installed on the device. |
The following table lists the added properties to the devicePropertyHistory entity in the Intune Data Warehouse.
Collection | Change | Description information |
---|---|---|
physicalMemoryInBytes | Added | The physical memory in bytes. |
totalStorageSpaceInBytes | Added | Total Storage in bytes. |
1903 (Part 2)
Released April 2019
Beta changes
The following table lists the recent removed collections and the replacements collections in the Intune Data Warehouse.
Collection | Change | Additional information |
---|---|---|
mobileAppDeviceUserInstallStatus | Removed | Use mobileAppInstallStatusCounts instead. |
enrollmentTypes | Removed | Use deviceEnrollmentTypes instead. |
mdmStatuses | Removed | Use complianceStates instead. |
workPlaceJoinStateTypes | Removed | Use the azureAdRegistered property in the devices and devicePropertyHistories collections instead. |
clientRegistrationStateTypes | Removed | Use deviceRegistrationStates instead. |
currentUser | Removed | Use the users collection instead. |
mdmDeviceInventoryHistories | Removed | Many of the properties were redundant or can now be found in the devicePropertyHistories or devices collections. Any mdmDeviceInventoryHistories properties not already listed with these two collections are no longer available. See details below. |
The following table lists the old properties formerly found in the mdmDeviceInventoryHistories collection and the change/replacement. Any properties that were in mdmDeviceInventoryHistories but not listed below have been removed.
Old property | Change/replacement |
---|---|
cellularTechnology | cellularTechnology in devices collection |
deviceClientId | deviceId in devices collection |
deviceManufacturer | manufacturer in devices collection |
deviceModel | model in devices collection |
deviceName | deviceName in devices collection |
deviceOsPlatform | deviceTypeKey in devices collection |
deviceOsVersion | osVersion in devicePropertyHistories collection |
deviceType | deviceTypeKey in devices collection, referencing deviceTypes collection |
encryptionState | encryptionState property in the devices collection |
exchangeActiveSyncId | easDeviceId property in the devices collection |
exchangeDeviceId | easDeviceId in devices collection |
imei | imei in devices collection |
isSupervised | isSupervised property in the devices collection |
jailBroken | jailBroken in devicePropertyHistories collection |
meid | meid property in the devices collection |
oem | manufacturer in devices collection |
osName | deviceTypeKey in devices collection, referencing deviceTypes collection |
phoneNumber | phoneNumber in devices collection |
platformType | model in devices collection |
product | deviceTypeKey in devices collection |
productVersion | osVersion in devicePropertyHistories collection |
serialNumber | serialNumber in devices collection |
storageFree | freeStorageSpaceInBytes property in the devices collection |
storageTotal | totalStorageSpaceInBytes property in the devices collection |
subscriberCarrierNetwork | subscriberCarrier property in the devices collection |
wifimac | wiFiMacAddress in devices collection |
The following table lists changes to properties found in the devicePropertyHistories collection:
Old property | Change/replacement |
---|---|
categoryId | deviceCategoryKey, referencing deviceCategories collection |
certExpirationDate | Removed |
clientRegistrationStateKey | deviceRegistrationStateKey |
createdDate | enrolledDateTime in devices collection |
deviceTypeKey | deviceTypeKey in devices collection |
easID | easDeviceId in devices collection |
enrolledByUser | userId in devices collection |
enrollmentTypeKey | deviceEnrollmentTypeKey in devices collection |
graphDeviceIsCompliant | Removed |
graphDeviceIsManaged | Removed |
lastContact | lastSyncDateTime in devices collection |
lastContactNotification | Removed |
lastContactWorkplaceJoin | Removed |
lastExchangeStatusUtc | Removed |
lastModifiedDateTimeUTC | Removed |
lastPolicyUpdateUtc | Removed |
managementAgentKey | managementStateKey |
manufacturer | manufacturer in devices collection |
mdmStatusKey | complianceStateKey, referencing complianceStates collection |
model | model in devices collection |
osFamily | operatingSystem in devices collection |
osRevisionNumber | osVersion in devices collection |
processorArchitecture | Removed |
referenceId | azureAdDeviceId in devices collection |
serialNumber | serialNumber in devices collection |
workplaceJoinStateKey | azureAdRegistered |
The following table lists changes to properties found in the devices collection:
Old property | Change/replacement |
---|---|
categoryId | deviceCategoryKey, referencing deviceCategories collection |
certExpirationDate | Removed |
clientRegistrationStateKey | deviceRegistrationStateKey |
createdDate | enrolledDateTime |
easId | easDeviceId |
enrolledByUser | userId |
enrollmentTypeKey | deviceEnrollmentTypeKey |
graphDeviceIsCompliant | Removed |
graphDeviceIsManaged | Removed |
lastContact | lastSyncDateTime |
lastContactNotification | Removed |
lastContactWorkplaceJoin | Removed |
lastExchangeStatusUtc | Removed |
lastPolicyUpdateUtc | Removed |
mdmStatusKey | complianceStateKey, referencing complianceStates collection |
osFamily | operatingSystem |
processorArchitecture | Removed |
referenceId | azureAdDeviceId |
workplaceJoinStateKey | azureAdRegistered |
The following table lists changes to properties found in the enrollmentActivities collection:
Old property | Change/replacement |
---|---|
enrollmentTypeKey | deviceEnrollmentTypeKey |
The following table lists changes to properties found in the mamApplications collection:
Old property | Change/replacement |
---|---|
applicationKey | mamApplicationKey |
applicationName | mamApplicationName |
applicationId | mamApplicationId |
The following table lists changes to properties found in the mamApplicationInstances collection:
Old property | Change/replacement |
---|---|
applicationId | mamApplicationId |
deviceId | mamDeviceId |
deviceType | mamDeviceType |
deviceName | mamDeviceName |
The following table lists changes to properties found in the mamCheckins collection:
Old property | Change/replacement |
---|---|
applicationKey | mamApplicationKey |
The following table lists changes to properties found in the users collection:
Old property | Change/replacement |
---|---|
startDateInclusiveUtc | Removed |
endDateInclusiveUtc | Removed |
isCurrent | Removed |
1903
Released March 2019
V1.0 changes reflecting back to beta
When V1.0 was first introduced in 1808, it differed in some significant ways from the beta API. In 1903 those changes will be reflected back into the beta API version. If you have important reports that use the beta API version, we strongly recommend switching those reports to V1.0 to avoid breaking changes. Please refer to API version information for more information on Data Warehouse API versions and backwards compatibility.
1902
Released February 2019
Power BI Compliance app
Access your Intune Data Warehouse in Power BI Online using the Intune Compliance (Data Warehouse) app. With this Power BI app, you can now access and share pre-created reports without any setup and without leaving your web browser.
Note
There are two additional filters you can apply to the Intune Compliance app.
Add additional filters to the Intune Compliance app
- Open the Intune Compliance (Data Warehouse) app in your web browsers.
- Click Non-Compliant Devices and select Non-Compliant in the complianceStatus filter.
- Click on Unknown Devices and select Not Yet Available in the complianceStatus filter.
1812
Released December 2018
Enrollment Activities Collection Released to v1.0
The Enrollment Activities collection is now available in v1.0. You can use this collection to understand enrollment failure volume and trends in your environment. For more information, see enrollmentActivities, enrollmentEventStatuses, enrollmentFailureCategories, and enrollmentFailureReasons.
1808
Released August 2018
v1.0 Collections
You can now use the v1.0 version of the Intune Data Warehouse by setting the query parameter api-version=v1.0
. Updates to collections in the Data Warehouse are additive in nature and do not break existing scenarios.
Enrollment Activities Collection Released to Beta
The new Enrollment Activities
collection is released to beta. You can use this collection to understand how your enrollment is proceeding by viewing the most common failures.
1805
Released May 2018
Correction to device count in Devices collection
A fix has been made to the Devices collection which may lower total device counts that filter by the attribute isDeleted
. This drop is a result of the correction and is not an error. For more information regarding the Devices collection, see Reference for device entities.
1801
Released January 2018
Intune Data Warehouse application-only authentication
You can set up an application using Azure Active Directory (Azure AD) and authenticate to the Intune Data Warehouse. For more information see, Intune Data Warehouse application-only authentication.
Azure AD and Intune credential requirements
An Intune license is no longer required to be assigned to the user when accessing the Intune Data Warehouse (including the API).
The Intune role name has been changed from Reports to Intune data warehouse.
For more information, see Azure AD and Intune credential requirements.
OData query options
You can use $select
as an OData query parameter. The current version supports the following OData query parameters: $filter
, $orderby
, $select
, $skip
, and $top
. For more information, see OData query options.
New entities in the in Data Warehouse data model
- The entity, MobileAppDeviceuserInstallStatus, has been added. The MobileAppDeviceUserInstallStatus represents a mobile app install status for a given device and user.
- The entity, MobileAppInstallStates, has been added. The MobileAppInstallState entity represents the install state for a mobile application after it has been assigned to a group containing devices, users, or both.
1710
Released November 2017
A new entity collection named Current User is limited to currently active user data
The Users entity collection contains all the Azure Active Directory (Azure AD) users with assigned licenses in your enterprise. These records include user states during the data collection period, even if the user has been removed. For example, a user may be added to Intune and then removed during the course of the last month. While this user is not present at the time of the report, the user and state are present in the data. You could create a report that would show the duration of the user's historic presence in your data.
In contrast, the new Current User entity collection only contains users who have not been removed. The Current User entity collection only contains currently active users. For information about the current user entity collection, see Reference for current user entity.
1709
Released October 2017
User device association entity collection added to Intune Data Warehouse data model
You can now build reports and data visualizations using the user device association information that associates user and device entity collections. The data model can be accessed through the Power BI file (PBIX) retrieved from the Data Warehouse Intune page, through the OData endpoint, or by developing a custom client. For more information, see the User Device Association.
New entities in the in Data Warehouse data model
- The entity, UserDeviceAssociation, added. UserDeviceAssociation contains user device associations in your organization. You can now build reports and data visualizations using the user device association information that associates user and device entity collections.
- The entity, IntuneManagementExtension, added. IntuneManagementExtension contains entities for mobile devices that track information such as version and installation status.
Next steps
- Learn what's new each week in Intune. You can also find out about upcoming changes, important notices about the service, and information about past releases.
- Read the Microsoft Intune Blog.
Feedback
Submit and view feedback for