Skip to content

SoftwarePackage (Internal)

OctoSAM Internal Query

Internal queries are advanced queries for analysis of the inner workings of the OctoSAM application. These queries are geared towards administrators with an in-depth knowledge of OctoSAM.

All rows and columns from the SoftwarePackage table.

Fields

Name Type Visible Description
ID numeric true OctoSAM internal ID of this entity
Name string true Name of the software package
Notes string true Custom notes
Software Category ID numeric true OctoSAM internal ID of this Software Category entity
Software Publisher ID numeric true OctoSAM internal ID of this software publisher entity
Last Modification date true Date/Time this entity was last updated. In most cases, this is the time of the last import. In case of re-import of older scan files, LastModification can differ significantly from LastScan.
Deployment Group string true 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).
Metering Enabled bool true True, if the software package definition supports package metering.
Custom Field1 string true Custom data not used by OctoSAM
Custom Field2 string true Custom data not used by OctoSAM
Predefined By Octopus bool true The package definition is maintained through OctoSAM master catalog updates
Predefined Site Specific bool true The package definition is maintained by Octosoft through OctoSAM site specific master catalog updates
Custom Field3 string true Custom Data - not used by OctoSAM Inventory
Custom Field4 string true Custom Data - not used by OctoSAM Inventory
Synch Token ID string true 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.
Synch Last Synch date true Date/Time of last synchronization of this software package with the partner CMDB. Not used by OctoSAM Inventory.
Auto Assign Enabled bool true Auto assign rules for new signatures enabled
Auto Assign Regex string true A regular expression that is used to automatically assign new signatures to this software package
Auto Assign Test Like Pattern string true SQL LIKE and/or regular expression pattern used to select signatures for auto assign testing
Last Modified By string true Client User that last modified this software package through the Octopus UI
Deployment Action string true Used for deployment consolidation. Can be 'U' for Unknown, 'A' for Approved, 'R' for Replace with, or 'I' for Ignored.
Deployment Replacement Software Package ID numeric true Internal ID that references the SoftwarePackage entity (Foreign Key)
Res1 string true Reserved for internal use by future versions
Res2 string true Reserved for internal use by future versions
Created date true Date/Time this entity was created
Created By string true User that created the package
Created Guid guid true Reserved for future use
Keep Dynamic Machine Signature Relations bool true 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.
Guid guid true 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.
Software Licensing Type ID numeric true OctoSAM internal ID for licensing type
Last Update From Master date true Date/Time a software catalog update last updated this package
Last Synch With Master date true Date/Time time a software catalog update contained this package
Master Last Modified date true Date/Time master definition was updated. by Octosoft.
Master Last Modified By string true User that updated the softwrae catalog
Master Notes string true Package master catalog notes
Auto Assign Notes string true Notes about quirks in the AutoAssign rules
Swid Tag May Remain On Uninstall bool true Set to true for software that routinely leaves the swid tag file behind on uninstall. Adobe is known for this behaviour.
Ignore Signature Publishers bool true If set to true, OcoSAM Inventory does not try to find the package publisher based on signature publishers.
Metering Regex string true Reserved for future use
Metering Test Like Pattern string true Reserved for future use
Auxiliary Regex string true Reserved for future use
Auxiliary Test Like Pattern string true Reserved for future use
Software Product Version ID numeric true Reserved for future use
Edition Name string true Reserved for future use
Edition Priority numeric true Reserved for future use
Hint Software Package Usage Start Date date true Min consolidated usage date for this software package
Hint Software Package Usage End Date date true Max consolidated usage date for this Package
Hint Has Software Items bool true True if the software package is linked to at least one software item
Customer ID guid true A guid that indicates the customer for client specific packages
Installation ID guid true Reserved for future use,
Analysis Extras string true Holds additional analysis data,
Service Now Sys ID guid true Service Now: sys_id of replicated object,
Service Now Last Export date true Date/Time of last export to ServiceNow,
Service Now Last Import date true Date/Time of last import from ServiceNow,
Extra Data string true Extra data for this object (JSON)
Lifecycle Support Policy string true For package specific software life cycle: contains a publisher specific life cycle policy name,
Lifecycle Start Date date true For package specific software life cycle: life cycle start date,
Lifecycle Mainstream End Date date true For package specific software life cycle: mainstream support end date
Lifecycle Extended End Date date true For package specific software life cycle: extended support end date
Lifecycle Retirement Date date true Reserved for future use,
Lifecycle Release Start Date date true Reserved for future use,
Lifecycle Release End Date date true Reserved for future use,
Lifecycle Long Term Support bool true For package specific software life cycle: true if a long term support release
Lifecycle Definition Type ID numeric true OctoSAM internal ID of this software lifecycle definition
Lifecycle Notes string true Notes from the lifcycle definition for packages that have a package specific lifecycle definition,
Always Create Package bool true If true, the package always gets created in the database regardless of installation status,
Current Date Time date false Date and time the query was run. For reference if you use and save query results.

Main entities referenced from this query

Query information

Property Value Description
Query Guid fac2b7b2-5a08-439b-a3a7-918a234cbe32 The internal id of the query. Must be unique
SupportsDesktop true If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb false If true, the query can be started from the OctoSAM Web UI