Enterprise metering overview¶
License restriction
This query requires the following license options: +METERING,+LICENSE
Show usage of packages associated with software items.
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 Initial Cost Currency1 | string | true | |
| Software Item Owners | string | true | List of owners of the software item |
| Additional Info Link | string | true | Can contain a link to additional information |
| Description | string | true | 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' - please specify a tooltip together with the annotation. |
| Budgetierung_AIT | numeric | true | No tooltip defined for annotation 'Budgetierung_AIT' - please specify a tooltip together with the annotation. |
| Budgetierung_AIT Currency | string | false | |
| Distributor | string | true | No tooltip defined for annotation 'Distributor' - please specify a tooltip together with the annotation. |
| Distributor Display Name | string | false | |
| F Inanzierung_AIT | numeric | true | No tooltip defined for annotation 'FInanzierung_AIT' - please specify a tooltip together with the annotation. |
| F Inanzierung_AIT Currency | string | false | |
| Licence Metric | string | true | No tooltip defined for annotation 'LicenceMetric' - please specify a tooltip together with the annotation. |
| Licence Metric Display Name | string | false | |
| License Details | string | true | No tooltip defined for annotation 'LicenseDetails' - please specify a tooltip together with the annotation. |
| OS_availibility | string | true | No tooltip defined for annotation 'OS_availibility' - please specify a tooltip together with the annotation. |
| OS_availibility Display Name | string | false | |
| Recharge | string | true | No tooltip defined for annotation 'Recharge' - please specify a tooltip together with the annotation. |
| Recharge Display Name | string | false | |
| Status | string | true | No tooltip defined for annotation 'Status' - please specify a tooltip together with the annotation. |
| Status Display Name | string | false | |
| Usage_Link | string | true | No tooltip defined for annotation 'Usage_Link' - please specify a tooltip together with the annotation. |
| Software Category ID | numeric | false | Internal ID that references the SoftwareCategory entity (Foreign Key) |
| Software Category Sort Order | numeric | false | OctoSAM internal code to support software category sorting regardless of name |
| Software Category | string | true | Software category name form the OctoSAM software catalog |
| Software Package | string | true | Software package name from the OctoSAM software catalog |
| 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 Package Last Modification | date | false | Date/Time of last write to this software package |
| Software Package Created | date | false | Date/Time package was created in the database |
| Metering Enabled | bool | true | True, if the software package definition supports package metering. |
| Software Publisher | string | true | Normalized software publisher from the OctoSAM catalog |
| Licensing Relevant | bool | true | True if the package or licensing type is considered relevant for licensing |
| Installed | numeric | true | Number of package installations for the selected organizations |
| Used | numeric | true | Number of packages with scanned usage within the selected timespan and the selected organizations |
| Unused | numeric | true | Number of installations with no scanned usage within the selected timeframe and organizations |
| Ratio | numeric | true | Ratio between Installed and Used |
| Software Publisher ID | numeric | false | Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Publisher Guid | guid | false | OctoSAM internal Guid of this software publisher entity |
| Software Package ID | numeric | false | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| 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 | 802aa67e-01b2-4bd6-88c4-a4bb5d5cf0c6 | 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 |