Total User Count

[srobinson]

How does one find the total number of users in a repository?  It is not easy querying for users in the DB and I have not found a way through Admin Tools to get this count. 

I am using Alfresco 4.2.d Community.

Any insight into this is greatly appreciated.

Thanks,

- Shannon

[romschn]

You may want to take a look at - http://alfresco-for-developers.blogspot.in/2014/04/user-and-group-count-in-alfresco.html

[jpotts]

One way to do this is through a Lucene search. For example, you can go to the admin console to the node browser and run this Lucene search:

TYPE:"cm:person"
‍‍‍

On my local dev system I get, "Search for "TYPE:"cmerson"" found 14 results (search took 88ms)"

Note that in 4.3 we are introducing support for cmis:item which means you can do:

select * from cm:person
‍‍‍

And count the results that way. But that's currently only available in the 4.3 nightly builds.

Jeff

[jonvargas]

A very helpful tip Jeff, it worked fine for me. Thanks.