Month: December 2013

App-V 5.0 – count most used packages

Posted on Updated on

If using standalone AppV 5.0 infrastructure, use the following SQL query against your AppVReporting database to retrieve a count the most used AppV packages.

select distinct 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 package_name
order by 'use count' desc

count_most_used_pkgs

App-V 5.0 – users of apps by date

Posted on Updated on

If using standalone AppV 5.0 infrastructure, use the following SQL query against your AppVReporting database to retrieve a list of apps run by users on by date.

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

users_of_apps_by_date

App-V 5.0 – count most used apps

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 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

count_most_used_apps

App-V 5.0 – count app usage

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.

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

count_app_usage

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