MachineUserSoftwareSignature

M:n relation between MachineUser and SoftwareSignature for per user signatures.

Fields

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