App-V 5.0 – count most used apps
If using standalone AppV 5.0 infrastructure, use the following SQL query against your AppVReporting database to retrieve a count of most used applications.
select distinct app_name, package_name, COUNT(*) as 'Use Count' from dbo.PackageInformation pkg inner join dbo.ApplicationUsage apu on pkg.host_id=apu.host_id where pkg.version_guid=apu.version_guid group by app_name, package_name order by 'use count' desc