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