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 Directroy |
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 |