Skip to content

MachineSoftwareSignature

M:n relation between machines and software signatures.

Fields

Field Type Description
AnalysisExtras xml Holds additional analysis data
Created datetime2 Date/Time this relation was created in the database
CreatedGUID uniqueidentifier Scan GUID that created this object
CustomField1 nvarchar Available for custom data for this installation not used by OctoSAM Inventory
CustomField2 nvarchar Available for custom data for this installation not used by OctoSAM Inventory
CustomField3 nvarchar Available for custom data for this installation not used by OctoSAM Inventory
CustomField4 nvarchar Available for custom data for this installation not used by OctoSAM Inventory
ExtraData nvarchar Extra data collected for documentation of this machine to signature relation
Features nvarchar Installation specific feature information
FileHash nvarchar A hash calculated over the contents of a file if the signature is file based. Not all scan scenarios calculate a hash.
FileLastWriteTime datetime2 For file-based signatures contains the last modification date of the file
FirstScan datetime2 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 datetime2 For file-based signatures contains the last modification date of the parent folder of the file
Guid uniqueidentifier
ID bigint Internal ID for the MachineSoftwareSignature entity (Primary Key)
ID bigint Internal ID for the MachineSoftwareSignature entity (Primary Key)
InformationSourceID bigint Internal ID that references the InformationSource entity (Foreign Key)
InstallationApproved bit Installation of this signature on this machine is approved
InstallationApprovedChanged datetime2 Data/Time the installation approval flag was last changed
InstallationApprovedChangedBy nvarchar User that last changed the approval flag
InstallDate datetime2 Date/Time of installation if available. Not all packages provide an install date.
InstallLocation nvarchar The location where a software package is installed on the system - if available
InstallSource nvarchar The source location of the installation package. For windows installer packages the path to the .msi file that was used for the installation.
KeyLastWriteTime datetime2 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 datetime2 Date/Time this machine to software signature was last updated
LastScan datetime2 Date/Time of last scan that updated this software signature to machine relation
LastScanGUID uniqueidentifier GUID of the scan that last updated this relation
LastUsage datetime2 For metering signatures, date/time of last detected usage. Redundant to information in table UsageDetail, provided for easier querying and performance.
MachineID bigint Internal ID that references the Machine entity (Foreign Key)
MachineID bigint Internal ID that references the Machine entity (Foreign Key)
Notes nvarchar Installation notes
ReleaseInfo nvarchar Contains information fund in a release file
ReleaseInfoPath nvarchar For signatures that point to a product that have a release file: contains the path of the release file
Res1 nvarchar Reserved for future use
Res2 nvarchar Reserved for future use
SoftwareRepackagerID bigint Internal ID that references the SoftwareRepackager entity (Foreign Key)
SoftwareRepackagerInfo nvarchar Repackager Info for supported Repackagers
SoftwareSignatureID bigint Internal ID that references the SoftwareSignature entity (Foreign Key)
SoftwareSignatureID bigint Internal ID that references the SoftwareSignature entity (Foreign Key)