Home Service Manager

SQL Query to get templates data

Manpreet_SinghManpreet_Singh Customer IT Monkey ✭

Hi I am trying to get (template name, template id, classification) for all the templates in Service Manager, But I am not able to find any specific table that contains this information ? Any idea where I should look ?


  • Options
    Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

    The actual values are buried in the XML of the template, but the metadata about the template itself is available in the ServiceManager database:






    FROM ObjectTemplate ot WITH (NOLOCK)

    LEFT JOIN TypeProjection tp WITH (NOLOCK)

    ON ot.ObjectTemplateTypeId = tp.TypeProjectionId

    LEFT JOIN DisplayStringView ds WITH (NOLOCK)

    ON ot.ObjectTemplateId = ds.LTStringId

    AND ds.LanguageCode = 'ENU'

Sign In or Register to comment.