UDA – All about Microsoft Endpoint Manager

Configmgr 2012 query how to get list of applications that requires approval

Posted on December 18, 2014 by Eswar Koneti | 3 Comments | 5,751 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…

SCCM Configmgr 2012 How to Create Collection to get list of computers from Users OU using UDA

Posted on October 30, 2014 by Eswar Koneti | 3 Comments | 3,739 Views

I had a requirement to deploy patches (part of patch testing) to Department (group of user around 200+) who resides in one OU in Active Directory .The computers used by them are different due to their work nature and they keep moving with different computers (with different apps). I need to get list of computers…

SCCM Configmgr 2012 Collection for computers with Primary User (UDA) is NULL

Posted on March 18, 2014 by Eswar Koneti | 4 Comments | 11,748 Views

If you are using User Device Affinity--associating a user with one or more specified devices for application deployment to make sure the application install on all devices that are associated with that user,it is necessary to identify the computers which do not have primary User Defined.More about User Define Affinity http://technet.microsoft.com/en-us/library/gg699365.aspx. Create collection using below…