Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

How to get the list of users who are inactive past 60days?

Avatar

Level 5

Hi,

 

How can we get the list of users who are inactive past 60 days either by using query debugger or java code.

I referred this 

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/list-of-inactive-users-in-...

but not sure whether this is correct way bcz it only lists the users having tokens.

 

Thank you

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi ,

 

AEM by default doesn't capture user login timestamp and you will need to build a custom solution in order to achieve this.

 

Please check this wonderful article on details of how this can be achieved.

https://medium.com/tech-learnings/adobe-experience-manager-reporting-on-users-last-login-date-e20350...

 

Hope this will help you.

 

Thanks

 

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

Hi ,

 

AEM by default doesn't capture user login timestamp and you will need to build a custom solution in order to achieve this.

 

Please check this wonderful article on details of how this can be achieved.

https://medium.com/tech-learnings/adobe-experience-manager-reporting-on-users-last-login-date-e20350...

 

Hope this will help you.

 

Thanks

 

Avatar

Community Advisor

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/list-of-inactive-users-in-...


You can achieve by Query builder also. Check the below command

p.hits=selective
p.limit=-1
path=/home/users
type=rep:Token
relativedaterange.property=rep:token.exp
relativedaterange.upperBound=-60d
p.limit=-1

But it will give you duplicate entries in result because a user can have multiple tokens stored so to avoid duplicate entries you can run the token cleanup task (com.day.crx.security.token.impl.TokenCleanupTask) or with use some Java utility class.

Avatar

Level 5

Hi @BrijeshYadav 

 

Can we use property "rep:lastSynced" to check the login time. Instead of tokens, cz few users might not have tokens?

Avatar

Level 5

Yes, LDAP is integrated to higher aem environments.