Close Menu
    Facebook X (Twitter) Instagram
    Monday, July 14
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»Configmgr 2012 query how to get list of applications that requires approval

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

    Eswar KonetiBy Eswar KonetiDecember 18, 6:34 am1 Min Read CM2012 6,140 Views
    Share
    Facebook Twitter LinkedIn Reddit

    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
    and uta.requireapproval=1
    order by app.displayname

    fn_ListApplicationCIs(1033) contains other important information ,so you can add all of them here if you need. To know what info ,fn_ListApplicationCIs(1033) has ,just run select top 5 * From fn_ListApplicationCIs(1033) ,gives you the first 5 rows .

     

    To know further details about,who requested what or applications requested by whom and the computer name,use the following SQL Query:

    Select
    VRS.Netbios_Name0 AS [Requested Computer Name],
    U.Full_User_Name0 AS [Requested User],
    max(UR.CreationTime) AS [Requested Date],
    Apps.DisplayName
    From UserAppModelSoftwareRequest UR
    Left Join UserMachineRelation UMR on UMR.RelationshipResourceID = UR.RelationshipResourceID
    Left Join v_R_User U on U.Unique_User_Name0 = UMR.UniqueUserName
    Left Join v_R_System VRS on VRS.ResourceID = UMR.MachineResourceID
    Left Join fn_ListApplicationCIs(1033) Apps on Apps.ModelName = UR.AppID
    group by VRS.Netbios_Name0 ,U.Full_User_Name0,Apps.DisplayName

    Reference: http://myitforum.com/myitforumwp/2013/01/11/query-configmgr-database-for-applications-that-require-admin-approval/

    Configmgr 2012 SQL Views http://eskonr.com/2013/10/download-sccm-configmgr-2012-r2-sql-views/

    App approval approval apps report sccm apps requires approval CM12 configmgr list of apps requested by Users report requireapproval SCCM 2012 sccm report applications requires approval SQL query UDA user apps
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Identifying devices managed by Intune but not reporting to WUfB using KQL

    November 09, 10:28 am

    3 Comments

    1. Brandon on November 24, 2015 11:37 PM

      Invalid object name 'v_UserTargetedApps'.

      Reply
      • Eswar Koneti on November 26, 2015 10:57 AM

        have you enabled the application catalog ? can you try this query to confirm if the view exist or not in your database ? select * from v_UserTargetedApps .if that doesn't exist,something wrong with your database (if you have already enabled the app catalog role and assigned apps to users).

        Reply
      • Klaus TH. on December 7, 2016 10:12 PM

        Use your PrimarySite DB in case you have a CentralAdminSite, the view does not exist on the CAS DB 🙁

        Reply

    Leave a ReplyCancel reply

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

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.