Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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