What are you trying to build? I am currently building an "Application Mover" where you can view all apps installed on an existing system and install them on a new system during OSD.
It shows the installed apps, usage information etc. On Mon, Dec 29, 2014 at 2:01 PM, Roland Janus <[email protected]> wrote: > Uh, that’s pretty neat! > > > > I’ve looked into a report and changed it a bit to get something similar > (quick and dirty): > > > > SELECT ds.SoftwareName AS SoftwareName, > > ds.CollectionID, > > ds.CollectionName, > > ad.MachineName, > > ad.UserName, > > ds.FeatureType, > > cm.siteid > > FROM v_CollectionExpandedUserMembers cm > > INNER JOIN v_R_User ud ON ud.ResourceID= cm.UserItemKey > > INNER JOIN v_DeploymentSummary ds ON ds.CollectionID = cm.SiteID > > LEFT JOIN v_AppIntentAssetData ad ON ad.UserName = @userid AND ad.AssignmentID > = ds.AssignmentID > > INNER JOIN v_CIAssignment cia ON cia.AssignmentID = ds.AssignmentID > > WHERE ud.Unique_User_Name0 = @userid > > > > > > didn’t check the differences and the details, but I have the feeling yours > is a better fit > > > > displayname should be what I need to create the applications variable > from, to install them during OSD. > > Now I just need all the other parts, like a webpage I can request that > data through, the primary user etc. J > > > > Thanks! > > > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Todd Hemsell > *Sent:* Montag, 29. Dezember 2014 20:32 > *To:* [email protected] > *Subject:* Re: [mssms] get list of applications a user installed > > > > 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 > > > > > > > > > > > > > >
