# Source: https://docs.datadoghq.com/ddsql_reference/data_directory/azure/azure.ad_device.dataset.md

---
title: Active Directory Device
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > Active Directory Device
---

# Active Directory Device

This table represents the Active Directory Device resource from Microsoft Azure.

```
azure.ad_device
```

## Fields

| Title                              | ID   | Type          | Data Type                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Description |
| ---------------------------------- | ---- | ------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| _key                               | core | string        |
| account_enabled                    | core | bool          | true if the account is enabled; otherwise, false. Required. Default is true. Supports $filter (eq, ne, not, in). Only callers with at least the Cloud Device Administrator role can set this property.                                                                                                                                                                                                                                                          |
| alternative_security_ids           | core | json          | For internal use only. Not nullable. Supports $filter (eq, not, ge, le).                                                                                                                                                                                                                                                                                                                                                                                        |
| approximate_last_sign_in_date_time | core | string        | The timestamp type represents date and time information using ISO 8601 format and is always in UTC time. For example, midnight UTC on Jan 1, 2014 is 2014-01-01T00:00:00Z. Read-only. Supports $filter (eq, ne, not, ge, le, and eq on null values) and $orderby.                                                                                                                                                                                               |
| compliance_expiration_date_time    | core | string        | The timestamp when the device is no longer deemed compliant. The timestamp type represents date and time information using ISO 8601 format and is always in UTC time. For example, midnight UTC on Jan 1, 2014 is 2014-01-01T00:00:00Z. Read-only.                                                                                                                                                                                                              |
| deleted_date_time                  | core | string        | Date and time when this object was deleted. Always null when the object hasn't been deleted.                                                                                                                                                                                                                                                                                                                                                                    |
| device_category                    | core | string        | User-defined property set by Intune to automatically add devices to groups and simplify managing devices.                                                                                                                                                                                                                                                                                                                                                       |
| device_id                          | core | string        | Unique identifier set by Azure Device Registration Service at the time of registration. This alternate key can be used to reference the device object. Supports $filter (eq, ne, not, startsWith).                                                                                                                                                                                                                                                              |
| device_metadata                    | core | string        | For internal use only. Set to null.                                                                                                                                                                                                                                                                                                                                                                                                                             |
| device_ownership                   | core | string        | Ownership of the device. Intune sets this property. Possible values are: unknown, company, personal.                                                                                                                                                                                                                                                                                                                                                            |
| device_version                     | core | int64         | For internal use only.                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| enrollment_profile_name            | core | string        | Enrollment profile applied to the device. For example, Apple Device Enrollment Profile, Device enrollment - Corporate device identifiers, or Windows Autopilot profile name. This property is set by Intune.                                                                                                                                                                                                                                                    |
| enrollment_type                    | core | string        | Enrollment type of the device. Intune sets this property. Possible values are: unknown, userEnrollment, deviceEnrollmentManager, appleBulkWithUser, appleBulkWithoutUser, windowsAzureADJoin, windowsBulkUserless, windowsAutoEnrollment, windowsBulkAzureDomainJoin, windowsCoManagement, windowsAzureADJoinUsingDeviceAuth,appleUserEnrollment, appleUserEnrollmentWithServiceAccount. NOTE: This property might return other values apart from those listed. |
| extensions                         | core | json          | The collection of open extensions defined for the device. Read-only. Nullable.                                                                                                                                                                                                                                                                                                                                                                                  |
| id                                 | core | string        | The unique identifier for an entity. Read-only.                                                                                                                                                                                                                                                                                                                                                                                                                 |
| is_compliant                       | core | bool          | true if the device complies with Mobile Device Management (MDM) policies; otherwise, false. Read-only. This can only be updated by Intune for any device OS type or by an approved MDM app for Windows OS devices. Supports $filter (eq, ne, not).                                                                                                                                                                                                              |
| is_managed                         | core | bool          | true if the device is managed by a Mobile Device Management (MDM) app; otherwise, false. This can only be updated by Intune for any device OS type or by an approved MDM app for Windows OS devices. Supports $filter (eq, ne, not).                                                                                                                                                                                                                            |
| is_management_restricted           | core | bool          | Indicates whether the device is a member of a restricted management administrative unit. If not set, the default value is null and the default behavior is false. Read-only. To manage a device that's a member of a restricted management administrative unit, the administrator or calling app must be assigned a Microsoft Entra role at the scope of the restricted management administrative unit. Returned only on $select.                               |
| is_rooted                          | core | bool          | true if the device is rooted or jail-broken. This property can only be updated by Intune.                                                                                                                                                                                                                                                                                                                                                                       |
| location                           | core | string        |
| management_type                    | core | string        | The management channel of the device. This property is set by Intune. Possible values are: eas, mdm, easMdm, intuneClient, easIntuneClient, configurationManagerClient, configurationManagerClientMdm, configurationManagerClientMdmEas, unknown, jamf, googleCloudDevicePolicyController.                                                                                                                                                                      |
| manufacturer                       | core | string        | Manufacturer of the device. Read-only.                                                                                                                                                                                                                                                                                                                                                                                                                          |
| mdm_app_id                         | core | string        | Application identifier used to register device into MDM. Read-only. Supports $filter (eq, ne, not, startsWith).                                                                                                                                                                                                                                                                                                                                                 |
| member_of                          | core | json          | Groups and administrative units that this device is a member of. Read-only. Nullable. Supports $expand.                                                                                                                                                                                                                                                                                                                                                         |
| model                              | core | string        | Model of the device. Read-only.                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| name                               | core | string        |
| on_premises_last_sync_date_time    | core | string        | The last time at which the object was synced with the on-premises directory. The Timestamp type represents date and time information using ISO 8601 format and is always in UTC time. For example, midnight UTC on Jan 1, 2014 is 2014-01-01T00:00:00Z Read-only. Supports $filter (eq, ne, not, ge, le, in).                                                                                                                                                   |
| on_premises_security_identifier    | core | string        | The on-premises security identifier (SID) for the user who was synchronized from on-premises to the cloud. Read-only. Returned only on $select. Supports $filter (eq).                                                                                                                                                                                                                                                                                          |
| on_premises_sync_enabled           | core | bool          | true if this object is synced from an on-premises directory; false if this object was originally synced from an on-premises directory but is no longer synced; null if this object has never been synced from an on-premises directory (default). Read-only. Supports $filter (eq, ne, not, in, and eq on null values).                                                                                                                                         |
| operating_system                   | core | string        | The type of operating system on the device. Required. Supports $filter (eq, ne, not, ge, le, startsWith, and eq on null values).                                                                                                                                                                                                                                                                                                                                |
| operating_system_version           | core | string        | The version of the operating system on the device. Required. Supports $filter (eq, ne, not, ge, le, startsWith, and eq on null values).                                                                                                                                                                                                                                                                                                                         |
| physical_ids                       | core | array<string> | For internal use only. Not nullable. Supports $filter (eq, not, ge, le, startsWith,/$count eq 0, /$count ne 0).                                                                                                                                                                                                                                                                                                                                                 |
| profile_type                       | core | string        | The profile type of the device. Possible values: RegisteredDevice (default), SecureVM, Printer, Shared, IoT.                                                                                                                                                                                                                                                                                                                                                    |
| registered_owners                  | core | json          | The user that cloud joined the device or registered their personal device. The registered owner is set at the time of registration. Read-only. Nullable. Supports $expand.                                                                                                                                                                                                                                                                                      |
| registered_users                   | core | json          | Collection of registered users of the device. For cloud joined devices and registered personal devices, registered users are set to the same value as registered owners at the time of registration. Read-only. Nullable. Supports $expand.                                                                                                                                                                                                                     |
| registration_date_time             | core | string        | Date and time of when the device was registered. The timestamp type represents date and time information using ISO 8601 format and is always in UTC time. For example, midnight UTC on Jan 1, 2014 is 2014-01-01T00:00:00Z. Read-only.                                                                                                                                                                                                                          |
| resource_group                     | core | string        |
| subscription_id                    | core | string        |
| subscription_name                  | core | string        |
| system_labels                      | core | array<string> | List of labels applied to the device by the system. Supports $filter (/$count eq 0, /$count ne 0).                                                                                                                                                                                                                                                                                                                                                              |
| tags                               | core | hstore_csv    |
| transitive_member_of               | core | json          | Groups and administrative units that the device is a member of. This operation is transitive. Supports $expand.                                                                                                                                                                                                                                                                                                                                                 |
| trust_type                         | core | string        | Type of trust for the joined device. Read-only. Possible values: Workplace (indicates bring your own personal devices), AzureAd (Cloud-only joined devices), ServerAd (on-premises domain joined devices joined to Microsoft Entra ID). For more information, see Introduction to device management in Microsoft Entra ID. Supports $filter (eq, ne, not, in).                                                                                                  |