Need MYSQL Query

[Mahendar]

Hi All,

I need mysql Query for jira to fetch out all my custom fields which are used by last six month and also unused custom field from last six month

[brbojorque]

Hi @Mahendar ,

You can create your own query through the help of the JIRA Schema it should be the same as other database vendors I believe.

Here's the link to the schema.

https://developer.atlassian.com/server/jira/platform/database-schema/

-

To be honest I don't see any date created column in the schema.