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