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 ?

Answers

  • 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:


    SELECT

    ds.DisplayName 

    ,ot.ObjectTemplateId

    ,ot.ObjectTemplateName

    ,tp.TypeProjectionName

    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.