MachineSoftwarePackage¶
m:n relation between machines and software packages. This is mostly a redundant relation to speed up reports. A relation between machine and software package can also be found via software signature. There are exceptions where a signature does not define installation status of a package (for example left-over SWID tags).
Fields¶
| Field | Type | Description |
|---|---|---|
| AnalysisExtras | xml | Holds additional analysis data |
| Created | datetime | Date/Time this relation was created in the database |
| CreatedGUID | guid | GUID of the scan that created this relation |
| CustomField1 | string | Custom field available for site-specific per installation data, Not used by OctoSAM logic |
| CustomField2 | string | Custom field available for site-specific per installation data, Not used by OctoSAM logic |
| CustomField3 | string | Custom field available for site-specific per installation data, Not used by OctoSAM logic |
| CustomField4 | string | Custom field available for site-specific per installation data, Not used by OctoSAM logic |
| ExtraData | string | Extra data collected for documentation of this machine to signature relation |
| Features | string | Installation specific feature information |
| FirstScan | date | Date/Time this machine to software package relation was first detected |
| Guid | guid | A unique id of this relation record |
| HintBaseVersion | string | Consolidated BaseVersion of all signatures for this installation, if the individual BaseVersion fields of the signatures follow SemVer or another standard supported by OctoSAM. |
| HintKeyLastWriteTime | datetime | Newest write to any of the signatures for this installation for registry key based signatures |
| HintLicensingRelevant | boolean | For software packages with licensing type multiple, this indicates that at least one installed signature has the LicensingRelevant flag set. |
| HintReleaseType | string | Most critical release type for this package installation. This is package-specific. For example for Oracle Java SE this may contain 'BPR' for licensing relevant BPR builds. |
| ID | numeric | Internal ID for the MachineSoftwarePackage entity (Primary Key) |
| ID | numeric | Internal ID for the MachineSoftwarePackage entity (Primary Key) |
| InstallationApproved | boolean | Installation of this package on this machine is approved |
| InstallationApprovedChanged | datetime | Date/Time the approval flag was last changed |
| InstallationApprovedChangedBy | string | User that last changed the approval flag |
| InstallDate | datetime | Max value of all installed signature InstallDate if available. Not all packages provide an install date. |
| LastDiscovered | datetime | Date/Time the software package to machine relation was last discovered from scan results |
| LastLifecycleLookup | datetime | Date/Time a life-cycle look-up was last performed on this relation |
| LastLifecycleLookupResult | string | A status comment generated by the last life-cycle look-up on this relation |
| LastModification | datetime | Date/Time this machine to software package relation was last encountered in a scan, or update time due to updates to packages and signatures. |
| LastUsage | date | Date/Time the software package was last used on the machine. Redundant information to SoftwarePackageUsageDetail provided for easier querying and performance. |
| LifecycleDefinitionTypeID | numeric | Internal ID that references the LifecycleDefinitionType entity (Foreign Key) |
| LifecycleExtendedEndDate | datetime | End of extended support date |
| LifecycleLongTermSupport | boolean | True if the installed release has long term support by the publisher |
| LifecycleMainstreamEndDate | datetime | End of mainstream support date |
| LifecycleReleaseEndDate | datetime | Release end date |
| LifecycleReleaseStartDate | datetime | Release start date |
| LifecycleRetirementDate | datetime | Product retirement date |
| LifecycleStartDate | datetime | Start of software lifecycle |
| LifecycleSupportPolicy | string | Software Publisher specific lifecycle policy name |
| MachineID | numeric | Internal ID that references the Machine entity (Foreign Key) |
| Notes | string | Site-specific per installation notes, Not used by OctoSAM logic |
| ServiceNowLastExport | datetime | Date/Time of last export to ServiceNow |
| ServiceNowLastImport | datetime | Date/Time of last import from ServiceNow |
| ServiceNowSysID | guid | Service Now: sys_id of replicated object |
| SoftwarePackageID | numeric | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| SynchLastSynch | datetime | Timestamp of last synchronization of this machine software package relation with the partner CMDB. Currently not used by OctoSAM Inventory. |
| SynchTokenID | string | Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Currently not used by OctoSAM Inventory. |