Organization installation overview

Show software package and installation statistics.

Fields

Name	Type	Visible	Description
Software Category	string	true	Software category name form the OctoSAM software catalog
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 Package	string	true	Software package name from the OctoSAM software catalog
Organization ID	numeric	false	OctoSAM internal ID of this Organization entity
Organization	string	true	Name of the organization this entity is mapped to
Organization Description	string	false	Description for the organization this entity is mapped to
Installed	numeric	true	Number of installations of this software package in this organization
Total Machines	numeric	true	Total Number of machines in this Organization
Ratio	numeric	true	Ratio between installations and total machines for this organization
Licensing Relevant	bool	true	True if the package or licensing type is considered relevant for licensing
Auto Assign Enabled	bool	false	Auto assign rules for new signatures enabled
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
Auto Assign Regex	string	false	A regular expression that is used to automatically assign new signatures to this software package
Metering Enabled	bool	false	True, if the software package definition supports package metering.
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
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

• SoftwarePackage

Query information

Property	Value	Description
Query Guid	8ec217b0-e40f-11dd-ad8b-0800200c9a66	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