Skip to content

SoftwarePackagesIndex (System)

OctoSAM System Query

This query is an integral part of the OctoSAM application. OctoSAM starts the query to display tabular data within the application. The query can only be started from within the intended application system context.

List normailzed software packages.

Fields

Name Type Visible Description
Software Package ID numeric false Internal ID that references the SoftwarePackage entity (Foreign Key)
Software Package Guid guid false 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 Category ID numeric false Internal ID that references the SoftwareCategory entity (Foreign Key)
Software Category string true Name of the software category
Software Category Description string false Description
Junk bool false Flag to signal a category as junk. junk categories can be ignored on some reports and queries.
Software Package string true Name of the software package
Custom Field1 string false Custom data not used by OctoSAM
Custom Field2 string false Custom data not used by OctoSAM
Custom Field3 string false Custom Data - not used by OctoSAM Inventory
Custom Field4 string false Custom Data - not used by OctoSAM Inventory
Metering Enabled bool false True, if the software package definition supports package metering.
Predefined By Octopus bool false The package definition is maintained through OctoSAM master catalog updates
Predefined Site Specific bool false The package definition is maintained by Octosoft through OctoSAM site specific master catalog updates
Software Publisher ID numeric false Internal ID that references the SoftwarePublisher entity (Foreign Key)
Software Publisher string true Software publisher's name
Software Publisher Guid guid false Unique identifier for objects that are synchronized with the master catalog
Software Publisher Url string false Link to the Website
Software Licensing Type string true Name
Licensing Relevant bool true True for commercial licensing types
Machines numeric true Number of machines the software package is installed on
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 d3ebc930-d5e7-45d7-a763-c2978a6bc00a The internal id of the query. Must be unique
SupportsDesktop true If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb true If true, the query can be started from the OctoSAM Web UI