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 |