Last authentication login details

XMLWordPrintable

      As an administrator, I would like to be able to see which users haven't logged in in the past X months.

      Currently you'd have to perform the following query on the database:

      SELECT a.user_name, from_unixtime(b.attribute_value/1000) 
      FROM cwd_user a, cwd_user_attribute b 
      WHERE a.id = b.user_id and b.attribute_name = 'lastAuthenticated'
      AND from_unixtime(b.attribute_value/1000) between '2013-11-05 00:00:00' and CURRENT_DATE();
      

      That would be good if you could also see the details for each user on the screen just like you can do in JIRA:

              Assignee:
              Unassigned
              Reporter:
              ThiagoBomfim (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: