List of Inactive users in AEM

Question

Hi Dears,
 
Is there a way we can fetch list/details of users who did not logged into AEM from past 6 months?
Kindly provide info if any..

BrijeshYadav · Accepted Answer

You can try with below p.hits=selectivep.limit=-1path=/home/userstype=rep:Tokenrelativedaterange.property=rep:token.exprelativedaterange.upperBound=-180dp.limit=-1But 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)

BrijeshYadav · Answer

One way to find the list of inactive users past xx days is via Query Builder.

p.hits=selective
p.limit=-1
path=/home/users
type=rep:User
relativedaterange.property=lastLogin
relativedaterange.upperBound=-180d
p.limit=-1

http://localhost:4502/libs/cq/search/content/querydebug.html?_charset_=UTF-8&query=p.hits%3Dselective%0D%0Ap.limit%3D-1%0D%0Apath%3D%2Fhome%2Fusers%0D%0Atype%3Drep%3AUser%0D%0Arelativedaterange.property%3DlastLogin%0D%0Arelativedaterange.upperBound%3D-1d%0D%0Ap.limit%3D-1

Sign up

Login with SSO

Login to the community

Login with SSO