Skip to main content
March 6, 2024
Question

User login history of last 6months and 1 year

  • March 6, 2024
  • 2 replies
  • 0 views

Hi Team,

How can we pull the unique user login history for last 6 months and 1 year?

Eg: 

3 users - user1, user2, and user3

user1 - logged on 1st jan, 4th jan, 6th feb

user2 - logged on 6th feb

user3 - no login history

So, for last 6 months we have to get the list as user1 and user2 are active.

    2 replies

    mathieud0001
    Brainy
    March 6, 2024
    mikes0011
    Brainy
    March 6, 2024

    The info is all in the login audit files, however to get the historical logins you'll either need to go back through them manually, or build something to track daily logins to your database.

    The Expression Guru