EntraIdMissingDevice¶
Devices that we found in Entra ID that have not been scanned
Fields¶
| Field | Type | Description |
|---|---|---|
| AccountEnabled | bit | True if the account is enabled |
| ApproximateLastSignInDateTime | datetime2 | Approximate date/time this device last signed in to Entra ID |
| Checked | datetime2 | DateTime this information was last checked against EntraID |
| CloudProviderAccountID | bigint | Internal ID that references the CloudProviderAccount entity (Foreign Key) |
| ComplianceExpirationDateTime | datetime2 | The timestamp when the device is no longer deemed compliant |
| Created | datetime2 | Date/Time this device entity got created in OctoSAM |
| CustomField1 | nvarchar | Site specific custom data, not used by OctoSAM |
| CustomField2 | nvarchar | Site specific custom data, not used by OctoSAM |
| CustomField3 | nvarchar | Site specific custom data, not used by OctoSAM |
| CustomField4 | nvarchar | Site specific custom data, not used by OctoSAM |
| DeviceCategory | nvarchar | User-defined property set by Intune to automatically add devices to groups and simplify managing devices |
| DeviceId | nvarchar | Unique identifier set by Entra ID device registration service at the time of registration |
| DeviceMetadata | nvarchar | Device metadata from Entra ID |
| DeviceOwnership | nvarchar | Ownership of the device. Set by Intune. |
| DeviceVersion | bigint | Device version from Entra ID |
| DisplayName | nvarchar | The display name for the device |
| EnrollmentProfileName | nvarchar | Enrollment profile applied to the device |
| EntraIdId | nvarchar | The unique Entra ID identifier of the device object |
| Ext1 | nvarchar | Reserved for future use |
| Ext2 | nvarchar | Reserved for future use |
| Ext3 | nvarchar | Reserved for future use |
| Ext4 | nvarchar | Reserved for future use |
| ExtensionAttribute1 | nvarchar | Extension Attribute 1 from Entra ID |
| ExtensionAttribute10 | nvarchar | Extension Attribute 10 from Entra ID |
| ExtensionAttribute11 | nvarchar | Extension Attribute 11 from Entra ID |
| ExtensionAttribute12 | nvarchar | Extension Attribute 12 from Entra ID |
| ExtensionAttribute13 | nvarchar | Extension Attribute 13 from Entra ID |
| ExtensionAttribute14 | nvarchar | Extension Attribute 14 from Entra ID |
| ExtensionAttribute15 | nvarchar | Extension Attribute 15 from Entra ID |
| ExtensionAttribute2 | nvarchar | Extension Attribute 2 from Entra ID |
| ExtensionAttribute3 | nvarchar | Extension Attribute 3 from Entra ID |
| ExtensionAttribute4 | nvarchar | Extension Attribute 4 from Entra ID |
| ExtensionAttribute5 | nvarchar | Extension Attribute 5 from Entra ID |
| ExtensionAttribute6 | nvarchar | Extension Attribute 6 from Entra ID |
| ExtensionAttribute7 | nvarchar | Extension Attribute 7 from Entra ID |
| ExtensionAttribute8 | nvarchar | Extension Attribute 8 from Entra ID |
| ExtensionAttribute9 | nvarchar | Extension Attribute 9 from Entra ID |
| ExtraData | nvarchar | Reserved for future use |
| FirstScan | datetime2 | Date/Time this device was first imported from Entra ID |
| ID | bigint | Internal ID for the EntraIdMissingDevice entity (Primary Key) |
| IsCompliant | bit | True if the device complies with Mobile Device Management (MDM) policies |
| IsManaged | bit | Ture if the device is managed by Mobile Device Management (MDM) policies |
| LastScan | datetime2 | Date/Time this device was last scanned from Entra ID |
| MappingTag | nvarchar | Reserved for future use |
| MdmAppID | nvarchar | MDM Appl ID from Entra ID |
| Model | nvarchar | Model of the device |
| NoScan | bit | This flag can be set for devices where we know that they should not be scanned by OctoSAM |
| OnPremisesLastSyncDateTime | datetime2 | The last time at which the object was synced with the on-premises directory. |
| OnPremisesSyncEnabled | bit | 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 dictionary. |
| OperatingSystem | nvarchar | The type of operating System of the device as imported from Entra ID |
| OperatingSystemFamily | nvarchar | OctoSAM OS family name |
| OperatingSystemVersion | nvarchar | The version of the operating system on the device |
| PhysicalIds | nvarchar | Entra ID internal device ids |
| ProfileType | nvarchar | the profile type of the device |
| RawManufacturer | nvarchar | Raw manufacturer as imported from Entra ID |
| RegistrationDateTime | datetime2 | Date/Time when the device was registered |
| Source | nvarchar | OctoSAM scan source name |
| SystemLabels | nvarchar | List of labels applied to the device |
| TrustType | nvarchar | Type of the trust for the joined device |