Anyone know how to generate log report with ECR and ECN linked?

I guess you are querying about the suggestions for Windchill, if so, you can post the question to Windchill Forum.

You need to build a report using Query Builder. 

 https://support.ptc.com/help/wnc/r12.0.2.0/en/#page/Windchill_Help_Center%2FQBQueryBuilderOview.html

Hello @ZN_11361475 ,

It appears that this  answers your question.  For the benefit of other Community Members who may have the same question, it would be great if you could designate it as the Accepted Solution.

In the event that this response did not answer your question, please post your current status so that we can continue to support.

Thanks for using the PTC Community!

Regards,

Pehowe

Take a look at these articles:

How to understand Change Management objects and their relations

Report listing all Change Requests without an associated Change Notice

Report listing all Change Requests with/without an associated Change Notice

Report that shows all Change Notices, Change Tasks along with any underlying Change Requests and Problem Reports (if they exist)

How to link work items of Change Request to Change Requests, Change Notices and Change Tasks

What is the alternate for wt.change2.AddressedBy2 to link Change Request and Change Notice using Flexible Change Mode