topic Re: Total User Count in Alfresco Archive

Total User Count

srobinson — Wed, 16 Apr 2014 16:23:50 GMT

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

Re: Total User Count

romschn — Wed, 16 Apr 2014 18:43:00 GMT

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

Re: Total User Count

jpotts — Wed, 16 Apr 2014 23:16:33 GMT

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

Re: Total User Count

jonvargas — Tue, 12 Aug 2014 23:03:11 GMT

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