Skip to content

Users not scanned from Active Directory

Identify users from Active Directory that have not yet been scanned by the OctoSAM Inventory scanner. This may help to identify missing configuration to invoke Octoscan2 on all systems.

LastLogonTimestamp resolution

The LastLogonTimestamp attribute is replicated across domain controllers, but it has a resolution of approximately 14 days. This means that if a user logs on to a computer, the LastLogonTimestamp may not be updated immediately. As a result, the LastLogonTimestamp may not accurately reflect the user's last logon time.

Fields

Name Type Visible Description
ID numeric false Internal ID for the DirectoryMissingUser entity (Primary Key)
User string true Distinct user name. Use Column Chooser to show partial values such as Login Name, Domain or Display Name of users
Login Name string false sAMAccountName attribute from Active Directory
User Principal Name string true UserPrincipalName attribute from Active Directory
Domain Name string false NETBIOS domain name as specified in the import service configuration
Organization ID numeric false Internal ID that references the Organization entity (Foreign Key)
Organization string true Name of the organization this entity is mapped to
Organization Description string false Description for the organization this entity is mapped to
Title string false Title (JobTitle) Attribute from Active Directroy
Mail string true Mail attribute from Active Directory
Proxy Addresses string false ProxyAddresses attribute from Active Directory
Street string false Street attribute from Active Directory
Street Address string false StreetAddress attribute from Active Directory
City string false City attribute from Active Directory
Path string false DistinguishedName of this user object in Active Directory
Container Path string true DistinguishedName of this objects container. Provided for grouping and export to other applications.
Home Directory string false HomeDirectory attribute from Active Directory
Home Drive string false HomeDrive attribute from Active Directory
Employee ID string false EmployeeID attribute from Active Directory
Company string false Company attribute from Active Directory
Department string false Department attribute from Active Directory
Department Number string false DepartmentNumber attribute from Active Directory
Physical Delivery Office Name string false PhysicalDeliveryOfficeName attribute from Active Directory
Display Name string false DisplayName attribute from Active Directory
Description string false Description attribute from Active Directory
Custom Field1 string false Available for custom data, not used by OctoSAM Inventory.
Custom Field2 string false Available for custom data, not used by OctoSAM Inventory.
Custom Field3 string false Available for custom data, not used by OctoSAM Inventory.
Custom Field4 string false Available for custom data, not used by OctoSAM Inventory.
Ext1 string false Site specific data, can optionally be used to load site-specific extended schema properties.
Ext2 string false Site specific data, can optionally be used to load site-specific extended schema properties.
Ext3 string false Site specific data, can optionally be used to load site-specific extended schema properties.
Ext4 string false Site specific data, can optionally be used to load site-specific extended schema properties.
Extension Attribute1 string false From Active Directory
Extension Attribute2 string false From Active Directory
Extension Attribute3 string false From Active Directory
Extension Attribute4 string false From Active Directory
Extension Attribute5 string false From Active Directory
Extension Attribute6 string false From Active Directory
Extension Attribute7 string false From Active Directory
Extension Attribute8 string false From Active Directory
Extension Attribute9 string false From Active Directory
Extension Attribute10 string false From Active Directory
Extension Attribute11 string false From Active Directory
Extension Attribute12 string false From Active Directory
Extension Attribute13 string false From Active Directory
Extension Attribute14 string false From Active Directory
Extension Attribute15 string false From Active Directory
Preferred Language string false PreferredLanguage attribute from Active Directory
Last Logon Timestamp date true Date/Time this account last logged on to Active Directory. This value is not instantly replicated and may not be exact. Resolution is configurable, usually about 14 days.
When Created date false whenCreated information from Active Directory
When Changed date false whenChanged information from Active Directory
User Account Control numeric false UserAccountControl flag from Active Directory
Disabled bool true True if the UserAccountControl attribute has the disable bit set
Source string false Source from where this user object was read. Refers to import service configuration.
No Scan bool true If True this user should not be scanned. It is ignored for scan coverage reporting.
Checked date true Date/Time this user was last checked from AD to the database
Current Date Time date false Date and time the query was run. For reference if you use and save query results.

Main entities referenced from this query

Query information

Property Value Description
Query Guid 1280c4cf-a78d-4bf9-bc3b-64f9755719f4 The internal id of the query. Must be unique
SupportsDesktop true If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb true If true, the query can be started from the OctoSAM Web UI