Retrieving Confluence User Last Login Date without using SQL Database from Server

Question

We have Confluence Server in our environment and I would like to retrieve Last login date of users in Confluence. I don't want to use SQL Query as to me , it's not a good idea to directly using the Database and would like to use REST API.

Is there any REST API available which provides me Last login date information. I am able to collect, User Id, Display Name, Status etc.

Thanks,

Arindam

Brant Schroeder · Answer

I do not know of a way to get that information via the delivered API.  If you have ScriptRunner you could create an endpoint that provides that information.

Arindam Hazra · Answer

Thanks Brant for you your quick response. Is there any way to get it using API.

I am running some other automation stuffs using Powershell and accessing REST API end points  while running those.

I am more curious to get some information on the API. I am using Confluence Server in my environment.

Thanks

Arindam

Brant Schroeder · Answer

You can u create a macro that displays the information.

Macro Documentation

* https://confluence.atlassian.com/doc/macros-139387.html
* https://community.atlassian.com/t5/Confluence-questions/Macro-that-produces-a-list-of-users-last-login-date/qaq-p/426611

If you have a lot of users then this could be slow.