DirectoryMissingUser¶
Users that are in Active Directory but not in the OctoSAM database. Used to diagnose missing scanner invocation policies.
Fields¶
| Field | Type | Description |
|---|---|---|
| AccountExpires | datetime2 | accountExpires from ActiveDirectory |
| Checked | datetime2 | Date/Time this user was last checked from AD to the database |
| City | nvarchar | City attribute from Active Directory |
| Company | nvarchar | Company attribute from Active Directory |
| ContainerPath | nvarchar | DistinguishedName of this objects container. Provided for grouping and export to other applications. |
| CustomField1 | nvarchar | Available for custom data, not used by OctoSAM Inventory. |
| CustomField2 | nvarchar | Available for custom data, not used by OctoSAM Inventory. |
| CustomField3 | nvarchar | Available for custom data, not used by OctoSAM Inventory. |
| CustomField4 | nvarchar | Available for custom data, not used by OctoSAM Inventory. |
| Department | nvarchar | Department attribute from Active Directory |
| DepartmentNumber | nvarchar | DepartmentNumber attribute from Active Directory |
| Description | nvarchar | Description attribute from Active Directory |
| Disabled | bit | True if the UserAccountControl attribute has the disable bit set |
| DisplayName | nvarchar | DisplayName attribute from Active Directory |
| DomainName | nvarchar | NETBIOS domain name as specified in the import service configuration |
| EmployeeID | nvarchar | EmployeeID attribute from Active Directory |
| EntraIdTenantId | uniqueidentifier | Entra ID tenant id |
| Ext1 | nvarchar | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Ext2 | nvarchar | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Ext3 | nvarchar | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Ext4 | nvarchar | Site specific data, can optionally be used to load site-specific extended schema properties. |
| ExtensionAttribute1 | nvarchar | From Active Directory |
| ExtensionAttribute10 | nvarchar | From Active Directory |
| ExtensionAttribute11 | nvarchar | From Active Directory |
| ExtensionAttribute12 | nvarchar | From Active Directory |
| ExtensionAttribute13 | nvarchar | From Active Directory |
| ExtensionAttribute14 | nvarchar | From Active Directory |
| ExtensionAttribute15 | nvarchar | From Active Directory |
| ExtensionAttribute2 | nvarchar | From Active Directory |
| ExtensionAttribute3 | nvarchar | From Active Directory |
| ExtensionAttribute4 | nvarchar | From Active Directory |
| ExtensionAttribute5 | nvarchar | From Active Directory |
| ExtensionAttribute6 | nvarchar | From Active Directory |
| ExtensionAttribute7 | nvarchar | From Active Directory |
| ExtensionAttribute8 | nvarchar | From Active Directory |
| ExtensionAttribute9 | nvarchar | From Active Directory |
| ExtraData | nvarchar | Extra data for this item. OctoSAM internal.. |
| Guid | uniqueidentifier | objectGuid from Active Directory |
| HomeDirectory | nvarchar | HomeDirectory attribute from Active Directory |
| HomeDrive | nvarchar | HomeDrive attribute from Active Directory |
| ID | bigint | Internal ID for the DirectoryMissingUser entity (Primary Key) |
| LastLogonTimestamp | datetime2 | LastLogonTimestamp attribute from Active Directory |
| LoginName | nvarchar | sAMAccountName attribute from Active Directory |
| nvarchar | Mail attribute from Active Directory | |
| MappingTag | nvarchar | Reserved for organization mapping |
| MsDSConsistencyGuid | uniqueidentifier | A unique ID used by Microsoft Entra ID to synchronize user information, |
| NoScan | bit | If True this user should not be scanned. It is ignored for scan coverage reporting. |
| OrganizationID | bigint | Internal ID that references the Organization entity (Foreign Key) |
| Path | nvarchar | DistinguishedName of this user object in Active Directory |
| PhysicalDeliveryOfficeName | nvarchar | PhysicalDeliveryOfficeName attribute from Active Directory |
| PostalCode | nvarchar | PostalCod attribute from Active Directory |
| PreferredLanguage | nvarchar | PreferredLanguage attribute from Active Directory |
| PrintableName | nvarchar | Combination of attributes for display and reporting |
| ProxyAddresses | nvarchar | ProxyAddresses attribute from Active Directory |
| Source | nvarchar | Source from where this user object was read. Refers to import service configuration. |
| Street | nvarchar | Street attribute from Active Directory |
| StreetAddress | nvarchar | StreetAddress attribute from Active Directory |
| TelephoneNumber | nvarchar | TelephoneNumber attribute from Active Directory |
| Title | nvarchar | Title (JobTitle) Attribute from Active Directroy |
| UserAccountControl | bigint | UserAccountControl flag from Active Directory |
| UserPrincipalName | nvarchar | UserPrincipalName attribute from Active Directory |
| WhenChanged | datetime2 | whenChanged information from Active Directory |
| WhenCreated | datetime2 | whenCreated information from Active Directory |