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.

[pavani_paluri]

Hi @Suggy ,

Have you tried checking the template field value on change request table. I am thinking as its a new table sc_item_produced_record, we wont have any old data.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[Anand2799]

Hi @Suggy ,

The field "Standard Change Template version" stores the reference to the template which was used to create the change request, blank if not used any.

Thanks

Anand

[Suggy]

Thanks Anand, any idea why I am not able to see the data in sc_item_produced_record table?

[TejasSN_LogicX]

Hi @Suggy,

1) On the change table, you can add the below filter.

type = standard

Then right-click on the "standard change template version" column and then select "group by field".

It shows all the template lists which were used to create the records.

Also, every change record has this "standard change template version" field. which shows which template was used to create this field.