is Alfresco support Download counter ?

[xeonyk]

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

Thx

[zaizi]

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

[xeonyk]

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?

[gengshg]

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

[xeonyk]

any suggestion for me??

[gengshg]

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