Skip to content

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,