You want all of them or the ones that require approval? Here is all of them.
Select UR.AppID, UR.CreationTime AS [DateRequested], VRS.Netbios_Name0 AS [MachineRequestedFrom], U.Full_User_Name0 AS [RequestingUser], 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 On Fri, Dec 19, 2014 at 6:58 PM, Roland Janus <[email protected]> wrote: > Anyone knows of a method to retrieve the list of applications a user > installed through the catalog? > > > > -Roland > > > > > > > >
