How to calculate when my standard change template was last used ?

[Gudu]

Hello Developers,

I have a task to fetch the report from standard change template as below

Number   Summary      Description       Approval Status        Change Initiator       RFC Type     Planned Start Date Planned End Date       Template Name     Sub Status

Also need the following info:

Last Used

Active / Not Active

But Last used option is not there in the table, so is there a way to fetch the repot that when my standard change template was last used in reporting?

Your suggestions will be appreciated.

[Sagar Pagar]

Hi,

Create a report on table - std_change_record_producer and include a field called  - "Closed change count" in your report.

Take a reference from this-

Thanks,

Sagar Pagar

[Gudu]

Hi Sagar,

i am not getting the table name(std_change_record_producer) in report .

[Gudu]

Hello Everyone,

Could anyone please assist here. 

i am not getting std_change_record_producer table as suggested above. 

is there any other way to check when the standard change template was last time used.

[Gudu]

Could anyone please assist?