Item owner details¶
Note
This query requires the LICENSE license option.
Show software item owners and their owned items.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Owner Rbac User ID | numeric | false | OctoSAM internal ID of the software item owner |
| Owner Name | string | true | Name of a software item owner |
| Owner | string | true | Owner of a Software Item. |
| Owner Mail Address | string | true | Mail Address of a Software Item owner |
| Owner User ID | numeric | false | OctoSAM internal ID of inventoried user object that corresponds to the software item owner |
| Owner User Directory Guid | guid | false | Active Directory Guid of the software item owner if replicated from Active Directory |
| 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 | 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 |
| Software Item Site Unique ID | string | false | A site defined unique id for each item. Must be unique if not empty. |
| Active | bool | true | Mark the Item as active. Inactive items can be hidden from most lists. |
| Description | string | false | Description of the item. Can be html formatted. |
| Additional Info Link | string | false | Can contain a link to additional information |
| Start Date | date | false | 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 |
| Software Publisher ID | numeric | false | Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Category ID | numeric | false | OctoSAM internal ID of this Software Category entity |
| 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 ID | numeric | false | OctoSAM internal ID of this software package entity |
| 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 | string | true | Software package name from the OctoSAM software catalog |
| Metering Enabled | bool | false | True, if the software package definition supports package metering. |
| Software Licensing Type ID | numeric | false | OctoSAM internal ID for licensing type |
| Software Licensing Type | string | true | Licensing type for this package as defined in the OctoSAM Inventory software catalog |
| Licensing Relevant | bool | true | True if the package or licensing type is considered relevant for licensing |
| 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 | false | 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 | 75170099-46f6-4947-b8e3-4ce96757dee8 | 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 |