| ID |
numeric |
false |
Internal ID for the EntraIdMissingDevice entity (Primary Key) |
| Cloud Provider Account ID |
numeric |
false |
Internal ID that references the CloudProviderAccount entity (Foreign Key) |
| Cloud Provider Account |
string |
true |
|
| Entra Id Tenant Id |
guid |
false |
|
| Account Enabled |
bool |
true |
True if the account is enabled |
| Display Name |
string |
true |
The display name for the device |
| Approximate Last Sign In Date Time |
date |
true |
Approximate date/time this device last signed in to Entra ID |
| Registration Date Time |
date |
true |
Date/Time when the device was registered |
| Operating System Family |
string |
false |
OctoSAM OS family name |
| Operating System |
string |
true |
Operating System installed on this machine as reported by OctoSAM scanners |
| Operating System Version |
string |
true |
Version of the Operating System installed on this machine as reported by OctoSAM scanners |
| Raw Manufacturer |
string |
false |
Raw manufacturer as imported from Entra ID |
| Model |
string |
true |
Model of the device |
| On Premises Sync Enabled |
bool |
true |
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. |
| On Premises Last Sync Date Time |
date |
true |
The last time at which the object was synced with the on-premises directory. |
| Enrollment Profile Name |
string |
true |
Enrollment profile applied to the device |
| Profile Type |
string |
true |
The profile type of the device |
| Is Compliant |
bool |
true |
True if the device complies with Mobile Device Management (MDM) policies |
| Is Managed |
bool |
true |
Ture if the device is managed by Mobile Device Management (MDM) policies |
| Entra Id Id |
string |
false |
The unique Entra ID identifier of the device object |
| Device Id |
string |
false |
Unique identifier set by Entra ID device registration service at the time of registration |
| Custom Field1 |
string |
false |
Site specific custom data, not used by OctoSAM |
| Custom Field2 |
string |
false |
Site specific custom data, not used by OctoSAM |
| Custom Field3 |
string |
false |
Site specific custom data, not used by OctoSAM |
| Custom Field4 |
string |
false |
Site specific custom data, not used by OctoSAM |
| Ext1 |
string |
false |
Reserved for future use |
| Ext2 |
string |
false |
Reserved for future use |
| Ext3 |
string |
false |
Reserved for future use |
| Ext4 |
string |
false |
Reserved for future use |
| Extension Attribute1 |
string |
false |
Extension Attribute 1 from Entra ID |
| Extension Attribute2 |
string |
false |
Extension Attribute 2 from Entra ID |
| Extension Attribute3 |
string |
false |
Extension Attribute 3 from Entra ID |
| Extension Attribute4 |
string |
false |
Extension Attribute 4 from Entra ID |
| Extension Attribute5 |
string |
false |
Extension Attribute 5 from Entra ID |
| Extension Attribute6 |
string |
false |
Extension Attribute 6 from Entra ID |
| Extension Attribute7 |
string |
false |
Extension Attribute 7 from Entra ID |
| Extension Attribute8 |
string |
false |
Extension Attribute 8 from Entra ID |
| Extension Attribute9 |
string |
false |
Extension Attribute 9 from Entra ID |
| Extension Attribute10 |
string |
false |
Extension Attribute 10 from Entra ID |
| Extension Attribute11 |
string |
false |
Extension Attribute 11 from Entra ID |
| Extension Attribute12 |
string |
false |
Extension Attribute 12 from Entra ID |
| Extension Attribute13 |
string |
false |
Extension Attribute 13 from Entra ID |
| Extension Attribute14 |
string |
false |
Extension Attribute 14 from Entra ID |
| Extension Attribute15 |
string |
false |
Extension Attribute 15 from Entra ID |
| No Scan |
bool |
true |
This flag can be set for devices where we know that they should not be scanned by OctoSAM |
| Source |
string |
true |
OctoSAM scan source name |
| Checked |
date |
true |
DateTime this information was last checked against EntraID |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |