topic Re: is Alfresco support Download counter ? in Alfresco Archive

is Alfresco support Download counter ?

xeonyk — Wed, 25 Mar 2009 04:10:30 GMT

Is Alfresco support Download Counter ?I want get information about how much time one file has been download?Thx

Re: is Alfresco support Download counter ?

zaizi — Thu, 26 Mar 2009 13:00:25 GMT

Yes. There is a full audit service. Just need to configure it to track what you specifically require. More details: http://wiki.alfresco.com/wiki/Audit_Configuration

Re: is Alfresco support Download counter ?

xeonyk — Tue, 31 Mar 2009 09:15:51 GMT

I already read and try tutorial about audit in this website http://www.ixxus.com/blog/2009/03/whos-reading-your-documents/

i put <Method name="getReader" mode="all"/> in <Service name="FileFolderService" mode="none"> section in auditConfig.xml


<Service name="FileFolderService" mode="none">
    <Method name="rename" mode="all"/>
    <Method name="move" mode="all"/>
    <Method name="copy" mode="all" auditInternal="true"/>
    <Method name="create" mode="all"/>
    <Method name="delete" mode="all"/>
    <Method name="makeFolders" mode="all"/>
    <Method name="getWriter" mode="all"/>
    <Method name="getReader" mode="all"/>
</Service>
   
<Service name="ContentService" mode="none">
    <Method name="getWriter" mode="all"/>
    <Method name="transform" mode="all"/>
    <Method name="getReader" mode="all"/>
</Service>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

after that i restart server and i run alfresco, download and view content inside alresco. Then i run this query from mysql database


select fact.timestamp, convert(prop.string_value using utf8)
from alf_audit_fact fact
   join alf_audit_source source
      on fact.audit_source_id = source.id
         and ( 
                  (source.service = 'ContentService' and source.method = 'getReader') 
               or (source.service = 'FileFolderService' and source.method = 'getReader')
             )
   join alf_node_status ns on ns.guid = fact.node_uuid
   join alf_node_properties prop 
      on ns.node_id = prop.node_id 
‍‍‍‍‍‍‍‍‍‍‍‍‍

but my query show empty result, why my query in my mysql database return empty result? did i miss something?

Re: is Alfresco support Download counter ?

gengshg — Fri, 03 Apr 2009 05:08:24 GMT

From what I knew of Alfresco, audit is not complete, you would not work it out against your requirement!

Re: is Alfresco support Download counter ?

xeonyk — Tue, 07 Apr 2009 04:19:39 GMT

any suggestion for me??

Re: is Alfresco support Download counter ?

gengshg — Tue, 14 Apr 2009 08:39:17 GMT

Have a counter in your view layer is ok, such as user session.

To count from service layer might lose some access, such as http status 304.

Best Regard