SoftwarePackage¶
A software package defines a logical software entity. A software package can own 0 to n software signatures.
Fields¶
| Field | Type | Description |
|---|---|---|
| AlwaysCreatePackage | bit | If true, the package always gets created in the database regardless of installation status, |
| AnalysisExtras | xml | Holds additional analysis data, |
| AutoAssignEnabled | bit | Auto assign rules for new signatures enabled |
| AutoAssignNotes | nvarchar | Notes about quirks in the AutoAssign rules |
| AutoAssignRegex | nvarchar | A regular expression that is used to automatically assign new signatures to this software package |
| AutoAssignTestLikePattern | nvarchar | SQL LIKE and/or regular expression pattern used to select signatures for auto assign testing |
| AuxiliaryRegex | nvarchar | Reserved for future use |
| AuxiliaryTestLikePattern | nvarchar | Reserved for future use |
| Created | datetime2 | Date/Time package was created in the database |
| CreatedBy | nvarchar | User that created the package |
| CreatedGuid | uniqueidentifier | Reserved for future use |
| CustomerID | uniqueidentifier | A guid that indicates the customer for client specific packages |
| CustomField1 | nvarchar | Custom data not used by OctoSAM |
| CustomField2 | nvarchar | Custom data not used by OctoSAM |
| CustomField3 | nvarchar | Custom Data - not used by OctoSAM Inventory |
| CustomField4 | nvarchar | Custom Data - not used by OctoSAM Inventory |
| DeploymentAction | nchar | Used for deployment consolidation. Can be 'U' for Unknown, 'A' for Approved, 'R' for Replace with, or 'I' for Ignored. |
| DeploymentGroup | nvarchar | Can be used to assign security groups to machine objects in the directory. Some software deployment systems use this to determine what package to install on what machine (or for which user). |
| DeploymentReplacementSoftwarePackageID | bigint | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| EditionName | nvarchar | Reserved for future use |
| EditionPriority | int | Reserved for future use |
| ExtraData | nvarchar | Extra data for this object (JSON), |
| Guid | uniqueidentifier | GUID used for catalog updates. Stays the same for all OctoSAM defined software packages through the lifecycle of the package definition. Allows rename and delete of packages during catalog update.. Do not set if definig your own custom packages directly in the database. |
| HintHasSoftwareItems | bit | True if the software package is linked to at least one software item |
| HintSoftwarePackageUsageEndDate | datetime2 | Max consolidated usage date for this Package |
| HintSoftwarePackageUsageStartDate | datetime2 | Min consolidated usage date for this software package |
| ID | bigint | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| ID | bigint | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| IgnoreSignaturePublishers | bit | If set to true, OcoSAM Inventory does not try to find the package publisher based on signature publishers. |
| InstallationID | uniqueidentifier | Reserved for future use, |
| KeepDynamicMachineSignatureRelations | bit | Prevents automatic dynamic signature to machine reorg. Dynamic signatures (processes) to machine relations are cleared after 10 days if they are not in a software package with static signature relations to the same machine or this flag set. |
| LastModification | datetime2 | Date/Time of last write to this software package |
| LastModifiedBy | nvarchar | Client User that last modified this software package through the Octopus UI |
| LastSynchWithMaster | datetime2 | Date/Time time a software catalog update contained this package |
| LastUpdateFromMaster | datetime2 | Date/Time a software catalog update last updated this package |
| LifecycleDefinitionTypeID | bigint | Internal ID that references the LifecycleDefinitionType entity (Foreign Key) |
| LifecycleExtendedEndDate | datetime2 | For package specific software life cycle: extended support end date |
| LifecycleLongTermSupport | bit | for package specific software life cycle: true if a long term support release |
| LifecycleMainstreamEndDate | datetime2 | For package specific software life cycle: mainstream support end date |
| LifecycleNotes | nvarchar | Notes from the lifcycle definition for packages that have a package specific lifecycle definition, |
| LifecycleReleaseEndDate | datetime2 | Reserved for future use, |
| LifecycleReleaseStartDate | datetime2 | Reserved for future use, |
| LifecycleRetirementDate | datetime2 | Reserved for future use, |
| LifecycleStartDate | datetime2 | For package specific software life cycle: life cycle start date, |
| LifecycleSupportPolicy | nvarchar | For package specific software life cycle: contains a publisher specific life cycle policy name, |
| MasterLastModified | datetime2 | Date/Time master definition was updated. by Octosoft. |
| MasterLastModifiedBy | nvarchar | User that updated the softwrae catalog |
| MasterNotes | nvarchar | Package master catalog notes |
| MeteringEnabled | bit | True, if the software package definition supports package metering. |
| MeteringRegex | nvarchar | Reserved for future use |
| MeteringTestLikePattern | nvarchar | Reserved for future use |
| Name | nvarchar | Name of the software package |
| Notes | nvarchar | Custom notes |
| PredefinedByOctopus | bit | The package definition is maintained through OctoSAM master catalog updates |
| PredefinedSiteSpecific | bit | The package definition is maintained by Octosoft through OctoSAM site specific master catalog updates |
| Res1 | nvarchar | Reserved for internal use by future versions |
| Res2 | nvarchar | Reserved for internal use by future versions |
| 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, |
| SoftwareCategoryID | bigint | Internal ID that references the SoftwareCategory entity (Foreign Key) |
| SoftwareLicensingTypeID | bigint | Internal ID that references the SoftwareLicensingType entity (Foreign Key) |
| SoftwareProductVersionID | bigint | Reserved for future use |
| SoftwarePublisherID | bigint | Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| SwidTagMayRemainOnUninstall | bit | Set to true for software that routinely leaves the swid tag file behind on uninstall. Adobe is known for this behaviour. |
| SynchLastSynch | datetime2 | Date/Time of last synchronization of this software package with the partner CMDB. 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. Not used by OctoSAM Inventory. |