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) |