Hi

I want to extract all our open projects and I can achieve this through a basic edit of the SQL in the following post:

https://forums.manageengine.com/topic/report-query-projects

However, I would also like to retrieve the latest project comment and use this to build a weekly status report for active projects.

Is this something that you could provide for mysql version of the DB?

Many thanks

Damien