Get Last Login Times for Jira and Jira Crowd Service

[Patrick Schneider]

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

[Christopher Maxwell]

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]

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

Thanks.

[Laurie Sciutti]

Hi @Patrick Schneider ~ we use the Centralized license visibility add-on for this (it's free!):   https://marketplace.atlassian.com/apps/1220745/centralized-license-visibility?tab=overview&hosting=server HTH

[Patrick Schneider]

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.