Is there a way to know which standard change templates were used to create the Change requests?

[Suggy]

Is there a way to know which standard change templates were used to create the Change requests?

Its a new instance on Zurich. I checked in sc_item_produced_record table, but no entries seen there.

1. Is that the table to look at or any other table?

2. If its above table, then any criteria is there? as the records are not showing up there.

[kaushal_snow]

@Suggy ,

Yes, the best place is the Change Request [change_request] table in Zurich: look at the Standard Change Template Version field (std_change_producer_version) on each change record, it holds the reference to the template version used.

If that is blank, it means no template was used.

Also, sc_item_produced_record is not the correct table to find which standard change template was used.....
To get a list of all Change Requests created from Standard Change Templates, you can filter Change Requests where type = standard and Standard Change Template Version is not empty....

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.