| AccountEnabled |
boolean |
True if the account is enabled |
| ApproximateLastSignInDateTime |
datetime |
Approximate date/time this device last signed in to Entra ID |
| Checked |
datetime |
Date/Time this information was last checked against Entra ID |
| CloudProviderAccountID |
numeric |
Internal ID that references the CloudProviderAccount entity (Foreign Key) |
| ComplianceExpirationDateTime |
datetime |
The timestamp when the device is no longer deemed compliant |
| Created |
datetime |
Date/Time this device entity was created in OctoSAM |
| CustomField1 |
string |
Site specific custom data, not used by OctoSAM |
| CustomField2 |
string |
Site specific custom data, not used by OctoSAM |
| CustomField3 |
string |
Site specific custom data, not used by OctoSAM |
| CustomField4 |
string |
Site specific custom data, not used by OctoSAM |
| DeviceCategory |
string |
User-defined property set by Intune to automatically add devices to groups and simplify managing devices |
| DeviceId |
string |
Unique identifier set by Entra ID device registration service at the time of registration |
| DeviceMetadata |
string |
Device metadata from Entra ID |
| DeviceOwnership |
string |
Ownership of the device. Set by Intune. |
| DeviceVersion |
numeric |
Device version from Entra ID |
| DisplayName |
string |
The display name for the device |
| EnrollmentProfileName |
string |
Enrollment profile applied to the device |
| EnrollmentType |
string |
|
| EntraIdId |
string |
The unique Entra ID identifier of the device object |
| Ext1 |
string |
Reserved for future use |
| Ext2 |
string |
Reserved for future use |
| Ext3 |
string |
Reserved for future use |
| Ext4 |
string |
Reserved for future use |
| ExtensionAttribute1 |
string |
Extension Attribute 1 from Entra ID |
| ExtensionAttribute10 |
string |
Extension Attribute 10 from Entra ID |
| ExtensionAttribute11 |
string |
Extension Attribute 11 from Entra ID |
| ExtensionAttribute12 |
string |
Extension Attribute 12 from Entra ID |
| ExtensionAttribute13 |
string |
Extension Attribute 13 from Entra ID |
| ExtensionAttribute14 |
string |
Extension Attribute 14 from Entra ID |
| ExtensionAttribute15 |
string |
Extension Attribute 15 from Entra ID |
| ExtensionAttribute2 |
string |
Extension Attribute 2 from Entra ID |
| ExtensionAttribute3 |
string |
Extension Attribute 3 from Entra ID |
| ExtensionAttribute4 |
string |
Extension Attribute 4 from Entra ID |
| ExtensionAttribute5 |
string |
Extension Attribute 5 from Entra ID |
| ExtensionAttribute6 |
string |
Extension Attribute 6 from Entra ID |
| ExtensionAttribute7 |
string |
Extension Attribute 7 from Entra ID |
| ExtensionAttribute8 |
string |
Extension Attribute 8 from Entra ID |
| ExtensionAttribute9 |
string |
Extension Attribute 9 from Entra ID |
| ExtraData |
string |
Reserved for future use |
| FirstScan |
datetime |
Date/Time this device was first imported from Entra ID |
| ID |
numeric |
Internal ID for the EntraIdMissingDevice entity (Primary Key) |
| IsCompliant |
boolean |
True if the device complies with Mobile Device Management (MDM) policies |
| IsManaged |
boolean |
True if the device is managed by Mobile Device Management (MDM) policies |
| IsManagementRestricted |
boolean |
Indicates whether a device belongs to a restricted management administrative unit (RMAU). When this property is true, high-privilege tenant-level administrators are blocked from modifying the device; only administrators explicitly scoped to that specific administrative unit can manage it. |
| IsRooted |
boolean |
Microsoft Entra ID and Microsoft Authenticator enforce automated security checks that block work or school credentials on rooted Android or jailbroken iOS devices. |
| LastScan |
datetime |
Date/Time this device was last scanned from Entra ID |
| ManagementType |
string |
Defines the channel or authority managing the device. It indicates how the device communicates with management and security tooling. |
| MappingTag |
string |
Reserved for future use |
| MdmAppID |
string |
MDM Appl ID from Entra ID |
| Model |
string |
Model of the device |
| NoScan |
boolean |
This flag can be set for devices where we know that they should not be scanned by OctoSAM |
| OnPremisesLastSyncDateTime |
datetime |
The last time at which the object was synced with the on-premises directory |
| OnPremisesSecurityIdentifier |
string |
The on-premises security identifier (SID) for the device, used to identify the device in on-premises Active Directory environments. It is populated only for Hybrid Azure AD joined devices and remains empty for cloud-only Entra ID joined devices. |
| OnPremisesSyncEnabled |
boolean |
True if this device object is synced from an on-premises directory, false if the object was originally synced but is no longer synced; null if this object has never been synced from an on-premises directory. |
| OperatingSystem |
string |
The type of operating System of the device as imported from Entra ID |
| OperatingSystemFamily |
string |
OctoSAM OS family name |
| OperatingSystemVersion |
string |
The version of the operating system on the device |
| PhysicalIds |
string |
Entra ID internal device ids |
| ProfileType |
string |
the profile type of the device |
| RawManufacturer |
string |
Raw manufacturer as imported from Entra ID |
| RegistrationDateTime |
datetime |
Date/Time when the device was registered |
| Source |
string |
OctoSAM scan source name |
| SystemLabels |
string |
List of labels applied to the device |
| TrustType |
string |
Type of the trust for the joined device |