App-V 5.0 reporting – count app usage by user

Posted on Updated on

If using standalone AppV 5.0 infrastructure, use the following SQL query  against your AppVReporting database to retrieve a count of application usage by user.

select distinct username, 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 app_name like '% the app name %'
      and pkg.version_guid=apu.version_guid
group by username, app_name, package_name

count_app_use_by_user

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s