This is a PowerShell module to simplify extracting data from the App-V reporting database.
At the moment, you can pull details on App-V clients, packages, and usage. Usage data includes data with inner joins.
Get client version counts:
Get details on App-V usage:
Find packages by location:
#Prerequisites
- Environment configured to send data to an App-V reporting server
- The account running this query must have access to read the App-V Reporting Database (PackageInformation, ClientInformation, ApplicationUsage tables). Otherwise, SQL login credentials must be provided.
- Module folder downloaded, unblocked, extracted, available to import
#Instructions
#One time setup:
#Download the repository
#Unblock the zip file
#Extract AppVReporting folder to a module path (e.g. $env:USERPROFILE\Documents\WindowsPowerShell\Modules\)
#Each PowerShell session
Import-Module AppVReporting #Alternatively, Import-Module "\\Path\To\AppVReporting"
#List commands in the module
Get-Command -Module AppVReporting
#Get help for a command
Get-Help Get-AppVUse -Full
#Optional one time step: Set default reporting server SQL instance and database name
Set-AppVReportingConfig -ServerInstance SomeSQLInstance -DatabaseName AppVReporting
#View app-v packages stored on \\server\share\stream\*
Get-AppVPackage -source \\server\share\stream\*
#View app-v clients at version 5.0.3361.0
Get-AppVClient -Version 5.0.3361.0
#View all App-V usage in a grid
Get-AppVUse | Out-Gridview