Get Last Login Times for Jira and Jira Crowd Service

Question

Hello,

for License cleanup we need statistic about the general User login. We use Jira with AD/Internal Authentication and also connect other systems via Jira Crowd. Now we need, for cleanup, user statistic for all systems. As the systems run in secured connections, there is no direct database access there. Is there a possibility to get this via scriptrunner or just SQL Statements?

Best

Patrick

Patrick Schneider · Answer

Hi @Christopher Maxwell , sadly not working on the Jira Crowd server. We will stick with the Jira Login Times.

Thanks.

Christopher Maxwell · Answer

Hi @Patrick Schneider ,

You may want to give this a try:

List the Last Login Date for all Users in Crowd

The KB article has SQL queries to help extract the information from the database.

Patrick Schneider · Answer

Hi @Laurie Sciutti , thanks for the tip. Sadly we don't use Crowd Standalone. Instead we are using Jira Crowd Service to let users auth from other Atlassian systems. For this i could not find a way to use this plugin.