Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.
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.