How to get Jira Application access granted date for an user from Audit log

[CST JIRA Confluence Admin]

Hi All,

We are required to consolidate our user access licenses in JIRA

As we run out of it, we are required to revoke for those unused ones

For which, we are looking to retrieve access granted date from Audit log for each user who has never logged-in.

Is there way to get info as below, either by sql query or groovy script ?

| Jirauserid | Access granted date |

Appreciate any thoughts & ideas

Thanks much in advance

Lokesh

[Shannon S]

Hi there, Lokesh,

You could use a combination of the following in order to get that information:

• How to check for users who never logged into Jira
• List of users showing when the accounts were created and by whom

Regards,

Shannon