Reference for mobile app management (MAM) entities

The Mobile App Management category contains entities for mobile apps such as:

  • Apps
  • Instances
  • Check-in status
  • Health status
  • Policy status
  • Enrollment status
  • Platform types

mamApplications

The mamApplication entity lists Line-of-Business (LOB) apps that are managed through Mobile Application Management (MAM) without enrollment in your enterprise.

Property Description Example
mamApplicationKey Unique identifier of the MAM application. 432
mamApplicationName Name of the MAM application. MAM Application Example Name
mamApplicationId Application ID of the MAM application. 123
isDeleted Indicates whether this MAM app record has been updated.
True- MAM app has a new record with updated fields in this table.
False- the latest record for this MAM app.
True/False
startDateInclusiveUTC Date and time in UTC when this MAM app was created in the data warehouse. 11/23/2016 12:00:00 AM
deletedDateUTC Date and time in UTC when IsDeleted changed to True. 11/23/2016 12:00:00 AM
rowLastModifiedDateTimeUTC Date and time in UTC when this MAM app was last modified in the data warehouse. 11/23/2016 12:00:00 AM

mamApplicationInstances

The mamApplicationInstance entity lists managed Mobile Application Management (MAM) apps as singular instances per user per device. All users and devices listed with in the entity are protected, as in, they have at least one MAM Policy assigned to them.

Property Description Example
applicationInstanceKey Unique identifier of the MAM app instance in the data warehouse - surrogate key. 123
userId User ID of the user who has this MAM app installed. b66bc706-ffff-7437-0340-032819502773
applicationInstanceId Unique identifier of the MAM app instance - similar to ApplicationInstanceKey, but the identifier is a natural key. b66bc706-ffff-7437-0340-032819502773
mamApplicationId Application ID of the Mam Application for which this Mam Application Instance was created. 11/23/2016 12:00:00 AM
applicationVersion Application version of this MAM app. 2
createdDate Date when this record of the MAM app instance was created. Value can be null. 11/23/2016 12:00:00 AM
platform Platform of the device on which this MAM app is installed. 2
platformVersion Platform version of the device on which this MAM app is installed. 2.2
sdkVersion The MAM SDK version that this MAM app was wrapped with. 3.2
mamDeviceId Device ID of the device with which MAM Application Instance is associated with. 11/23/2016 12:00:00 AM
mamDeviceType Device type of the device with which MAM Application Instance is associated with. 11/23/2016 12:00:00 AM
mamDeviceName Device name of the device with which MAM Application Instance is associated with. 11/23/2016 12:00:00 AM
isDeleted Indicates whether this MAM app instance record has been updated.
True- this MAM app instance has a new record with updated fields in this table.
False - the latest record for this MAM app instance.
True/False
startDateInclusiveUtc Date and time in UTC when this MAM app instance was created in the data warehouse. 11/23/2016 12:00:00 AM
deletedDateUtc Date and time in UTC when IsDeleted changed to True. 11/23/2016 12:00:00 AM
rowLastModifiedDateTimeUtc Date and time in UTC when this MAM app instance was last modified in the data warehouse. 11/23/2016 12:00:00 AM

mamCheckins

The mamCheckin entity represents data gathered when a Mobile Application Management (MAM) app instance has checked in with the Intune Service.

Note

When an app instance checks in multiple times a day, the data warehouse stores it as single check-in.

Property Description Example
dateKey Date Key when the MAM app check-in was recorded in the data warehouse. 20160703
applicationInstanceKey Key of the app instance associated with this MAM app check-in. 123
userKey Key of the user associated with this MAM app check-in. 4323
mamApplicationKey Application Key of Application associated with MAM Application check in. 432
deviceHealthKey Key of DeviceHealth associated with this MAM app check-in. 321
platformKey Represents the platform of the device associated with this MAM app check-in. 123
effectiveAppliedPolicyKey Represents the effective applied policy associated with the MAM app that has checked in. An effective applied policy results from merging all policies relevant to a particular app and user. 322
pastCheckInDate Date and time when this MAM app last checked in. Value can be null. 11/23/2016 12:00:00 AM

mamDeviceHealth

The mamDeviceHealth entity represents devices that have Mobile Application Management (MAM) policies deployed to them even if they are jailbroken.

Property Description Example
deviceHealthKey Unique identifier of the device and its associated health in the data warehouse - surrogate key. 123
deviceHealth Unique identifier of the device and its associated health - similar to DeviceHealthKey, but the identifier is a natural key. b66bc706-ffff-7777-0340-032819502773
deviceHealthName Represents the status of the device.
Not available - no information on this device.
Healthy - device is not jailbroken.
Unhealthy - device is jailbroken.
Not Available Healthy Unhealthy
rowLastModifiedDateTimeUtc Date and time in UTC when this specific MAM Device Health was last modified in the data warehouse. 11/23/2016 12:00:00 AM

mamEffectivePolicies

The mamEffectivePolicy entity lists all Mobile Application Management (MAM) effective policies applied in your organization. An effective applied policy results from merging all policies relevant to a particular app and user.

Property Description Example
effectivePolicyKey Unique identifier of the MAM effective policy in the data warehouse. 2
realPolicyKey Unique identifier of the MAM policy authored by the IT Pro. 1
rowCreatedDateTimeUtc Date and time in UTC when this MAM effective policy was created in the data warehouse. 11/23/2016 12:00:00 AM

mamPlatforms

The mamPlatform entity lists platform names and types on which a Mobile Application Management (MAM) app was installed.

Property Description Example
platformKey Unique identifier of the platform in the data warehouse - surrogate key. 123
platform Unique identifier of the platform - similar to PlatformKey, but is a natural key. 123
platformName Platform name Not Available
None
Windows
IOS
Android.
rowLastModifiedDateTimeUtc Date and time in UTC when this platform was last modified in the data warehouse. 11/23/2016 12:00:00 AM