apatto03's Profile
Agile User
7
Points

Questions
1

Answers
1

  • RE: How to get all the users last login date in Agile 9.3.6
    Agile User Asked on August 25, 2021 in Product Collaboration.

    The following may help.

    SELECT
      A.LOGINID,
      A.EMAIL,
      A.LAST_NAME,
      A.FIRST_NAME,
      A.ENABLED,
      A.DATE_CREATED,
      MAX(B.LOGIN_TIME)
    FROM
      AGILE.AGILEUSER A
      LEFT JOIN AGILE.USER_USAGE_HISTORY B ON (A.LOGINID = B.USERNAME)
    WHERE
      A.ENABLED = 1
    GROUP BY
      A.LOGINID, A.EMAIL, A.LAST_NAME, A.FIRST_NAME, A.ENABLED, A.DATE_CREATED

    Regards,
    Drew

    • 1176 views
    • 2 answers
    • 0 votes