SQL

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

Automating SQL 2008 R2 Express for ConfigMgr

Posted on Updated on

There are many guides online on automating the installation of SQL 2008 R2 Express.  Although each was missing a small detail, a concatenation of them led me to create a successful deployment.  Use the following process if you also are stuck trying to find the answer!

  1. Run “SQLEXPR_x64_ENU.exe /UIMODE=Normal”
  2. Go through the wizard, giving the settings desired for SQL Express, including the admins
  3. On the “Ready to Install” page of the wizard, obtain a copy of ConfigurationFile.ini and then cancel the setup wizard
  4. Edit the .ini file with the following:
    • Change parameter QUIET to “True”
      (Note: if you attempt to instead use QUIETSIMPLE to display a progress bar as part of the install, the deployment will not execute in ConfigMgr)
    • Comment out or delete the PCSOURCE parameter
    • Comment out or delete the UIMODE parameter
    • At the end of the file, add IACCEPTSQLSERVERLICENSETERMS=True
      (Note: do not use quotes around True as it’s a Boolean parameter)
  5. Create a script which
    • Copies the .ini file to c:\windows\temp
    • Executes command “SQLEXPR_x64_ENU.exe /ConfigurationFile= c:\windows\temp\ConfigurationFile.ini /INDICATEPROGRESS”

SQL Query App-V 5.0 Usage

Posted on Updated on

You can use the following query on your App-V 5.0 reporting server database (AppVReporting) to get application usage information for which users ran which software on which systems and when.


select distinct username, host_name, app_name, start_time

from dbo.ApplicationUsage APPU

join dbo.ClientInformation CLIINFO on APPU.host_id=CLIINFO.host_id

order by start_time desc

appv_usage