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

Question

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-aem/m-p/555260
but not sure whether this is correct way bcz it only lists the users having tokens.
 
Thank you

KNan · Accepted Answer

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

BrijeshYadav · Answer

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/list-of-inactive-users-in-aem/m-p/555626#M137930

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded