It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to get last authenticated in confluence using rest api?

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.

 

2 answers

0 votes
Daniel_Eads Atlassian Team Apr 22, 2019

Hey Jan,

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!

Cheers,
Daniel

@Jan_Nylund  Any update on this ? . I am also doing the auditing on the last logged in user details 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What project did you transition or start on Confluence with the shift to remote work?

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...

109 views 3 7
Join discussion

Community Events

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

Events near you