CMS Infrastructure Services - Information - How to retrieve the list of analyzer metamodel types per technology

This page lists a query to fetch the complete list of standard analyzers meta-model based types that are used in the Dynamic Link Manager (DLM) Filter rules per technology.

The below query will list around 1500 object types that can be used in the DLM engine (and other configuration files either), grouping them by technology/language:

select c.CatDsc as "Technology/Language",
       t.TypDsc as "Type Description",
       t.IdTyp as "Type ID",
       t.TypNam as "Type Name"
  from Cat c
  join TypCat tct
    on tct.IdCatParent = c.IdCat
  join Typ t
    on t.IdTyp = tct.IdTyp
  join TypCat tc
    on tc.IdTyp = t.IdTyp
   and tc.IdCatParent = 1023
 where c.IdCat in (select cc.IdCat
                     from CatCat cc
                    where cc.IdCatParent = 6000)
 order by c.CatDsc, t.TypDsc;

 Each of the results returned should be like this sample below (Technology/Language, Type Description, Type ID, Type Name):

".Net";".NET AppSetting found in configuration file";137626;"CAST_DotNet_AppSettingType"