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)