User

Basic user Information.

erDiagram
    CloudProviderAccount ||--o{ User : "CloudProviderAccountID"
    CostCenter ||--o{ User : "CostCenterID"
    Machine ||--o{ User : "LastMachineID"
    Machine ||--o{ User : "MostFrequentlyUsedMachineID"
    ObjectState ||--o{ User : "ObjectStateID"
    Organization ||--o{ User : "OrganizationID"
    User ||--o{ CloudUser : "UserID"
    User ||--o{ ImportControl : "UserID"
    User ||--o{ LicenseManagerServerUser : "UserID"
    User ||--o{ Machine : "LastUserID"
    User ||--o{ Machine : "MostFrequentUserID"
    User ||--o{ MachineUser : "UserID"
    User ||--o{ RbacUser : "UserID"
    User ||--o{ SoftwareItemUser : "UserID"
    User ||--o{ SoftwarePackageUsageDetail : "UserID"
    User ||--o{ UalUserAccess : "UserID"
    User ||--o{ UsageDetail : "UserID"
    User ||--o{ UserCloudProviderAccountLicensingPlan : "UserID"
    User ||--o{ UserGroup : "UserID"
    User ||--o{ UserMachineAffinity : "UserID"

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 Entra ID
EntraIdDivision	string	Division from Entra ID
EntraIdEmployeeHireDate	datetime	Date this employee was hired
EntraIdEmployeeLeaveDateTime	datetime	Date/Time this employee left or will leave
EntraIdExternalUserState	string	Tracks the acceptance status of an invited B2B collaboration guest
EntraIdExternalUserStateChanged	datetime	Date/Time when the EntraIdExternalUserState was last changed
EntraIdGivenName	string	Given name of the user
EntraIdId	string	Microsoft Entra ID ID of this user
EntraIdIsResourceAccount	boolean	A resource account is a specialized user identity created for shared spaces, devices, or applications. Resource accounts are not intended for interactive sign-in by users.
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	Date/Time of the last successful sign in to Entra ID. This information may not be available depending on your Entra ID license. This encompasses both interactive and non-interactive sign ins.
EntraIdLastSuccessfulSignInRequestId	string	Request id of the last successful sign in to Entra ID. This information may not be available depending on your Entra ID license. This encompasses both interactive and non-interactive sign ins.
EntraIdOnPremisesDistinguishedName	string	Distinguished name that was replicated from on-site to Entra ID
EntraIdOnPremisesDomainName	string	Domain name that was 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-premises AD
EntraIdOnPremisesUserPrincipalName	string	UPN that was synchronized from on-prem AD
EntraIdOtherMails	string	A list of additional email addresses for the user from Entra ID
EntraIdPreferredDataLocation	string	Preferred data location from Entra ID
EntraIdPreferredLanguage	string	Preferred language from Entra ID
EntraIdProxyAddresses	string	Additional email addresses for the user 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
EntraIdUsageLocation	string	Usage location from Entra 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	True if the user has scanned browser extension information
HintHasCloudAppUsage	boolean	True if Microsoft 365 usage data is available in the OctoSAM inventory
HintHasCloudEmailActivity	boolean	True if Microsoft 365 email activity data is available for this user
HintHasDocuments	boolean	True if the user has associated documents
HintHasEnvironmentVariables	boolean	True if the user has scanned environment variables
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
LoginName	string	Login name of the user as seen by the scanner
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	ServiceNow: 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

References

Column Name	Referenced Table	Description
CloudProviderAccountID	CloudProviderAccount	Cloud provider specific account
CostCenterID	CostCenter	Cost center information
LastMachineID	Machine	Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
MostFrequentlyUsedMachineID	Machine	Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
ObjectStateID	ObjectState	Object states for various OctoSAM entities
OrganizationID	Organization	Defines the organizations of this OctoSAM installation

Referenced by

Table	Column Name	Description
CloudUser	UserID	Provider specific cloud user information
ImportControl	UserID	Holds the GUIDs of all imported .scan files. This helps to eliminate duplicate imports of the same data, which could influence, for example, the usage metering information. The table can also be used to collect information about active scanner versions and history.
LicenseManagerServerUser	UserID	Used to store user information for per user statistics (session/checkout statistics)
Machine	LastUserID	Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
Machine	MostFrequentUserID	Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
MachineUser	UserID	m:n relation between machines and users
RbacUser	UserID	User object for RBAC. Typically replicated from Active Directory.
SoftwareItemUser	UserID	M:n relation between SoftwareItem and User for items that are linked to specific users
SoftwarePackageUsageDetail	UserID	Consolidated usage information per software package per user per machine per day. Perform OctoSAM Inventory housekeeping to update this table from UsageDetail.
UalUserAccess	UserID	Holds Microsoft User Access Log user access data
UsageDetail	UserID	Holds detailed usage information as imported from octoscan scan files. This table should usually not be referenced directly by reports and queries. Use the consolidated SoftwarePackageUsageDetail table instead.
UserCloudProviderAccountLicensingPlan	UserID	User assigned account licensing plan relation Information
UserGroup	UserID	M:n relation between User and Group tables
UserMachineAffinity	UserID	Used to replicate User Device Affinity from other systems such as Microsoft SCCMf