Skip to content

MachineUser

m:n relation between machines and users.

erDiagram
    Machine ||--o{ MachineUser : "MachineID"
    User ||--o{ MachineUser : "UserID"
    MachineUser ||--o{ MachineUserAutoStart : "MachineUserID"
    MachineUser ||--o{ MachineUserBrowserExtension : "MachineUserID"
    MachineUser ||--o{ MachineUserEnvironment : "MachineUserID"
    MachineUser ||--o{ MachineUserHistory : "MachineUserID"
    MachineUser ||--o{ MachineUserMUICache : "MachineUserID"
    MachineUser ||--o{ MachineUserOfficeAddIn : "MachineUserID"
    MachineUser ||--o{ MachineUserSecurityGroup : "MachineUserID"
    MachineUser ||--o{ MachineUserSoftwareSignature : "MachineUserID"

Fields

Field Type Description
AnalysisExtras xml Holds additional analysis data
Created datetime Date/Time this object was created in the database
CreatedGUID guid GUID of the scan that created this relation in the database
ID numeric Internal ID for the MachineUser entity (Primary Key)
LastModification datetime Date/Time of last write to this relation
LastScan datetime Date/Time of last scan that updated this relation
LastScanGUID guid GUID of the scan that last updated this relation
LastScannerTag string Command-line tag that was specified on the last scan of this machine to user relation
LocalAdministrator boolean True if the referenced user is member of the referenced machine's Administrators group
MachineID numeric Internal ID that references the Machine entity (Foreign Key)
RemoteSession boolean True if scan was during a remote session
ScannedAsAdministrator boolean True if the scan that last scanned this relation was run with administrative privileges
SynchLastSynch datetime Timestamp of last synchronization of this machine user relation with the partner CMDB. Currently 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. Currently not used by OctoSAM Inventory.
UserID numeric Internal ID that references the User entity (Foreign Key)

References

Column Name Referenced Table Description
MachineID 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.
UserID User Basic user Information

Referenced by

Table Column Name Description
MachineUserAutoStart MachineUserID User and Machine specific auto start configuration
MachineUserBrowserExtension MachineUserID Holds information about installed chromium browsers
MachineUserEnvironment MachineUserID Environment variable scanned for machine in user context
MachineUserHistory MachineUserID User logon history information
MachineUserMUICache MachineUserID Windows MUI cache information
MachineUserOfficeAddIn MachineUserID Information about Office Add-Ins installed for a specific user on a specific machine
MachineUserSecurityGroup MachineUserID Reserved for use in future versions of OctoSAM Inventory
MachineUserSoftwareSignature MachineUserID M:n relation between MachineUser and SoftwareSignature for per user signatures