Sql query to get the list of Jira software and Jira Service Desk Active users last login details.

[krishnakanth_av]

Can you help us the SQL query- 

we need to find out the the list of active users who are effectively using Jira software and Jira service desk application. We are currently using unlimited license. We are now planning to go with limited user license, therefore planning to clean up the users. Please help us to provide the SQL query for the below two questions- 

1) Users who are never logged in or not logged into jira service desk from last 12 months, these users might have logged in Jira software.

2) Users who are never logged in or not logged into jira software from last 12 months, these users might have logged in Jira service desk.

Appreciate the help.

Thanks & Regards

Krishna

[Angélica Luz]

Hi Krishnakanth,

I saw that you created a ticket with our support related to the same question and it was already closed.
I'll share the same documentation here in case other community members need to get the same information:
- Retrieve last login dates for users from the database

Regards,
Angélica