The new version of my PrepSQL tool now supports the changes that have been introduced with ServicePack 3 for App-V 5. You can silently create the App-V Management Database and Reporting Database on remote SQL servers, on SQL server clusters or in scenarios, where you can’t run App-V’s setup wizard on the SQL server machine. This new version also allows to upgrade the databases from a pre-SP3 version. It already includes the fix for a known error with Microsoft’s original scripts.
Download PrepSQL for App-V 5 SP3 from kirx.org
Use SQL Reporting Services is the common answer to the question of how to present all the application launch data that App-V’s SQL based reporting collected. In this article you’ll not only see how to use just Excel for creating graphical reports, but you also see that you can use the pure XML based information from the previous parts of this mini-series to feed that.
In the first part of this series we talked about how to collect App-V 5 Reporting data with just a simple file share. In this 2nd part we’ll focus on how to prepare the collected data, allowing further processing.
About a year ago I published a Powershell script that helps preparing the App-V 5 Management and Reporting database for scenarios, where executing App-V’s setup wizard locally on the SQL server is not appropriate. The script has evolved, and a new version is available right now.
With PrepSQL for App-V 5, you can
Dowload PrepSQL v2 from kirx.org
It’s not a secret that I am a super-fan of Gridmetric’s Application Virtualization Explorer (AVE) since it was released and replaced the old SFTExplorer. Therefor I’m really happy that Kalle Saunamäki told me about the release of AVE 3.0, the first and only 3rd party editor for App-V 5 packages. Here is why you should get your hands on it, too.
The App-V Visio Stencil has been updated to reflect the new components that were introduced with App-V 5.
It contains dedicated symbols for the Publishing, Management, Reporting and Streaming Service as well as symbols for Clients running in shared-content mode. Symbols are genric enough to be used with App-V 4.x as well.
A while ago I wrote an article about what to do if you want to implement a Full App-V 5 Infrastructure – and you’re not the SQL Admin. Now, with App-V 5 going RTM, there are some updates – including additions for the Reporting Database and a little Powershell helper for you.
Do you want to launch ‘cmd.exe’ within an App-V 5 (Beta) Virtual Environment? ‘OSD Scripting’ can’t help you here… OSDs are gone. Read about a quite neat method that was discussed during the German User Group – and that was streamlined by Volker Kleiner (@vkleinerde)…
Do you want to update all your old SoftGrid / App-V Packages to the newest Sequencer / Client version? Do you need to create Publishing MSIs for a bunch of packages because in the past you didn’t need them but want to use them now? Here is a simple Powershell Script that converts all existing packages within a folder structure recursively.
Do you want to get a comprehensive overview of all your App-V applications and packages, no matter if you use a Management Server, SCCM, another deployment solution or even manual deplyoments?
Do you want to verify quickly, if Naming Conflicts between virtual packages, 8+3 folders and other items occur?
Then, get Login Consultant’s “App-V Analyzer” to get all the infos usefully presented!