Reporting against sys_ template table

nmartinez
Kilo Contributor

I am trying to figure out if I can run a report against the template table.

Specifically, I need to find templates that are created by XYZ group and DO NOT contain the configuration item field as an option within the template.

Meaning; I am not interested in the records these templates created; I need to know which templates do not use the CI field.

Any help would be appreciated.

1 REPLY 1

mukesh_itsm
Kilo Contributor

Hi Nick,

As i think you are unable to find the table name in View/Report. It can be done by this way ->
Go to sys_properties_list.do and glide.ui.permitted_tables and add sys_template in Value. and add filter and condition as your requirement.

Thanks,
Mukesh