List of Inactive users in AEM

[akhilraj]

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..

[Manu_Mathew_]

@akhilraj This blog might give you some insitghts on this:

https://medium.com/tech-learnings/adobe-experience-manager-reporting-on-users-last-login-date-e20350...

Hope this helps.

[smahesh]

Hi @akhilraj ,

Please follow this post it might be helpful in your case.

https://blogs.perficient.com/2017/02/23/managing-ghost-users-repository-growth-in-aem/

Thanks,

Mahesh 

[BrijeshYadav]

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%3Dselectiv...

[akhilraj]

Hi @BrijeshYadav : getting 0 result for this query execution

[BrijeshYadav · Accepted solution]

You can try with below 

p.hits=selective
p.limit=-1
path=/home/users
type=rep:Token
relativedaterange.property=rep:token.exp
relativedaterange.upperBound=-180d
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)