Kaseya Community

SQL: How do i get a list of all machines with a specific program installed?

This question is not answered

Hi

Does someone know how to get a list of all machines with a specific program installed? by using sql

All Replies
  • 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 ....