4 Replies Latest reply on Jan 27, 2020 12:07 AM by Bhavana Khairnar

    When was the last time user visited Tableau?

    Bhavana Khairnar

      Hi Guys,

       

      Can anybody help me with view, I want to see when was the last time user actually visited or used tableau from today's date? We are in process of revoking the license of users who have not used tableau from past more than 6 months, so that we can give that license key to someone else who actually need it.

       

      We do have one view in place, but its not giving correct result. Can anyone guide me which date column I should use from historical_events table of postgress? so that my view can be accurate?

       

      This is my query when was the last time users logged in into tableau.

       

      select users.login_at,

                users.system_user_id,

                system_users.email,

                system_users.friendly_name

           from

           system_users JOIN users

           on

           system_users.id = users.system_user_id

       

      Any help would be appreciated.

       

      Many Thanks,

      Bhavana