ConfigMgr – Detect User Centric App-V available Installations

If you are using System Center Configuration Manager (SCCM or ConfigMgr) together with Application Virtualization from the Microsoft Desktop Optimization Pack, you also might use the option to deploy the software to users. No clue until now, but what, if your deployment is an Available, and Users are installing the Software from the Application catalog website, how do you update the App-V package for those users who have installed the App-V Package?

You need to create a query, which will give you the information, which users have installed the specific App-V Package. The first step to go on with this task is to get the proper Application Name, which we will later use. Navigate to your application, and take a note of the name, in my case “Earth 7.1”:
Application Name
When this is done, go one to the Monitoring section, and get to the Queries to create a new query:
Create Query
Give the new Query a proper name, and click on “Edit Query statement …”:
Set query name
When the window is opened click on “Show query language” and copy the code below, mind to change the application name at the end:
select SMS_R_USER.ResourceID,SMS_R_USER.ResourceType,SMS_R_USER.Name,SMS_R_USER.UniqueUserName,SMS_R_USER.WindowsNTDomain
from SMS_R_User inner join SMS_G_System_AppClientState on SMS_R_USER.UniqueUserName = SMS_G_System_AppClientState.UserName where SMS_G_System_AppClientState.AppName = "Earth 7.1"

Query statement
When this is done, click on “OK” -> “Next” -> “Next” -> “Finish” and the query is created. You can now double-click the Query, and see, which users have installed the Application:
If the results are as expected, you can copy the query and paste it, when it comes to create a query based user collection. With this collection, you can now create an update or an uninstall collection if needed.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.