search query for active projects

[maarten breesnee]

I want to have a look for projects that aren't used quite often. Is there a SQL that can search for projects where last update on an issue was more then 6 months ago. (not with specific time range)

[PADMA KOTHAKOTA]

Hi Maarten,

You can use the below SQL  to find out the projects which were inactive i.e not used for past months

select * from project where key not in (select distinct(pkey) from jiraissue where updated > "insert your date here")

[maarten breesnee]

Yes I found that one... but there isn't one that has somenting like 

select * project where key not in(select(pkey) from jiraisue where updated is less then 6 months ago. 

so have dynamic range... 

[Emerico Vespucci]

@maarten breesnee Did you ever get this to work?

[Emerico Vespucci]

@PADMA KOTHAKOTA  Can you please provide the correct syntax for the SQL command. Also, is the db schema the same regardless of which database we are usinng? For example, Postgres vs mySql