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



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 )

Connecting to %s