EntraIdMissingUser¶
Users that we found in Entra ID that have not been scanned
Fields¶
| Field | Type | Description |
|---|---|---|
| AboutMe | nvarchar | A free-form text entry field for the user to describe themselves |
| AccountEnabled | bit | True if the account is enabled |
| Birthday | datetime2 | Birthday |
| BusinessPhones | nvarchar | The telephone numbers of the user |
| Checked | datetime2 | Date/Time this entity was last checked against Entra ID |
| City | nvarchar | The city where the user is located |
| CloudProviderAccountID | bigint | Internal ID that references the CloudProviderAccount entity (Foreign Key) |
| CompanyName | nvarchar | The name of the company the user is associated with |
| Country | nvarchar | The country or region where the user is located |
| Created | datetime2 | Date/Time this entity was created in OctoSAM Inventory |
| CreatedDateTime | datetime2 | Date/Time the user was created in Entra ID |
| CreationType | nvarchar | Indicates the method through which the user account was created |
| CustomField1 | nvarchar | Field reserved for customer-specific data. Not used by OctoSAM. |
| CustomField2 | nvarchar | Field reserved for customer-specific data. Not used by OctoSAM. |
| CustomField3 | nvarchar | Field reserved for customer-specific data. Not used by OctoSAM. |
| CustomField4 | nvarchar | Field reserved for customer-specific data. Not used by OctoSAM. |
| DeletedDateTime | datetime2 | Date/Time the user was deleted in Entra ID |
| Department | nvarchar | The name of the department in which the user works |
| DisplayName | nvarchar | The name displayed in the address book for the user |
| EmployeeHireDate | datetime2 | Date/Time when the user was hired or will start work in a future hire |
| EmployeeID | nvarchar | The employee identifier assigned to the user by the organization |
| EmployeeLeaveDateTime | datetime2 | Date/Time when the user left or will leave the organization |
| EmployeeType | nvarchar | Captures enterprise worker type |
| EntraIdId | nvarchar | The Entra ID unique identifier for the user |
| Ext1 | nvarchar | Reserved for future use |
| Ext2 | nvarchar | Reserved for future use |
| Ext3 | nvarchar | Reserved for future use |
| Ext4 | nvarchar | Reserved for future use |
| ExternalUserState | nvarchar | For an external user invited to the tenant using the invitation API, this property represents the invited user's invitation status |
| ExternalUserStateChangeDateTime | datetime2 | Date/Time for the latest change to the ExternalUserState property |
| ExtraData | nvarchar | Reserved for future use |
| FaxNumber | nvarchar | The fax number of the user |
| FirstScan | datetime2 | Date/Time this Entra ID user was first scanned by OctoSAM |
| GivenName | nvarchar | The given name (first name) of the user |
| HireDate | datetime2 | The hire date of the user |
| ID | bigint | Internal ID for the EntraIdMissingUser entity (Primary Key) |
| JobTitle | nvarchar | The user's job title |
| LastNonInteractiveSignInDateTime | datetime2 | Date/Time of last non-interactive sign in to Entra ID. Not available for some Entra ID license types. |
| LastNonInteractiveSignInRequestId | nvarchar | Request Id of the user's last non-interactive sign in to Entra ID |
| LastPasswordChangeDateTime | datetime2 | Date/Time this Microsoft Entra user last changed their password or when their password was created |
| LastScan | datetime2 | Date/Time this Entra ID user was first scanned by OctoSAM |
| LastSignInDateTime | datetime2 | Date/Time this user last signed in to Entra ID. Not available for some Entra ID license types. |
| LastSignInRequestId | nvarchar | Request Id of the user's last sign in to Entra ID |
| nvarchar | The SMTP mail address for the user | |
| MailNickname | nvarchar | Mail alias for the user |
| MappingTag | nvarchar | Reserved for future use |
| MobilePhone | nvarchar | The primary cellular telephone number for the user |
| MySite | nvarchar | The URL for the user's site |
| NoScan | bit | If true, this user should be excluded from scanning. |
| OfficeLocation | nvarchar | The office location in the user's place of business |
| OnPremisesDistinguishedName | nvarchar | Contains the on-premises Active Directory distinguished name or DN. The property is only populated for customers who are synchronizing their on-premises directory to Microsoft Entra ID via Microsoft Entra Connect. |
| OnPremisesDomainName | nvarchar | Contains the on-premises domainFQDN, also called dnsDomainName synchronized from the on-premises directory |
| OnPremisesExtensionAttribute1 | nvarchar | For synchronized users this is Extension Attribute 1 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute10 | nvarchar | For synchronized users this is ExtensionAttribute 10 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute11 | nvarchar | For synchronized users this is ExtensionAttribute 11 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute12 | nvarchar | For synchronized users this is ExtensionAttribute 12 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute13 | nvarchar | For synchronized users this is ExtensionAttribute 13 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute14 | nvarchar | For synchronized users this is ExtensionAttribute 14 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute15 | nvarchar | For synchronized users this is ExtensionAttribute 15 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute2 | nvarchar | For synchronized users this is Extension Attribute 2 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute3 | nvarchar | For synchronized users this is Extension Attribute 3 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute4 | nvarchar | For synchronized users this is ExtensionAttribute 4 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute5 | nvarchar | For synchronized users this is ExtensionAttribute 5 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute6 | nvarchar | For synchronized users this is ExtensionAttribute 6 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute7 | nvarchar | For synchronized users this is ExtensionAttribute 7 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute8 | nvarchar | For synchronized users this is ExtensionAttribute 8 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesExtensionAttribute9 | nvarchar | For synchronized users this is ExtensionAttribute 9 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools. |
| OnPremisesImmutableId | nvarchar | This property is used to associate an on-premises Active Directory user account to their Microsoft Entra user object. This property must be specified when creating a new user account in the Graph if you're using a federated domain for the user's userPrincipalName (UPN) property. |
| OnPremisesLastSyncDateTime | datetime2 | Indicates the last time at which the object was synced with the on-premises directory |
| OnPremisesSamAccountName | nvarchar | Contains the on-premises samAccountName synchronized from the on-premises directory. The property is only populated for customers who are synchronizing their on-premises directory to Microsoft Entra ID via Microsoft Entra Connect. |
| OnPremisesSecurityIdentifier | nvarchar | Contains the on-premises security identifier (SID) for the user that was synchronized from on-premises to the cloud |
| OnPremisesSyncEnabled | bit | true if this user object is currently being synced from an on-premises Active Directory (AD); otherwise the user isn't being synced and can be managed in Microsoft Entra ID. |
| OnPremisesUserPrincipalName | nvarchar | Contains the on-premises userPrincipalName synchronized from the on-premises directory. The property is only populated for customers who are synchronizing their on-premises directory to Microsoft Entra ID via Microsoft Entra Connect. |
| PasswordPolicies | nvarchar | Specifies password policies for the user. This value is an enumeration with one possible value being DisableStrongPassword, which allows weaker passwords than the default policy to be specified. DisablePasswordExpiration can also be specified. The two may be specified together; for example: DisablePasswordExpiration, DisableStrongPassword. |
| PostalCode | nvarchar | The postal code for the user's postal address. The postal code is specific to the user's country/region. |
| PreferredDataLocation | nvarchar | The preferred data location for the user. |
| PreferredLanguage | nvarchar | The preferred language for the user. The preferred language format is based on RFC 4646. The name is a combination of an ISO 639 two-letter lowercase culture code associated with the language and an ISO 3166 two-letter uppercase subculture code associated with the country or region. Example: "en-US", or "es-ES". |
| RefreshTokensValidFromDateTime | datetime2 | Any refresh tokens or sessions tokens (session cookies) issued before this time are invalid, and applications get an error when using an invalid refresh or sessions token to acquire a delegated access token (to access APIs such as Microsoft Graph). If this happens, the application needs to acquire a new refresh token by requesting the authorized endpoint. |
| SecurityIdentifier | nvarchar | Security identifier (SID) of the user, used in Windows scenarios. |
| SignInSessionsValidFromDateTime | datetime2 | Any refresh tokens or sessions tokens (session cookies) issued before this time are invalid, and applications get an error when using an invalid refresh or sessions token to acquire a delegated access token (to access APIs such as Microsoft Graph). If this happens, the application needs to acquire a new refresh token by requesting the authorized endpoint. |
| Source | nvarchar | OctoSAM scan source name |
| State | nvarchar | The state or province in the user's address |
| StreetAddress | nvarchar | The street address of the user's place of business |
| Surname | nvarchar | The user's surname (family name or last name) |
| UsageLocation | nvarchar | A two-letter country code (ISO standard 3166). Required for users that are assigned licenses due to legal requirements to check for availability of services in countries. Examples include: US, JP, and GB. |
| UserPrincipalName | nvarchar | The user principal name (UPN) of the user. The UPN is an Internet-style sign-in name for the user based on the Internet standard RFC 822. By convention, this should map to the user's email name. The general format is alias@domain, where the domain must be present in the tenant's collection of verified domains. This property is required when a user is created. The verified domains for the tenant can be accessed from the verifiedDomains property of organization. |
| UserType | nvarchar | A string value that can be used to classify user types in your directory, such as Member and Guest. |