Month: December 2014

Posted on December 30, 2014 by | 2 Comments | 167 Views
New Year (2015) around the corner and this will be the last post for this year (2014).A big Thanks to all my blog readers who followed me and supports me in writing useful blogs. I wish that You may not only change the date of the calendar, but also your focus, commitments and actions for…
Read more »

Posted on December 18, 2014 by | 3 Comments | 5,754 Views
This is quick post on how to get list of Applications that are deployed to users requires approval . more Details ,refer https://social.technet.microsoft.com/Forums/en-US/644ff540-4eb0-49b6-97f4-094cada74c6a/viewing-deployments-that-require-approval?forum=configmanagerapps Run the following SQL query to know apps that require Approval. select app.displayname [Application Name],app.manufacturer [Manufacturer],app.numberofdeviceswithapp [No of Devices with this App],app.numberofuserswithrequest [No of Requests] from fn_ListApplicationCIs(1033) app, v_UserTargetedApps uta where uta.ci_id=app.ci_id…
Read more »