SoftwareItemByLicenseManagerServer (System LicenseManagerServer Context)¶
Note
This query requires the LICENSE license option.
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 items connected to this license manager server.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Software Item ID | numeric | false | Internal ID for the SoftwareItem entity (Primary Key) |
| Software Item Guid | guid | false | Unique ID of the item, can be used for export/import or for the web UI. |
| Software Item Site Unique ID | string | false | A site defined unique id for each item. Must be unique if not empty. |
| Software Item | string | true | Name of the software item |
| Software Item Name | string | false | Name of the software Item |
| Software Item Version | string | false | Version of the software item |
| Active | bool | true | Mark the Item as active. Inactive items can be hidden from most lists. |
| Units | numeric | false | A universal field that can contain a number |
| Consumed Units | numeric | false | A universal field that can contain a number |
| Software Item Initial Cost | numeric | true | Initial Cost |
| Software Item Initial Cost Currency | string | true | |
| Software Item Recurring Cost | numeric | true | Recurring Cost |
| Software Item Recurring Cost Currency | string | true | |
| Software Item Owners | string | true | List of owners of the software item |
| Software Item Owners Principal Names | string | true | |
| Software Item Owners Mail Addresses | string | true | |
| Additional Info Link | string | true | Can contain a link to additional information |
| Description | string | false | Description of the item. Can be html formatted. |
| Notes | string | false | Remarks that are visible to all users that have read access to the item |
| Owner Notes | string | false | Remarks that can only be read by software package owners |
| Administrator Notes | string | false | Remarks that can only be read by a small group of users |
| Start Date | date | true | Start date of the software item |
| End Date | date | true | End date of the software item |
| Bestellnummer | string | true | No tooltip defined for annotation 'Bestellnummer' - this tooltip is shown only for DEBUG builds |
| Budgetierung_AIT | numeric | true | No tooltip defined for annotation 'Budgetierung_AIT' - this tooltip is shown only for DEBUG builds |
| Budgetierung_AIT Currency | string | false | |
| Cost_AFD | numeric | true | No tooltip defined for annotation 'Cost_AFD' - this tooltip is shown only for DEBUG builds |
| Cost_AFD Currency | string | false | |
| Cost_BIO | numeric | true | No tooltip defined for annotation 'Cost_BIO' - this tooltip is shown only for DEBUG builds |
| Cost_BIO Currency | string | false | |
| Cost_DIR | numeric | true | No tooltip defined for annotation 'Cost_DIR' - this tooltip is shown only for DEBUG builds |
| Cost_DIR Currency | string | false | |
| Cost_ENE | numeric | true | No tooltip defined for annotation 'Cost_ENE' - this tooltip is shown only for DEBUG builds |
| Cost_ENE Currency | string | false | |
| Cost_GFA | numeric | true | No tooltip defined for annotation 'Cost_GFA' - this tooltip is shown only for DEBUG builds |
| Cost_GFA Currency | string | false | |
| Cost_HR | numeric | true | No tooltip defined for annotation 'Cost_HR' - this tooltip is shown only for DEBUG builds |
| Cost_HR Currency | string | false | |
| Cost_LOG | numeric | true | No tooltip defined for annotation 'Cost_LOG' - this tooltip is shown only for DEBUG builds |
| Cost_LOG Currency | string | false | |
| Cost_NES | numeric | true | No tooltip defined for annotation 'Cost_NES' - this tooltip is shown only for DEBUG builds |
| Cost_NES Currency | string | false | |
| Cost_NUM | numeric | true | No tooltip defined for annotation 'Cost_NUM' - this tooltip is shown only for DEBUG builds |
| Cost_NUM Currency | string | false | |
| Cost_PSD | numeric | true | No tooltip defined for annotation 'Cost_PSD' - this tooltip is shown only for DEBUG builds |
| Cost_PSD Currency | string | false | |
| Cost_SCD | numeric | true | No tooltip defined for annotation 'Cost_SCD' - this tooltip is shown only for DEBUG builds |
| Cost_SCD Currency | string | false | |
| Cost_ZPT | numeric | true | No tooltip defined for annotation 'Cost_ZPT' - this tooltip is shown only for DEBUG builds |
| Cost_ZPT Currency | string | false | |
| Distributor | string | true | No tooltip defined for annotation 'Distributor' - this tooltip is shown only for DEBUG builds |
| Distributor Display Name | string | false | |
| F Inanzierung_AIT | numeric | true | No tooltip defined for annotation 'FInanzierung_AIT' - this tooltip is shown only for DEBUG builds |
| F Inanzierung_AIT Currency | string | false | |
| Licence Metric | string | true | No tooltip defined for annotation 'LicenceMetric' - this tooltip is shown only for DEBUG builds |
| Licence Metric Display Name | string | false | |
| OS_availibility | string | true | No tooltip defined for annotation 'OS_availibility' - this tooltip is shown only for DEBUG builds |
| OS_availibility Display Name | string | false | |
| Recharge | string | true | No tooltip defined for annotation 'Recharge' - this tooltip is shown only for DEBUG builds |
| Recharge Display Name | string | false | |
| Status | string | true | No tooltip defined for annotation 'Status' - this tooltip is shown only for DEBUG builds |
| Status Display Name | string | false | |
| Usage_Link | string | true | No tooltip defined for annotation 'Usage_Link' - this tooltip is shown only for DEBUG builds |
| License Manager Server Guid | guid | false | A unique ID that can be used to link to this object from external applications |
| License Manager Server | string | false | Name of the license manager server |
| Software Publisher | string | true | Normalized software publisher from the OctoSAM catalog |
| Software Publisher Guid | guid | false | OctoSAM internal Guid of this software publisher entity |
| Current Date | date | true | Date query was run. For reference if you use and save query results. |
| 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 | ccdd18be-d91a-4017-9fdd-da87ffb2b689 | 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 |