• 1
    • 2
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      NOTE: This suggestion is for Confluence Cloud. Using Confluence Server? See the corresponding suggestion.

      You want to work out whether a user account is active or not in the user administration - and the last login date/time is the simplest way of doing that. We have this information, we just need to display it.

      Being able to sort on that value would be useful.

            [ID-8981] Display last login time in UserBrowser

            Alex added a comment -

            This would be still a nice feature to see the user information like you see in Jira.

            Alex added a comment - This would be still a nice feature to see the user information like you see in Jira.

            Sergey Svishchev added a comment - - edited

            Sergey Svishchev added a comment - - edited Please also extend Remote API to return this info (and auth directory type...) Until then, the workarounds are user macro: https://answers.atlassian.com/questions/33385/macro-that-produces-a-list-of-users-last-login-date SQL: https://confluence.atlassian.com/display/CONFKB/How+to+Identify+Inactive+Users+in+Confluence+by+Last+Login+Date

            Would be very useful indeed to have this functionality right in Confluence.

            Now there seems to be many work arounds flying around either sql or macros.

            Kjell Lauren added a comment - Would be very useful indeed to have this functionality right in Confluence. Now there seems to be many work arounds flying around either sql or macros.

            Stephanie Gallert added a comment - - edited

            Currently if you do a search for users, the Find Users screen will return User, Full Name & Email.
            It would be great if it also returned Last Login (like JIRA).
            This would be especially helpful when managing an environment with Unlimited license and/self id creation.

            I recently attended Summit 2011 and spoke with Confluence Developer (I think it was @Matt Ryall) and suggested adding a New Features request. Looks like this has been out there for a while. I hope this can make it to an upcoming release!

            Stephanie Gallert added a comment - - edited Currently if you do a search for users, the Find Users screen will return User, Full Name & Email. It would be great if it also returned Last Login (like JIRA). This would be especially helpful when managing an environment with Unlimited license and/self id creation. I recently attended Summit 2011 and spoke with Confluence Developer (I think it was @Matt Ryall) and suggested adding a New Features request. Looks like this has been out there for a while. I hope this can make it to an upcoming release!

            We'd really like to see this functionality.

            Unfortunately the above SQL doesn't work for me because we use Jira's user store.

            Jesse Reynolds added a comment - We'd really like to see this functionality. Unfortunately the above SQL doesn't work for me because we use Jira's user store.

            In Confluence 2.7 + (not positive through what version these queries are still reliable, you may have to try and see)
            The following queries (MS SQL) should be what you're looking for or at least get you going in the right direction:

            select u.name, p.date_val from users u
            join OS_PROPERTYENTRY p on u.id = p.entity_ID
            where entity_key='confluence.user.last.login.date'
            order by date_val desc

            There is an additional property value that stores the login date previous to the last login as well:
            select u.name, p.date_val from users u
            join OS_PROPERTYENTRY p on u.id = p.entity_ID
            where entity_key='confluence.user.previous.login.date'
            order by date_val desc

            In versions prior to Confluence 2.7, the user table was different and relied on os_users, something like this would work.
            select u.username, p.date_val from os_user u
            join OS_PROPERTYENTRY p on u.id = p.entity_ID
            where entity_key='confluence.user.last.login.date'

            Jason Schnell added a comment - In Confluence 2.7 + (not positive through what version these queries are still reliable, you may have to try and see) The following queries (MS SQL) should be what you're looking for or at least get you going in the right direction: select u.name, p.date_val from users u join OS_PROPERTYENTRY p on u.id = p.entity_ID where entity_key='confluence.user.last.login.date' order by date_val desc There is an additional property value that stores the login date previous to the last login as well: select u.name, p.date_val from users u join OS_PROPERTYENTRY p on u.id = p.entity_ID where entity_key='confluence.user.previous.login.date' order by date_val desc In versions prior to Confluence 2.7, the user table was different and relied on os_users, something like this would work. select u.username, p.date_val from os_user u join OS_PROPERTYENTRY p on u.id = p.entity_ID where entity_key='confluence.user.last.login.date'

            This functionality would definitely be useful. I'd be interested in finding out what that SQL statement was - please could you post that up here Geoffrey?

            Thanks.

            Mark Sheppard added a comment - This functionality would definitely be useful. I'd be interested in finding out what that SQL statement was - please could you post that up here Geoffrey? Thanks.

            GeoffreyC added a comment -

            I like this idea too. As a work-around right now, I have a rather complicated SQL query embedded in a

            {sql}

            tag in a page that spits out my users and their last login time.

            GeoffreyC added a comment - I like this idea too. As a work-around right now, I have a rather complicated SQL query embedded in a {sql} tag in a page that spits out my users and their last login time.

              Unassigned Unassigned
              3b1ae0ec93c9 Nick Minutello
              Votes:
              73 Vote for this issue
              Watchers:
              31 Start watching this issue

                Created:
                Updated: