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.
Discussion posts and replies are publicly visible
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.