All software items V2 (Internal Incubating)

License restriction

This query requires the LICENSE license option.

OctoSAM incubating internal query

Incubating queries have beta status. They might be experimental. These queries are not yet fully tested and may change in the future. Once tested and matured, these queries may get moved to the regular query tree. Consult with Octosoft if and when to use this query.

Show all software items. V2

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	string	true	Name of this item for reports and queries
Name	string	false	Name of the software Item
Version	string	false	Version of the software item
Site Unique ID	string	false	A site defined unique id for each item. Must be unique if not empty.
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
Active	bool	false	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
Remaining Units	numeric	false
Consumed Units Ratio	numeric	false
Initial Cost	numeric	false	Initial Cost
Initial Cost Currency	string	false
Recurring Cost	numeric	false	Recurring Cost
Recurring Cost Currency	string	false
Software Item Owners	string	false	List of owners of the software item
Software Item Owners Principal Names	string	false
Software Item Owners Mail Addresses	string	false
Additional Info Link	string	false	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
Administrator Notes	string	false	Remarks that can only be read by a small group of users
Owner Notes	string	false	Remarks that can only be read by software package owners
Start Date	date	false	Start date of the software item
End Date	date	false	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	OctoSAM internal ID of this Software Category entity
Sort Order	numeric	false
Software Category	string	false	Software category name form the OctoSAM software catalog
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.
Licensing Relevant	bool	false	True if the package or licensing type is considered relevant for licensing
Software Package ID	numeric	false	Internal ID that references the SoftwarePackage entity (Foreign Key)
Installations	numeric	true
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 defining your own custom packages directly in the database.
License Manager Server	string	true	Name of the license manager server
License Manager Server ID	numeric	false	OctoSAM internal ID of the license manager server
License Manager Server Guid	guid	false	OctoSAM internal Guid of this license manager server
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

• SoftwareItem

• SoftwarePackage

Query information

Property	Value	Description
Query Guid	8f41669f-70fb-4fed-a350-6024d74c50a6	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