Skip to content

MachineUser

m:n relation between machines and users

Fields

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