Thanks tortson ..thats what am looking On Thursday, March 31, 2016, Torsten Meringer <[email protected]> wrote:
> Does this help? > > > > select > > a.*, > > b.* > > from > > fn_ListLatestApplicationCIs(1033) a > > left join v_CatalogAppModelProperties b on a.ModelID = b.ModelOrProgId > > > > > > *Von: *Kevin Ray <javascript:_e(%7B%7D,'cvml','[email protected]');> > *Gesendet: *Donnerstag, 31. März 2016 14:55 > *An: *mssms <javascript:_e(%7B%7D,'cvml','[email protected]');> > *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] > <javascript:_e(%7B%7D,'cvml','[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!!!!!!!! > > > > > > > > > >
