Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 4

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
Level 4

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
Level 4

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 4

Hi @BrijeshYadav 

 

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