Retrieve updated time of the issues for all projects

[Packialakshmi Subramanian]

Hi,

There are 1000's of projects created in our instance. We would like to retrieve last updated date of each of those projects to make crucial business decisions.

I used below PostgreSQL query to get the data.

SELECT DISTINCT p.pkey,p.LEAD,MAX(i.UPDATED) as "Last Updated"
FROM jiraissue i
INNER JOIN project p
ON p.ID = i.PROJECT
GROUP BY p.pkey,p.LEAD,p.pname
ORDER BY MAX(i.UPDATED) ASC

However, I still see discrepancies with certain projects. please advise how should I modify the query to retrieve last action date of these projects.