SELECT  vMachine.machName, vAddRemoveList.applicationName

FROM ksubscribers.dbo.vAddRemoveList

join vMachine on vMachine.agentGuid = vAddRemoveList.agentGuid

where applicationName ....

or create a view and use the application filter to select only those machines with a specific *.exe installed - you can even limit to specific versions using this as well ....