finding out users who contributed most(uploaded docs)

[rama_honge]

Hi,

I would like to know how to find out the user/users who uploaded most no.of documents. I had a look at the audit service, but could'nt find much details there

If anyone can provide some inputs regarding this would be really helpful..

Thanks in advance.

[kbonnet]

This is something you should be able to find out using the audit trail. Of course is has to be turned on, which by default is not. The audit trail is accessible only limited from Alfresco itself. It's ready to be queried from the database (alf_audit_*).

Since you only need the creator property, this might also be something to do with CMIS queries. I've seen COUNT statements work there. Not sure if this covers your needs.

Koen