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

erDiagram
    LifecycleDefinitionType ||--o{ MachineSoftwarePackage : "LifecycleDefinitionTypeID"
    Machine ||--o{ MachineSoftwarePackage : "MachineID"
    SoftwarePackage ||--o{ MachineSoftwarePackage : "SoftwarePackageID"

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	ServiceNow: 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.

References

Column Name	Referenced Table	Description
LifecycleDefinitionTypeID	LifecycleDefinitionType	Lookup table for lifecycle definition types
MachineID	Machine	Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
SoftwarePackageID	SoftwarePackage	A software package defines a logical software entity. A software package can own 0 to n software signatures.