{"id":2058,"date":"2015-12-11T00:32:13","date_gmt":"2015-12-10T22:32:13","guid":{"rendered":"http:\/\/blog.hosebei.ch\/?p=2058"},"modified":"2015-12-11T00:32:13","modified_gmt":"2015-12-10T22:32:13","slug":"configmgr-detect-user-centric-app-v-available-installations","status":"publish","type":"post","link":"https:\/\/blog.hosebei.ch\/?p=2058","title":{"rendered":"ConfigMgr &#8211; Detect User Centric App-V available Installations"},"content":{"rendered":"<p>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?<!--more--><\/p>\n<p>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 &#8220;Earth 7.1&#8221;:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection01.png\" rel=\"attachment wp-att-2061\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection01.png?w=300\" alt=\"Application Name\" width=\"300\" height=\"147\" class=\"aligncenter size-medium wp-image-2061\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection01.png 898w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection01-300x147.png 300w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection01-768x375.png 768w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nWhen this is done, go one to the Monitoring section, and get to the Queries to create a new query:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection02.png\" rel=\"attachment wp-att-2062\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection02.png?w=280\" alt=\"Create Query\" width=\"280\" height=\"300\" class=\"aligncenter size-medium wp-image-2062\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection02.png 345w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection02-280x300.png 280w\" sizes=\"auto, (max-width: 280px) 100vw, 280px\" \/><\/a><br \/>\nGive the new Query a proper name, and click on &#8220;Edit Query statement &#8230;&#8221;:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection03.png\" rel=\"attachment wp-att-2063\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection03.png?w=300\" alt=\"Set query name\" width=\"300\" height=\"253\" class=\"aligncenter size-medium wp-image-2063\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection03.png 716w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection03-300x253.png 300w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nWhen the window is opened click on &#8220;Show query language&#8221; and copy the code below, <strong>mind to change the application name at the end<\/strong>:<br \/>\n<code>select SMS_R_USER.ResourceID,SMS_R_USER.ResourceType,SMS_R_USER.Name,SMS_R_USER.UniqueUserName,SMS_R_USER.WindowsNTDomain<br \/>\n 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\"<\/code><br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection04.png\" rel=\"attachment wp-att-2064\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection04.png?w=267\" alt=\"Query statement\" width=\"267\" height=\"300\" class=\"aligncenter size-medium wp-image-2064\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection04.png 414w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection04-267x300.png 267w\" sizes=\"auto, (max-width: 267px) 100vw, 267px\" \/><\/a><br \/>\nWhen this is done, click on &#8220;OK&#8221; -&gt; &#8220;Next&#8221; -&gt; &#8220;Next&#8221; -&gt; &#8220;Finish&#8221; and the query is created. You can now double-click the Query, and see, which users have installed the Application:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection05.png\" rel=\"attachment wp-att-2066\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection05.png?w=300\" alt=\"App-VUserDetection05\" width=\"300\" height=\"58\" class=\"aligncenter size-medium wp-image-2066\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection05.png 895w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection05-300x58.png 300w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2015\/12\/app-vuserdetection05-768x148.png 768w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nIf 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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,15,33,35,37],"tags":[],"class_list":["post-2058","post","type-post","status-publish","format-standard","hentry","category-application-management","category-configmgr","category-sccm","category-sccm-2012","category-software-deployment"],"_links":{"self":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/2058","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2058"}],"version-history":[{"count":0,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/2058\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}