About App-V 5.0 Reporting
Microsoft Application Virtualization (App-V) 5.0 includes a built-in reporting feature that helps you collect information about computers running the App-V 5.0 client as well as information about virtual application package usage. You can use this information to generate reports from a centralized database.
App-V 5.0 Reporting Overview
The following list displays the end–to-end high-level workflow for reporting in App-V 5.0.
The Microsoft Application Virtualization (App-V) 5.0 Reporting server has the following prerequisites:
Internet Information Service (IIS) web server role
Windows Authentication role (under IIS / Security)
SQL Server installed and running with SQL Server Reporting Services (SSRS)
To confirm SQL Server Reporting Services is running, view
http://localhost/Reportsin a web browser as administrator on the server that will host App-V 5.0 Reporting. The SQL Server Reporting Services Home page should display.
Install the App-V 5.0 reporting server and associated database. For more information about installing the reporting server see How to install the Reporting Server on a Standalone Computer and Connect it to the Database. Configure the time when the computer running the App-V 5.0 client should send data to the reporting server.
If you are not using an electronic software distribution system such as Configuration Manager to view reports then you can define reports in SQL Server Reporting Service. Download predefined appvshort Reports from the Download Center at http://go.microsoft.com/fwlink/?LinkId=397255.
If you are using the Configuration Manager integration with App-V 5.0, most reports are generated from Configuration Manager rather than from App-V 5.0.
After importing the App-V 5.0 PowerShell module using
Import-Module AppvClientas administrator, enable the App-V 5.0 client. This sample PowerShell cmdlet enables App-V 5.0 reporting:
Set-AppvClientConfiguration –reportingserverurl <url>:<port> -reportingenabled 1 – ReportingStartTime <0-23> - ReportingRandomDelay <#min>
To immediately send App-V 5.0 report data, run
Send-AppvClientReporton the App-V 5.0 client.
For more information about installing the App-V 5.0 client with reporting enabled see About Client Configuration Settings. To administer App-V 5.0 Reporting with Windows PowerShell, see How to Enable Reporting on the App-V 5.0 Client by Using PowerShell.
After the reporting server receives the data from the App-V 5.0 client it sends the data to the reporting database. When the database receives and processes the client data, a successful reply is sent to the reporting server and then a notification is sent to the App-V 5.0 client.
When the App-V 5.0 client receives the success notification, it empties the data cache to conserve space.
By default the cache is cleared after the server confirms receipt of data. You can manually configure the client to save the data cache.
If the App-V 5.0 client device does not receive a success notification from the server, it retains data in the cache and tries to resend data at the next configured interval. Clients continue to collect data and add it to the cache.
App-V 5.0 reporting server frequently asked questions
The following table displays answers to common questions about App-V 5.0 reporting
What is the frequency that reporting information is sent to the reporting database?
The frequency depends on how the reporting task is configured on the computer running the App-V 5.0 client. You must configure the frequency / interval for sending the reporting data. App-V 5.0 Reporting is not enabled by default.
What information is stored in the reporting server database?
The following list displays what is stored in the reporting database:
What is the average volume of information that is sent to the reporting server?
It depends. The following list displays the three sets of the data sent to the reporting server:
Can reporting be scheduled?
Yes. Besides manually sending reporting using PowerShell Cmdlets (Send-AppvClientReport), the task can be scheduled so it will happen automatically. There are two ways to schedule the reporting:
App-V 5.0 Client Reporting
To use App-V 5.0 reporting you must install and configure the App-V 5.0 client. After the client has been installed, use the Set-AppVClientConfiguration PowerShell cmdlet or the ADMX Template to configure reporting. The reporting feature cmdlets are available by using the following link and are prefaced by Reporting. For a complete list of client configuration settings see About Client Configuration Settings. The following section provides examples of App-V 5.0 client reporting configuration using PowerShell.
Configuring App-V Client reporting using PowerShell
The following examples show how PowerShell parameters can configure the reporting features of the App-V 5.0 client.
The following configuration task can also be configured using Group Policy settings in the App-V 5.0 ADMX template. For more information about using the ADMX template, see How to Modify App-V 5.0 Client Configuration Using the ADMX Template and Group Policy.
To enable reporting and to initiate data collection on the computer running the App-V 5.0 client:
Set-AppVClientConfiguration –ReportingEnabled 1
To configure the client to automatically send data to a specific reporting server:
Set-AppVClientConfiguration –ReportingServerURL http://MyReportingServer:MyPort/ -ReportingStartTime 20 -ReportingInterval 1 -ReportingRandomDelay 30
-ReportingInterval 1 -ReportingRandomDelay 30
This example configures the client to automatically send the reporting data to the reporting server URL http://MyReportingServer:MyPort/. Additionally, the reporting data will be sent daily between 8:00 and 8:30 PM, depending on the random delay generated for the session.
To limit the size of the data cache on the client:
Set-AppvClientConfiguration –ReportingDataCacheLimit 100
Configures the maximum size of the reporting cache on the computer running the App-V 5.0 client to 100 MB. If the cache limit is reached before the data is sent to the server, then the log rolls over and data will be overwritten as necessary.
To configure the data block size transmitted across the network between the client and the server:
Set-AppvClientConfiguration –ReportingDataBlockSize 10240
Specifies the maximum data block that the client sends to 10240 MB.
Types of data collected
The following table displays the types of information you can collect by using App-V 5.0 reporting.
|Client Information||Package Information||Application Usage|
Start and End Times
App-V 5.0 Client Version
Operating System Version
Service Pack Level
Operating System Type
The client collects and saves this data in an .xml format. The data cache is hidden by default and requires administrator rights to open the XML file.
Sending data to the server
You can configure the computer that is running the App-V 5.0 client to automatically send data to the specified reporting server. To specify the server use the Set-AppvClientConfiguration cmdlet with the following settings:
After you configure the previous settings, you must create a scheduled task. The scheduled task will contact the server specified by the ReportingServerURL setting and will initiate the transfer. If you want to manually send data outside of the scheduled times, use the following PowerShell cmdlet:
Send-AppVClientReport –URL http://MyReportingServer:MyPort/ -DeleteOnSuccess
If the reporting server has been previously configured, then the –URL parameter can be omitted. Alternatively, if the data should be sent to an alternate location, specify a different URL to override the configured ReportingServerURL for this data collection.
The -DeleteOnSuccess parameter indicates that if the transfer is successful, then the data cache is cleared. If this is not specified, then the cache will not be cleared.
Manual Data Collection
You can also use the Send-AppVClientReport cmdlet to manually collect data. This solution is helpful with or without an existing reporting server. The following list displays information about collecting data with or without a reporting server.
|With a Reporting Server||Without a Reporting Server|
If you have an existing App-V 5.0 reporting Server, create a customized scheduled task or script. Specify that the client send the data to the specified location with the desired frequency.
If you do not have an existing App-V 5.0 reporting Server, use the –URL parameter to send the data to a specified share. For example:
The previous example will send the reporting data to \MyShare\MyData</strong> location indicated by the -URL parameter. After the data has been sent, the cache is cleared.
If a location other than the Reporting Server is specified, the data is sent using .xml format with no additional processing.
To retrieve report information and create reports using App-V 5.0 you must use one of the following methods:
Microsoft SQL Server Reporting Services (SSRS) - Microsoft SQL Server Reporting Services is available with Microsoft SQL Server. SSRS is not installed when you install the App-V 5.0 reporting server. It must be deployed separately to generate the associated reports.
Use the following link for more information about using Microsoft SQL Server Reporting Services.
Scripting – You can generate reports by scripting directly against the App-V 5.0 reporting database. For example:
spProcessClientReport is scheduled to run at midnight or 12:00 AM.
To run the Microsoft SQL Server Scheduled Stored procedure, the Microsoft SQL Server Agent must be running. You should ensure that the Microsoft SQL Server Agent is set to AutoStart. For more information see Autostart SQL Server Agent (SQL Server Management Studio).
The stored procedure is also created when using the App-V 5.0 database scripts.
You should also ensure that the reporting server web service’s Maximum Concurrent Connections is set to a value that the server will be able to manage without impacting availability. The recommended number of Maximum Concurrent Connections for the Reporting Web Service is 10,000.