Skip to content

DirectoryMissingUser

Users that are in Active Directory but not in the OctoSAM database. Used to diagnose missing scanner invocation policies.

erDiagram
    Organization ||--o{ DirectoryMissingUser : "OrganizationID"
    DirectoryMissingUser ||--o{ DirectoryMissingUserGroup : "DirectoryMissingUserID"

Fields

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

References

Column Name Referenced Table Description
OrganizationID Organization Defines the organizations of this OctoSAM installation

Referenced by

Table Column Name Description
DirectoryMissingUserGroup DirectoryMissingUserID M:n relation between Group and DirectoryMissingUser tables