InstalledSoftware (System Machine Context)¶
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.
Show software installed on this machine.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Machine ID | numeric | false | OctoSAM internal ID of this Machine entity |
| Machine Guid | guid | false | OctoSAM internal Guid of this Machine entity |
| Machine | string | false | Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| 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 | true | Link to the Website |
| Software Licensing Type | string | true | Name |
| Licensing Relevant | bool | true | True for commercial licensing types |
| Install Date | date | true | Date this software package got installed. Depending on the installer used this date may not be available. |
| Installation Custom Field1 | string | false | Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field2 | string | false | Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field3 | string | false | Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field4 | string | false | Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Licensing Relevant | bool | false | This particular installation is licensing relevant. For Java packages this means that an Oracle licence is required |
| Installation Approved | bool | false | |
| Installation Approved Changed | date | false | |
| Installation Approved Changed By | string | false | |
| 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 | 7b548c1b-2ea6-4b9a-9fb4-42ae02af2fb5 | 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 |