MachinesBySoftwareItemWithApproval (System SoftwareItem Context)

OctoSAM SoftwareItem context 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
Reason	string	true
Software Package ID	numeric	false	Internal ID that references the SoftwarePackage entity (Foreign Key)
Software Package	string	false	Software package name from the OctoSAM software catalog
Approved	bool	true
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
Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Organization Guid	guid	false	Internal unique identifier for this organization that can be used for links from external systems
Organization	string	true	Name of the organization
Organization Description	string	false	Description
Environment ID	numeric	false	Internal ID that references the Environment entity (Foreign Key)
Environment	string	false	Name of the Environment
Organization Custom Field4	string	false	Available for custom data, not used by OctoSAM Inventory
Object State ID	numeric	false	Internal ID that references the ObjectState entity (Foreign Key)
Object State	string	false	Object state name
Object State Octopus Id	string	false	OctoSAM internal name for programmatic access to the object state (e.g. in queries)
Machine Guid	guid	false	A unique ID that can be used to link to this machine object by external applications
Machine ID	numeric	false	Internal ID for the Machine entity (Primary Key)
Machine Name	string	false	Machine name (computer name)
Machine	string	true	Use this name in reports for consistency and to avoid having to build the printable name from its parts
Alternate Name	string	false	Contains the computer name for systems that may have different host and computer names, such as macOS
Fully Qualified Domain Name	string	false	Fully qualified domain name as seen by the scanner through reverse lookup of the network address
Machine Description	string	false	Description attribute of the directory service or manually entered during offline scan
Alternate Description	string	false	Alternate description field specific to the scanned machine type. For example locally entered description in macOS.
Domain Name	string	false	Windows NETBIOS Domain Name
Site	string	false	Active Directory Site that the machine belongs to
Location	string	false	Active Directory location attribute
Directory Extension Attribute4	string	false	ExtensionAttribute from Active Directory
Sid	string	false	Computer SID
Last Scan Guid	guid	false	GUID of the last imported .scan file for this entity.
First Scan	date	false	Date/Time of first scan of this machine
Deleted In Directory	bool	false	True, if directory check detects that the machine is no longer found in directory
Deleted In Directory First Detected	date	false	Date/Time the delete flag was set
Directory Path	string	false	Path where the machine was found in the directory service. Usually an LDAP path.
Directory Container Path	string	false	Path to the container of this object. Provided for grouping or export to other applications.
Scanned Distinguished Name	string	false	Distinguished computer name as seen locally from the scanner. This is collected using the AdsiInfo COM object and may differ from the DirectoryPath field.
Manufacturer ID	numeric	false	Internal ID that references the Manufacturer entity (Foreign Key)
Manufacturer	string	false	Normalized hardware manufacturer name
Directory Last Logon Timestamp	date	false	LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days.
Directory Last Logon Last Scan Diff	numeric	false
Directory When Created	date	false	WhenCreated attribute from Active Directory
Directory Disabled	bool	false	True if the UserAccountControl attribute has the disable bit set
Most Frequent User ID	numeric	false	Internal ID that references the User entity (Foreign Key)
Most Frequent User	string	true	Combination of attributes for consistent naming on screen or in reports
Most Frequent User Guid	guid	false	A unique ID that can be used to link to this user object by external applications
Most Frequent User Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Most Frequent User Organization	string	false	Name of the organization
Most Frequent User Principal Name	string	false	UserPrincipalName from the directory service
Most Frequent User Mail	string	false	Mail attribute from Active Directory
Most Frequent User Domain Name	string	false	Domain of the logged on user
Most Frequent User Login Name	string	false	Access
Last User ID	numeric	false	Internal ID that references the User entity (Foreign Key)
Last User	string	false	Combination of attributes for consistent naming on screen or in reports
Last User Guid	guid	false	A unique ID that can be used to link to this user object by external applications
Last User Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Custom Field4	string	false	Available for custom data for this Machine, not used by OctoSAM Inventory
Virtual Machine	bool	true	True if this is a virtual machine
Virtualization Host	bool	false	True if this machine hosts virtual machines
Last Scan	date	true	Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync)
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	448f6ee0-d810-400b-98e3-925640e0a150	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
LastUpdate	2026-02-21 17:20:39	Last change to this document
Build	1.12.3.52	OctoSAM build that last changed this document