UserMachineAffinity
Used to replicate User Device Affinity from other systems such as Microsoft SCCMf.
erDiagram
Machine ||--o{ UserMachineAffinity : "MachineID"
User ||--o{ UserMachineAffinity : "UserID"
UserMachineAffinityProvider ||--o{ UserMachineAffinity : "UserMachineAffinityProviderID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this affinity relation was created |
| ID |
numeric |
Internal ID for the UserMachineAffinity entity (Primary Key) |
| LastScan |
datetime |
Date/Time this affinity relation was last scanned |
| MachineID |
numeric |
Internal ID that references the Machine entity (Foreign Key) |
| UserID |
numeric |
Internal ID that references the User entity (Foreign Key) |
| UserMachineAffinityProviderID |
numeric |
Internal ID that references the UserMachineAffinityProvider 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 |
| UserMachineAffinityProviderID |
UserMachineAffinityProvider |
Holds information about different Providers of user device affinity information |