In a try to do some automatic cleanup of licenses, I'm investigating the api's on JIRA, Bitbucket and Confluence to find out when a user was last authenticated to an application.
I managed to pull the info from JIRA over the crowd api, and from bitbucket over it's rest api, but on confluence I can't seem to find this information exposed anywhere.
The confluence user information doesn't provide it, and JIRA crowd doesn't tell me when someone authenticated through the integration.
Doing some cleanup is great admin works! Unfortunately as far as I'm aware, Confluence doesn't have an API endpoint for that information.
There are a couple ways to go about this without the API. First is via SQL - the embedded Crowd database does keep track of the last login time for users. We have some sample queries here for retrieving this info from the database.
Secondly, there are marketplace apps that can identify these users for you (and some can automatically disable the users after a certain amount of time to recover the seat). You can take a look at a few of those here and see if any fit your needs.
It would be interesting to see if you have some other system doing the cleanup and come up with a way to expose the results via API. Let us know how it goes!
It’s been great to hear from fellow users over the last few weeks about the best tips and fun moments you’ve had working on Confluence since the transition to working remote. I’d love to keep the c...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events