Does this help? select a.*, b.* from fn_ListLatestApplicationCIs(1033) a left join v_CatalogAppModelProperties b on a.ModelID = b.ModelOrProgId
Von: Kevin Ray Gesendet: Donnerstag, 31. März 2016 14:55 An: mssms Betreff: Re: [mssms] sql query for All application names with ApplicationCatalog Display Name and tagged categories. Any help on this reporting On Wed, Mar 30, 2016 at 2:16 PM, Kevin Ray <[email protected]> wrote: I want to join below both Function and View.. v_CatalogAppModelProperties(name) contains all Applicaiton Catalog Display Name fn_ListLatestApplicationCIs(1033)(diplayname) contains all SCCM Console Application standard name result Looking for SCCM All Application name and If it is enabled for Applicaiton Catalog Displayname and categories. Or if we have any sql query for All applicaiton names with Applicaiton Catalog Display Name and categories. any help!!!!!!!!
