Scanned and not scanned users combined¶
Shows a combined list of users from scans and unscanned users from active directory.
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 |
|---|---|---|---|
| Missing User ID | numeric | false | OctoSAM internal ID of this MissingUser entity |
| User ID | numeric | false | OctoSAM Inventory internal ID of the user entity |
| User Guid | guid | false | OctoSAM Inventory internal Guid of the user entity |
| Source | string | true | Source from where this user object was read. Refers to import service configuration. |
| Login Name | string | false | sAMAccountName attribute from Active Directory |
| User Principal Name | string | true | UserPrincipalName attribute from Active Directory |
| Domain Name | string | true | NETBIOS Domain name |
| Printable Name | string | true | Combination of attributes for display and reporting |
| Display Name | string | false | DisplayName attribute from Active Directory |
| Last Scan | date | true | Date/Time this entity got scanned last |
| 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 |
| Title | string | false | Title (JobTitle) Attribute from Active Directory |
| 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 |
| 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 |
| No Scan | bool | true | If True this user should not be scanned. It is ignored for scan coverage reporting. |
| Most Frequently Used Machine ID | numeric | false | OctoSAM internal ID of the machine this user used most frequently |
| Most Frequently Used Machine Guid | string | false | OctoSAM internal Guid of the machine this user used most frequently |
| Most Frequently Used Machine | guid | false | Machine that this user logs on most frequently |
| 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 | 623e5656-babf-4947-a81a-660a8082ad00 | 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 |
| LastUpdate | 2025-09-10 17:27:37 | Last change to this document |
| Build | 1.11.6.94 | OctoSAM build that last changed this document |