MachineSoftwareSignature¶
M:n relation between machines and software signatures
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 | |
| 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 | |
| ID | numeric | Internal ID for the MachineSoftwareSignature entity (Primary Key) |
| 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) |