Inactive projects list

[Thatiparthi Venkatesh]

Hi All,

May i know how to get projects list which are not in use or not updated from last one year.

Regards,

Venkatesh

[Valerie Knapp]

Hi @Thatiparthi Venkatesh , thanks for your question.

Please check out this post which has some SQL queries to help you with this - https://community.atlassian.com/t5/Jira-questions/How-to-find-which-projects-are-inactive-in-last-6-months-Like-to/qaq-p/893501 

Cheers