User¶
Basic user Information.
Fields¶
| Field | Type | Description |
|---|---|---|
| Active | boolean | Reserved for future use |
| AnalysisExtras | xml | Holds additional analysis data |
| CloudProviderAccountID | numeric | Internal ID that references the CloudProviderAccount entity (Foreign Key) |
| CostCenterID | numeric | Internal ID that references the CostCenter entity (Foreign Key) |
| Created | datetime | Date/Time this object was created |
| CreatedGUID | guid | Scan GUID that created this object |
| CustomField1 | string | Available for custom data, not used by OctoSAM Inventory |
| CustomField2 | string | Available for custom data, not used by OctoSAM Inventory |
| CustomField3 | string | Custom Data - not used by OctoSAM Inventory |
| CustomField4 | string | Custom Data - not used by OctoSAM Inventory |
| DeletedInDirectory | boolean | True, if the user object was deleted from the directory |
| DeletedInDirectoryFirstDetected | datetime | Date/Time the DeletedInDirectory flag was set |
| Description | string | Description attribute from the directory service |
| DirectoryAccountExpires | datetime | accountExpires attribute from Active Directory (updated on import and housekeeping) |
| DirectoryCity | string | City attribute from Active Directory |
| DirectoryCompany | string | Directory attribute from Active Directory |
| DirectoryContainerPath | string | Path to the container object of this user |
| DirectoryDepartment | string | Department from Active Directory |
| DirectoryDepartmentNumber | string | DepartmentNumber from Active Directory |
| DirectoryDisabled | boolean | True if the UserAccountControl attribute has the disable bit set |
| DirectoryEmployeeID | string | EmployeeID attribute from Active Directory (updated on import and housekeeping) |
| DirectoryExt1 | string | Site specific data, can optionally be used to load site-specific extended schema properties |
| DirectoryExt2 | string | Site specific data, can optionally be used to load site-specific extended schema properties |
| DirectoryExt3 | string | Site specific data, can optionally be used to load site-specific extended schema properties |
| DirectoryExt4 | string | Site specific data, can optionally be used to load site-specific extended schema properties |
| DirectoryExtensionAttribute1 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute10 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute11 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute12 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute13 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute14 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute15 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute2 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute3 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute4 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute5 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute6 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute7 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute8 | string | ExtensionAttribute from Active Directory |
| DirectoryExtensionAttribute9 | string | ExtensionAttribute from Active Directory |
| DirectoryGUID | guid | objectGuid attribute from Active Directory |
| DirectoryHomeDirectory | string | HomeDirectory attribute from Active Directory |
| DirectoryHomeDrive | string | HomeDrive attribute from Active Directory |
| DirectoryLastLogonTimestamp | datetime | LastLogonTimestamp attribute from Active Directory (updated on import and housekeeping). Resolution: 14 days. |
| DirectoryMail | string | Mail attribute from Active Directory |
| DirectoryMsDSConsistencyGuid | guid | A unique ID used by Microsoft Entra ID to synchronize user information |
| DirectoryPath | string | Path of the user object in the directory service |
| DirectoryPhysicalDeliveryOfficeName | string | PhysicalDeliveryOfficeName attribute from Active Directory |
| DirectoryPostalCode | string | PostalCode attribute from Active Directory |
| DirectoryPreferredLanguage | string | User's preferred language from ActiveDirectory |
| DirectoryProxyAddresses | string | ProxyAddresses attribute from Active Directory |
| DirectoryStreet | string | Street attribute from Active Directory |
| DirectoryStreetAddress | string | StreetAddress attribute from Active Directory |
| DirectoryTelephoneNumber | string | TelephoneNumber attribute from Active Directory |
| DirectoryTitle | string | Title (JobTitle) attribute from Active Directory |
| DirectoryType | string | Directory type that this user was found in |
| DirectoryUserAccountControl | numeric | UserAccountControl attribute from Active Directory (updated on import and housekeeping) |
| DirectoryWhenChanged | datetime | whenChanged attribute from Active Directory (updated on import and housekeeping) |
| DirectoryWhenCreated | datetime | whenCreated attribute from Active Directory |
| DisplayName | string | DisplayName attribute from the directory service |
| DnsDomain | string | The user's DNS domain |
| DomainName | string | Domain of the logged on user |
| EntraIdAccountEnabled | boolean | Entra ID AccountEnabled |
| EntraIdCostCenter | string | Cost center from Entra ID |
| EntraIdCreatedDateTime | datetime | Date/Time created in Entra ID |
| EntraIdCreationType | string | Entra ID creation type |
| EntraIdDeletedDateTime | datetime | Date/Time this user object was deleted in Azure AD |
| EntraIdDivision | string | Division from Entra ID |
| EntraIdEmployeeHireDate | datetime | Date this employee was hired |
| EntraIdEmployeeLeaveDateTime | datetime | Date/Time this employee was left or will leave |
| EntraIdGivenName | string | Given name of the user |
| EntraIdId | string | Microsoft EntraID ID of this user |
| EntraIdLastNonInteractiveSignInDateTime | datetime | Date/Time of the last non-interactive sign in to Entra ID. This information may not be available depending on your Entra ID license. |
| EntraIdLastNonInteractiveSignInRequestId | string | Request id of the last non-interactive sign in to Entra ID. This information may not be available depending on your Entra ID license. |
| EntraIdLastSignInDateTime | datetime | Date/Time this user last signed in to Entra ID. This information may not be available depending on your Entra ID license. |
| EntraIdLastSignInRequestId | string | Request id of the last Entra ID sign in. This information may not be available depending on your Entra ID license. |
| EntraIdLastSuccessfulSignInDateTime | datetime | |
| EntraIdLastSuccessfulSignInRequestId | string | |
| EntraIdOnPremisesDistinguishedName | string | Distinguished name that got replicated from on-site to Entra ID |
| EntraIdOnPremisesDomainName | string | Domain name that got replicated from on-site to Entra ID |
| EntraIdOnPremisesLastSyncDateTime | datetime | Date/Time this object was last synchronized from on-site AD |
| EntraIdOnPremisesSID | string | SID of the on-prem user |
| EntraIdOnPremisesSyncEnabled | boolean | If true the user object gets synchronized from an on-size AD |
| EntraIdOnPremisesUserPrincipalName | string | UPN that got synchronized from on-prem AD |
| EntraIdPreferredDataLocation | string | Preferred data location from Entra ID |
| EntraIdSurname | string | Surname of the user |
| EntraIdSyncDiagnostics | string | Diagnostics message from the OctoSAM Graph Entra ID importer |
| EntraIdTenantId | guid | Entra ID tenant Id |
| EntraIdUserType | string | Entra ID user type |
| ExcludeFromSoftwareInventory | boolean | If true, software signatures reported by this user are ignored |
| ExtraData | string | Extra data collected for this user |
| FirstScan | datetime | Date/Time of first scan |
| FoundInDirectory | boolean | True if the user was found in Active Directory at the last check (usually within 1 day) |
| Guid | guid | A unique ID that can be used to link to this user object by external applications |
| HintCloudServices | boolean | True if the user has any assigned cloud services |
| HintHasAccessLog | boolean | True if user has UAL data available |
| HintHasAutoStart | boolean | True if the user has scanned Windows auto start information |
| HintHasBrowserExtensions | boolean | |
| HintHasCloudAppUsage | boolean | True if Microsoft 365 usage data is available in the OctoSAM inventory |
| HintHasMuiCache | boolean | True if the user has scanned MUI Cache information |
| HintHasOfficeAddIns | boolean | True, if Microsoft Office add-ins have been detected on this machine |
| HintHasRelevantSoftwareItems | boolean | True if there are software items relevant for this user |
| HintInGroups | boolean | True if the User is member in any Group |
| HintOwnsSoftwareItems | boolean | True if the user owns any software Items |
| HintSoftwarePackageUsageEndDate | datetime | Max consolidated usage date for this User |
| HintSoftwarePackageUsageStartDate | datetime | Min consolidated usage date for this User |
| ID | numeric | Internal ID for the User entity (Primary Key) |
| ID | numeric | Internal ID for the User entity (Primary Key) |
| IgnoreNewSignatures | boolean | If true, new signatures reported by this user are ignored |
| ImporterInstance | string | Import instance name if multiple import modules write to the same database |
| ImportSourceID | numeric | Always 1 for current version of OctoSAM Inventory |
| LastFoundInDirectory | datetime | Date/Time the user object was last found in Active Directory |
| LastFoundInEntraId | datetime | Date/Time this user was last found in Entra ID |
| LastMachineID | numeric | Internal ID that references the Machine entity (Foreign Key) |
| LastModification | datetime | Time of last write to the entity |
| LastModifiedBy | string | Windows User that last modified this User record through the OctoSAM UI |
| LastScan | datetime | Date/Time of last scan of this user. User info may stem from multiple sources. Time can by out of sync for users scanned on client machines. |
| LastScanGUID | guid | GUID of last scan file that updated this entity |
| LastScannerTag | string | Command-line tag that was specified on the last scan of this user |
| LoginName | string | Access |
| MacFullName | string | For users scanned on Mac, contains the users FullName as seen by system_profiler |
| MappingTag | string | A field that can be used for custom organization mapping |
| MostFrequentlyUsedMachineID | numeric | Internal ID that references the Machine entity (Foreign Key) |
| Notes | string | Custom notes |
| NumericUserID | numeric | For users scanned on Unix/Linux/macOS contains the numeric user id |
| ObjectStateID | numeric | Internal ID that references the ObjectState entity (Foreign Key) |
| OrganizationID | numeric | Internal ID that references the Organization entity (Foreign Key) |
| PrintableName | string | Combination of attributes for consistent naming on screen or in reports |
| Res1 | string | Reserved for internal use by future versions |
| Res2 | string | Reserved for internal use by future versions |
| ScannedDistinguishedName | string | Distinguished user name as seen locally from the scanner. This is scanned using GetUserNameEx() on Windows and may differ from the DirectoryPath attribute. |
| ServiceNowLastExport | datetime | Date/Time of last export to ServiceNow |
| ServiceNowLastImport | datetime | Date/Time of last import from ServiceNow |
| ServiceNowSysID | guid | Service Now: sys_id of the replicated object |
| SID | string | Security Identifier |
| SuggestSoftwareUninstall | boolean | If true, suggest this user in reports / queries for software uninstalls |
| SynchLastSynch | datetime | Timestamp of last synchronization of this User with the partner CMDB. Not used by OctoSAM Inventory. |
| SynchTokenID | string | Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Not used by OctoSAM Inventory. |
| UserPrincipalName | string | UserPrincipalName from the directory service |