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 | datetime2 | Date/Time this relation was created in the database |
| CreatedGUID | uniqueidentifier | GUID of the scan that created this relation |
| CustomField1 | nvarchar | Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| CustomField2 | nvarchar | Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| CustomField3 | nvarchar | Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| CustomField4 | nvarchar | Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| ExtraData | nvarchar | Extra data collected for documentation of this machine to signature relation |
| Features | nvarchar | Installation specific feature information |
| FirstScan | date | Date/Time this machine to software package relation was first detected |
| Guid | uniqueidentifier | A unique id of this relation record |
| HintBaseVersion | nvarchar | 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 | datetime2 | Newest write to any of the signatures for this installation for registry key based signatures |
| HintLicensingRelevant | bit | For software packages with licensing type multiple, this indicates that at least one installed signature has the LicensingRelevant flag set. |
| HintReleaseType | nvarchar | 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 | bigint | Internal ID for the MachineSoftwarePackage entity (Primary Key) |
| ID | bigint | Internal ID for the MachineSoftwarePackage entity (Primary Key) |
| InstallationApproved | bit | Installation of this package on this machine is approved |
| InstallationApprovedChanged | datetime2 | Date/Time the approval flag was last changed |
| InstallationApprovedChangedBy | nvarchar | User that last changed the approval flag |
| InstallDate | datetime2 | Max value of all installed signature InstallDate if available. Not all packages provide an install date. |
| LastDiscovered | datetime2 | Date/Time the software package to machine relation was last discovered from scan results |
| LastLifecycleLookup | datetime2 | Date/Time a life-cycle look-up was last performed on this relation |
| LastLifecycleLookupResult | nvarchar | A status comment generated by the last life-cycle look-up on this relation |
| LastModification | datetime2 | 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 | bigint | Internal ID that references the LifecycleDefinitionType entity (Foreign Key) |
| LifecycleExtendedEndDate | datetime2 | End of extended support date |
| LifecycleLongTermSupport | bit | True if the installed release has long term support by the publisher |
| LifecycleMainstreamEndDate | datetime2 | End of mainstream support date |
| LifecycleReleaseEndDate | datetime2 | Release end date |
| LifecycleReleaseStartDate | datetime2 | Release start date |
| LifecycleRetirementDate | datetime2 | Product retirement date |
| LifecycleStartDate | datetime2 | Start of software lifecycle |
| LifecycleSupportPolicy | nvarchar | Software Publisher specific lifecycle policy name |
| MachineID | bigint | Internal ID that references the Machine entity (Foreign Key) |
| MachineID | bigint | Internal ID that references the Machine entity (Foreign Key) |
| Notes | nvarchar | Site-specific per installation notes, Not used by OctoSAM logic. |
| ServiceNowLastExport | datetime2 | Date/Time of last export to ServiceNow |
| ServiceNowLastImport | datetime2 | Date/Time of last import from ServiceNow |
| ServiceNowSysID | uniqueidentifier | Service Now: sys_id of replicated object |
| SoftwarePackageID | bigint | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| SoftwarePackageID | bigint | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| SynchLastSynch | datetime2 | Timestamp of last synchoronization of this machine software package relation with the partner CMDB. Currently not used by OctoSAM Inventory. |
| SynchTokenID | nvarchar | 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. |