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

This is quick post on how to get list of Applications that are deployed to users requires approval . more Details ,refer

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:

VRS.Netbios_Name0 AS [Requested Computer Name],
U.Full_User_Name0 AS [Requested User],
max(UR.CreationTime) AS [Requested Date],
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


Configmgr 2012 SQL Views

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

    1. 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).


Leave a Reply