MachineUserSoftwareSignature¶
M:n relation between MachineUser and SoftwareSignature for per user signatures.
Fields¶
| Field | Type | Description |
|---|---|---|
| AnalysisExtras | xml | Holds additional analysis data |
| Created | datetime | Date/Time this relation was created in the database |
| FirstScan | datetime | Date/Time of the scan that created this relation |
| ID | numeric | Internal ID for the MachineUserSoftwareSignature entity (Primary Key) |
| InformationSourceID | numeric | Internal ID that references the InformationSource entity (Foreign Key) |
| InstallDate | datetime | Date/Time of installation (if available) |
| KeyLastWriteTime | datetime | Date/Time the Registry for this signature was last updated |
| LastModification | datetime | Date/Time of last write to this entity |
| LastScan | datetime | Date/Time of the last scan that updated this relation |
| LastScanGUID | guid | GUID of the scan that created this relation |
| LastUsage | datetime | For Metering signatures, date/time of last detected usage. Redundant to information in UsageDetail, provided for ease of querying and performance. |
| MachineUserID | numeric | Internal ID that references the MachineUser entity (Foreign Key) |
| ScanHint | string | Additional information from the scanner for this machine to signature relation |
| SoftwareSignatureID | numeric | Internal ID that references the SoftwareSignature entity (Foreign Key) |