Hi,

Is there a SQL query to get a list of virtual applications that are installed on the clients or a sccm report? I see some built in reports but the drop down does not list all of our virtual applications? Maybe directly using SQL be better? TIA

Hi,

You may need to run WMIC to collect the list of virtual applications.

http://eskonr.com/2012/06/wmic-commands-for-virtual-applications/

Note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

I see some built in reports but any idea why they aren't showing all of my appv applications? Do I need to modify the query?

Take a look here. You will have to turn on the classes to get the info from HINV

https://nikifoster.wordpress.com/2015/01/05/inventorying-app-v-in-sccm-2012/