MachineUserSoftwareSignature

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

erDiagram
    InformationSource ||--o{ MachineUserSoftwareSignature : "InformationSourceID"
    MachineUser ||--o{ MachineUserSoftwareSignature : "MachineUserID"
    SoftwareSignature ||--o{ MachineUserSoftwareSignature : "SoftwareSignatureID"

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)

References

Column Name	Referenced Table	Description
InformationSourceID	InformationSource	Defines different information sources in the case that different scanners update information for the same machine
MachineUserID	MachineUser	m:n relation between machines and users
SoftwareSignatureID	SoftwareSignature	A software signature is a unique pattern detected by software scan, like a fingerprint that a particular software leaves on machines.