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

[keerthana_hn]

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

[KannanC · Accepted solution]

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]

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.

[keerthana_hn]

Hi @BrijeshYadav 

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

[BrijeshYadav]

Yes @keerthana_hn  but only if you have LDAP integration to your AEM.
https://helpx.adobe.com/in/experience-manager/kb/finding-LDAP-users-in-AEM-that-havent-logged-in-for...

[keerthana_hn]

Yes, LDAP is integrated to higher aem environments.