MachineSoftwareSignature

M:n relation between machines and software signatures.

erDiagram
    InformationSource ||--o{ MachineSoftwareSignature : "InformationSourceID"
    Machine ||--o{ MachineSoftwareSignature : "MachineID"
    SoftwareRepackager ||--o{ MachineSoftwareSignature : "SoftwareRepackagerID"
    SoftwareSignature ||--o{ MachineSoftwareSignature : "SoftwareSignatureID"
    MachineSoftwareSignature ||--o{ MachineSoftwareSignatureInstance : "MachineSoftwareSignatureID"
    MachineSoftwareSignature ||--o{ SwidDocument : "MachineSoftwareSignatureID"

Fields

Field	Type	Description
AnalysisExtras	xml	Holds additional analysis data
Created	datetime	Date/Time this relation was created in the database
CreatedGUID	guid	Scan GUID that created this object
CustomField1	string	Available for custom data for this installation not used by OctoSAM Inventory
CustomField2	string	Available for custom data for this installation not used by OctoSAM Inventory
CustomField3	string	Available for custom data for this installation not used by OctoSAM Inventory
CustomField4	string	Available for custom data for this installation not used by OctoSAM Inventory
EmbeddedPlistInfo	string	Plist information embedded in MacOS application executables
ExtraData	string	Extra data collected for documentation of this machine to signature relation
Features	string	Installation specific feature information
FileHash	string	A hash calculated over the contents of a file if the signature is file based. Not all scan scenarios calculate a hash.
FileLastWriteTime	datetime	For file-based signatures contains the last modification date of the file
FirstScan	datetime	Date/Time of the scan that created this entity. Note that this differs from Created column in case of re-import of old .scan files.
FolderLastWriteTime	datetime	For file-based signatures contains the last modification date of the parent folder of the file
Guid	guid	Unique id of this relation record
ID	numeric	Internal ID for the MachineSoftwareSignature entity (Primary Key)
InformationSourceID	numeric	Internal ID that references the InformationSource entity (Foreign Key)
InstallationApproved	boolean	Installation of this signature on this machine is approved
InstallationApprovedChanged	datetime	Date/Time the installation approval flag was last changed
InstallationApprovedChangedBy	string	User that last changed the approval flag
InstallDate	datetime	Date/Time of installation if available. Not all packages provide an install date.
InstallLocation	string	The location where a software package is installed on the system - if available
InstallSource	string	The source location of the installation package. For windows installer packages the path to the .msi file that was used for the installation.
KeyLastWriteTime	datetime	For registry based signatures, Date/Time the registry key was last written. Note that not only installations may write the registry keys. Typically, windows feature updates will reset this date.
LastModification	datetime	Date/Time this machine to software signature was last updated
LastScan	datetime	Date/Time of last scan that updated this software signature to machine relation
LastScanGUID	guid	GUID of the scan that last updated this relation
LastUsage	datetime	For metering signatures, date/time of last detected usage. Redundant to information in table UsageDetail, provided for easier querying and performance.
MachineID	numeric	Internal ID that references the Machine entity (Foreign Key)
Notes	string	Installation notes
ReleaseInfo	string	Contains information found in a release file
ReleaseInfoPath	string	For signatures that point to a product that have a release file: contains the path of the release file
Res1	string	Reserved for future use
Res2	string	Reserved for future use
SoftwareRepackagerID	numeric	Internal ID that references the SoftwareRepackager entity (Foreign Key)
SoftwareRepackagerInfo	string	Repackager Info for supported Repackagers
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
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.
SoftwareRepackagerID	SoftwareRepackager	Detected software repackagers. Relies on the Import Service detecting special signatures that software repackagers add to the install.
SoftwareSignatureID	SoftwareSignature	A software signature is a unique pattern detected by software scan, like a fingerprint that a particular software leaves on machines.

Referenced by

Table	Column Name	Description
MachineSoftwareSignatureInstance	MachineSoftwareSignatureID	If several instances of MachineSoftwareSignature can be found for the same signature (for example, process started multiple times), this table holds per-instance information.
SwidDocument	MachineSoftwareSignatureID	Used to hold scanned SWID Tag XML documents