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