MachinesBySoftwareItem (System SoftwareItem Context)

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.

Shows all machines where software related to a software item ist installed.

Fields

Name	Type	Visible	Description
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 Name	string	true	Software package name from the OctoSAM 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
Version Licensing Relevant	bool	true
Base Version	string	false	Signature version determined by per-product logic within OctoSAM for signatures where uniform versioning has a speical relevance such as Java
Machine ID	numeric	false	OctoSAM internal ID of this Machine entity
Machine Guid	guid	false	OctoSAM internal Guid of this Machine entity
Machine	string	true	Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines
Machine Name	string	false	Name of this machine
Domain Name	string	false	NETBIOS Domain name
Virtual Machine	bool	true
Raw Manufacturer	string	false	Manufacturer string as scanned from the system. See field 'Manufacturer' for normalized manufacturer
Manufacturer ID	numeric	false	OctoSAM internal ID of the machine manufacturer
Manufacturer	string	false	Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information
Model	string	false
Deleted In Directory	bool	false
Deleted In Directory First Detected	date	false
Directory Path	string	false	Path to this user or machine object in Active Directoy
Directory Container Path	string	false	Path to the container of this user or machine object in Active Directory
Directory Site Name	string	false
Directory Location	string	false
Description	string	false
Network Address	string	false
Network Mac Address	string	false
Operating System	string	true	Operating System installed on this machine as reported by OctoSAM scanners
Operating System Publisher	string	false	Publisher of the operating system
Operating System Family	string	false	A short identifier of the operating system family
Operating System Server	bool	false
Operating System Version	string	false	Version of the Operating System installed on this machine as reported by OctoSAM scanners
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
Most Frequent User ID	numeric	false	OctoSAM internal ID of the user that is most frequently using this machine
Most Frequent User Guid	guid	false	OctoSAM internal Guid of the user that is most frequently using this machine
Most Frequent Organization ID	numeric	true
Most Frequent User	string	true	User that is most frequently using this machine
Most Frequent User Login Name	string	false
Most Frequent User Domain Name	string	false
Most Frequent User Principal Name	string	false
Most Frequent User Mail	string	false
Most Frequent User Directory Path	string	false
Most Frequent User Directory Container Path	string	false
Last User ID	numeric	false	OctoSAM internal ID of the user that last used this machine
Last User Guid	guid	false	OctoSAM internal guid of the user that last used this machine
Last User Organization ID	numeric	false
Last User	string	true	User that last used this machine
Last User Login Name	string	false	Login name of the last user that used this machine
Last User Domain Name	string	false	Domainname of the last user that used this machine
Last User Principal Name	string	false
Last User Mail	string	false
Last User Directory Path	string	false	Path to the last user in Active Directory
Last User Directory Container Path	string	false
Installation Approved	bool	true	If true, installation of this signature is approved on all machines.
Installation Approved Changed	date	false	Date/Time the installation approval flag was last changed
Installation Approved Changed By	string	false	User that last changed the installation approval flag
Installation Custom Field1	string	false	Custom field available for site-specific per installation data, Not used by OctoSAM logic.
Installation Custom Field2	string	false	Custom field available for site-specific per installation data, Not used by OctoSAM logic.
Installation Custom Field3	string	false	Custom field available for site-specific per installation data, Not used by OctoSAM logic.
Installation Custom Field4	string	false	Custom field available for site-specific per installation data, Not used by OctoSAM logic.
Last Scan	date	true	Date/Time this entity got scanned last
Last Found In Directory	date	false
Directory Last Logon Time Stamp	date	false
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

• SoftwareSignature

Query information

Property	Value	Description
Query Guid	f641d19d-8173-4898-b13b-bcfd2e2961f2	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